Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in VBA turned off
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in VBA turned off
Selection doesn't have an autocomplete list, since the selection can be a
range object, a chart object, a commandbutton, a drawing object, etc. Procedures are part of some other object, like Application, so you type Application. to get an autolisting of procedures and properties for Application. HTH, Bernie MS Excel MVP "Spammastergrand" wrote in message ... How come I don't have autolist in my Excel XP VBA window. For example, if I hit CTL-G and type Selection. nothing pops up. The same goes for procedures. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in VBA turned off
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in VBA turned off
Using the codename for the sheet will:
Sheet1.Range("L18"). or just using the range will: Range("L18"). Any time there is any ambiguity or doubt on Excel's part, it clams up and is unhelpful.... HTH, Bernie MS Excel MVP "Spammastergrand" wrote in message ... You're right. But how about sheets(1).range("L18"). I could swear that used to bring up a list. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete in VBA turned off
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a cell be turned on and off? | Excel Discussion (Misc queries) | |||
MACROs Are Turned Off | Excel Discussion (Misc queries) | |||
AutoSum turned off? | Excel Discussion (Misc queries) | |||
Worksheet has turned | Excel Worksheet Functions | |||
Application Turned Off | Excel Programming |