Userform Commands - Switching Question

  • Thread starter Thread starter pallaver
  • Start date Start date
P

pallaver

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.
 
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()
 
Back
Top