Could you not use the Worksheet_Activate() event to store the name of the sheet into a public variable and then use the Worksheet_Deactivate() event to check whether the name has changed and if so run further code to update your list i.e.
Public strName as string
Private Sub...
Hi,
I am trying to write some code that will list all the Drive Letters (i.e. C:\, E:\ etc) that are available on a users computer so I can add the return values into a Combo Box on a form in Excel 2000.
For each one of the Letters I would like to list all available Folder Paths into a separate...
I am trying to add a the XL graph object to a form but it dosen't seem to see the data from the sheet i've selected. Could anyone tell me how i populate the Graph Object with data?
Kind regards
Mark
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.