Userform Commands - Switching Question

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.
 
P

pallaver

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top