Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with auto list members in VBA
Ok i have a problem with auto list members in Visual
Basic Editor, when i record macro in excel it write me in module1 a line VB CODE: Sheets("Sheet2").Select ok when i try to write VB CODE: Sheets("Sheet2"). and then press "CTRL+SPACE" wont't show list members. I need this. I choose the excel 10 reference,...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with auto list members in VBA
Auto list members does not work with the Sheets method
(for some reason?) or Worksheets(..) or several other methods. An alternative is to use the sheet's object name as seen in the object tree view. Note that this may be different to the tab name for the sheet. E.g. Sheet1.Activate Cheers, Dave. -----Original Message----- Ok i have a problem with auto list members in Visual Basic Editor, when i record macro in excel it write me in module1 a line VB CODE: Sheets("Sheet2").Select ok when i try to write VB CODE: Sheets("Sheet2"). and then press "CTRL+SPACE" wont't show list members. I need this. I choose the excel 10 reference,...... . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with auto list members in VBA
I sometimes declare a variable just so I can get that help.
Dim wks as worksheet set wks = worksheets("sheet2") wks. that dot will cause good things to happen. Blegos wrote: Ok i have a problem with auto list members in Visual Basic Editor, when i record macro in excel it write me in module1 a line VB CODE: Sheets("Sheet2").Select ok when i try to write VB CODE: Sheets("Sheet2"). and then press "CTRL+SPACE" wont't show list members. I need this. I choose the excel 10 reference,...... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
How do I obtain the average age of our members? | Excel Worksheet Functions | |||
enumeration members | Excel Worksheet Functions | |||
Adding a List of Members to a shared workspace | Excel Discussion (Misc queries) | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions |