| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initialising a variable
Hi All
I am coding in VBA and a lot of effort will be saved if I can initialise a variable to the index no of the object whose method I am defining Like suppose this event is triggered ComboxBox13_LostFocus( then a variable x should be assigned the value 13 Any help please thank Shilps |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Initialising a variable
There is no automatic way, it would have to be handled manually.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Shilps" wrote in message ... Hi All ! I am coding in VBA and a lot of effort will be saved if I can initialise a variable to the index no of the object whose method I am defining. Like suppose this event is triggered ComboxBox13_LostFocus() then a variable x should be assigned the value 13. Any help please. thanks Shilps |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Initialising a variable
How? I am looking for any function that might return the parent object name, but couldn't.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Error 91 - Object variable with block variable not set | Excel Programming | |||
Linear Mode
