Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet event for tick box
Would be very grateful for any help on this one..
I'm trying to create a form that will bring up a sheet in excel when the "tick to continue" tick box is checked. I've read the bits on worksheet events but haven't got a clue how to adapt to my use - only ever used the macro recorder and done bits of changes to existing visual basic. Basically, I would like to have the form select 1 of 3 different sheets depending upon the value of a cell, say A1, which is defined by other entries made earlier and I'm thinking of using the tickbox as the trigger but any other option considered! many thanks David ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet event for tick box
David,
I seriously suggest you not use a tick box (checkbox) as a trigger to continue. Generally, most programmers would use a button labelled "Continue" or "Next", and for the sake of consistency amongst applications, I would urge you to use a button. Not only is it more consistent, but easier to write the code e.g. assume the trigger values in cell A1 are 1, 2 or 3. Sub cmdContinue_Click() select Case Range("A1").value Case 1 Sheets("Sheet1").select Case 2 Sheets("Sheet2").select Case 3 Sheets("Sheet3").select Case else msgbox("The value in Cell A1 is not within the appropriate values, please recheck your selections and click Continue again") End Select End Sub Steve "David Berry" wrote in message ... Would be very grateful for any help on this one.. I'm trying to create a form that will bring up a sheet in excel when the "tick to continue" tick box is checked. I've read the bits on worksheet events but haven't got a clue how to adapt to my use - only ever used the macro recorder and done bits of changes to existing visual basic. Basically, I would like to have the form select 1 of 3 different sheets depending upon the value of a cell, say A1, which is defined by other entries made earlier and I'm thinking of using the tickbox as the trigger but any other option considered! many thanks David ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with worksheet event | Excel Worksheet Functions | |||
how to call the event of other worksheet | Excel Worksheet Functions | |||
Worksheet Change Event | Excel Discussion (Misc queries) | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
macro to apply worksheet event to active worksheet | Excel Programming |