ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Userform Commands - Switching Question (https://www.excelbanter.com/excel-discussion-misc-queries/197148-userform-commands-switching-question.html)

pallaver

Userform Commands - Switching Question
 
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.

pallaver

Userform Commands - Switching Question
 
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()


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com