Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable form control
I have two macros reading data from one of two userform listboxes.
These macros are actually the same but the used listbox. I'd like to use just one code with variable listbox but I just don't know: how to declare it? Thanks for any experience. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable form control
Roman,
In brief... In the form code Sub lstSomething_Click DoSomething lstSomething End Sub 'In a general module Sub DoSomething(lstName as MsForms.ListBox) With lstName msgbox .listcount End With End Sub Robin Hammond www.enhanceddatasystems.com "Roman" wrote in message ups.com... I have two macros reading data from one of two userform listboxes. These macros are actually the same but the used listbox. I'd like to use just one code with variable listbox but I just don't know: how to declare it? Thanks for any experience. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable form control
Thank you much.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Variable Reference to a Form Control | Excel Programming | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
passing control value from one form to another form | Excel Programming |