ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Initialising a variable (https://www.excelbanter.com/excel-programming/293765-initialising-variable.html)

Shilps

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

Bob Phillips[_6_]

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




Shilps

Initialising a variable
 
How? I am looking for any function that might return the parent object name, but couldn't.


All times are GMT +1. The time now is 12:23 PM.

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