Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
Here is my problem which hopefully somebody can assist with: I have a userform (Critique) which has a number of combo boxes added to it dynamically because the amoun of these boxes can vary depending on other cicumstances. I now have a need to classify each combobox into one of two categories - the way I do this is through using the tag property to differentiate. Depending on the tag proprerty (say it is either 1 or 2) for the currently in use Combobox, I need it to then make a textbox visible and another invisible - and vice versa. In other words, I have 2 textboxes to grab input but which textbox is visible depends on the tag of the combobox that is currently active. I tried to do a class module for the "Enter" event but it doesn't work. The "Change" event works but this will not be good enough for me as it will require information to change before it runs whereas I want the class module to run the moment somebody tabs into the combobox or clicks into it. If somebody can please help it would be appreciated and I extend my thankyou in advance. Regards, Clint |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
MsgBox in ComboBox Enter Event does not allow update | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
Further Clarification with Event Handlers & Class Modules | Excel Programming | |||
Event - RaiseEvents Within Class Modules | Excel Programming |