Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So I have a listboxA populated with colors.
I want it so that the user can pick a color, and it appears in another listbox (listboxB) to the right. Is there a way to have listboxB updated without exiting the userform and using userform_activate() to populate listboxB? I could just make the userform run in a loop so that each activate updates. Oh wait, can I call user_activate() from a listbox_click() command? I'll try that. Any tips welcome, thanks, np. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yay for answering my answering my own question.
Initialize versus Activate - The former being the first time, the last being an update cycle. Private Sub UserForm_Activate() Private Sub UserForm_Initialize() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Another Userform question. | Excel Discussion (Misc queries) | |||
Userform Question | Excel Discussion (Misc queries) |