Posted to microsoft.public.excel.worksheet.functions

PJ Murph[_2_] PJ Murph[_2_] is offline

external usenet poster

Posts: 19

Simplifying numerous checkbox procedures into 1 procedure

I have 400 checkboxes (beginning with cbCheck1 thru cbCheck400). How do I
write code that doesn't have to repeat this procedure 400 times?

Private Sub cbCheck1_Click()
Select Case cbCheck1.Value
Case True: LblOnHold1.Visible = True: LblOnHold1.PrintObject = True
Case False: LblOnHold1.Visible = False: LblOnHold1.PrintObject = False
End Select
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Separating sub procedures	JAW	Excel Discussion (Misc queries)	4	January 28th 09 12:17 PM
Stop a Procedure from another procedure	Ayo	Excel Discussion (Misc queries)	1	October 30th 08 01:42 AM
VBA function Procedures....	Arif[_2_]	Excel Worksheet Functions	1	June 3rd 08 01:54 PM
VBA functions and Procedures....	Arif[_2_]	Excel Worksheet Functions	1	June 3rd 08 10:27 AM

All times are GMT +1. The time now is 01:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us