WITH or not WITH

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Unless your With/End With block is inside a time-critical loop it won't matter one bit, so I don't see a reason to avoid using it. The With/End With block is actually good to use for the sake of clarity.

Cheers!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
gshawn Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 04 October 2004 Status: Offline Points: 227	Post Options Post Reply Quote gshawn Report Post Thanks(0) Quote Reply Topic: WITH or not WITH Posted: 12 July 2007 at 2:56am
	Unless your With/End With block is inside a time-critical loop it won't matter one bit, so I don't see a reason to avoid using it. The With/End With block is actually good to use for the sake of clarity. Cheers!

Bernie Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 05 July 2007 Location: Taiwan Status: Offline Points: 109	Post Options Post Reply Quote Bernie Report Post Thanks(0) Quote Reply Posted: 11 July 2007 at 9:38pm
	Yes, it's a silly question. I read all the samples that the CodejokeSoftware provided, but there are few "WITH ... END WITH" statements. The following codes are mine. I used "WITH ... END WITH" statement to make the program more efficient. Do you experts agree to avoid using "WITh ... END WITH" ? Dim RB As RibbonBar With CommandBars1 Set RB = .AddRibbonBar("main") With RB .AddSystemButton .AllowMinimize = False .AllowQuickAccessCustomization = False .AllowQuickAccessDuplicates = False .Closeable = False .Customizable = False .EnableFrameTheme .ShowQuickAccess = False .ShowGripper = False End With End With