simple vba question

J

Jonathan Cooper

example
Sub test2()
'counts number of comments

Dim cmnts As Long
cmnts = ActiveSheet.Comments.Count
MsgBox cmnts
End Sub

When I type

activesheet.
(Notice the period at the end)

Why doesn't VBA then automatically show me the properties/methods of
Activesheet?
 
B

Bob Phillips

Because the activesheet could be a worksheet a chart sheet, etc., so it
cannot know what to present, so it gives nothing.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

Jonathan Cooper

Makes sense. When I started to type that, and nothing happened, I thougth
that there was something wrong with what I was trying to do.

thanks.
 
D

Duke Carey

Bob's answer is correct. To get the prompts you want use a variable that has
been DIMmed as a Worksheet, i.e.

DIM ws As Worksheet

then when you type "ws." you'll get the prompts you seek

Duke
 
Top