Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a UserForm with four frames; each frame groups 5 OptionButtons and a
fifth frame has 6 OptionButtons. Everytime a user clicks on one of the OptionButtons, I'd like a value to be updated in a TextBox (depending on which OptionButton is clicked). OptionButton1 adds 1 to the Textbox, OptionButton2 adds 2, etc. I know I can do this using a Sub OptionButton1_Change() procedure (creating 26 procedures) but is there a more efficient way to do it? Thanks. Bert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Change event and calculate event | Excel Programming | |||
change event/after update event?? | Excel Programming |