![]() |
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. |
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