| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox load event
I have a userform with a listbox. The listbox displays a string from another
function. Is there a way to run the function code once the userform becomes visible or open? Im not able to find a open event. Any help will be appreciated. -- PK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox load event
If I understand your question correctly, you can use the UserForm's
Initialize event to do that. Rick "Patrick Kirk" wrote in message ... I have a userform with a listbox. The listbox displays a string from another function. Is there a way to run the function code once the userform becomes visible or open? Im not able to find a open event. Any help will be appreciated. -- PK |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox load event
On 23 Gru, 04:50, "Rick Rothstein \(MVP - VB\)"
wrote: If I understand your question correctly, you can use the UserForm's Initialize event to do that. Rick "Patrick Kirk" wrote in message ... I have a userform with a listbox. The listbox displays a string from another function. Is there a way to run the function code once the userform becomes visible or open? Im not able to find a open event. Any help will be appreciated. -- PK You could use form initialie option I agee pz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listbox selection to load to new form | Excel Programming | |||
| How to load a listbox in a userform? | Excel Discussion (Misc queries) | |||
| Load data into a listbox | Excel Programming | |||
| Listbox initialized on workbook load | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
