Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Autocomplete in VBA turned off

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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Autocomplete in VBA turned off

You're right. But how about

sheets(1).range("L18").

I could swear that used to bring up a list.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Autocomplete in VBA turned off

Okay. I've been using cells a lot more than range recently. I thought Range
listed properies and methods. I don;t see why it doesn't when youre even more
specific, like listing a sheet first.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a cell be turned on and off? painter50 Excel Discussion (Misc queries) 1 March 2nd 10 04:27 PM
MACROs Are Turned Off DOUG ECKERT[_2_] Excel Discussion (Misc queries) 1 December 2nd 08 10:44 PM
AutoSum turned off? Leslee Excel Discussion (Misc queries) 2 June 2nd 08 01:27 PM
Worksheet has turned TeeJay Excel Worksheet Functions 0 January 12th 06 08:44 AM
Application Turned Off Nigel[_4_] Excel Programming 1 October 11th 03 11:27 AM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"