simple vba question

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?

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)

"Jonathan Cooper" <JonathanCooper@discussions.microsoft.com> wrote in
message news:4357BECE-299D-4E9F-BBE6-84854013450B@microsoft.com...
> 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?
>
>

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.

"Bob Phillips" wrote:

> 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)
>
> "Jonathan Cooper" <JonathanCooper@discussions.microsoft.com> wrote in
> message news:4357BECE-299D-4E9F-BBE6-84854013450B@microsoft.com...
> > 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?
> >
> >
>
>
>

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

"Jonathan Cooper" wrote:

> 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?
>
>

Oops, left out one part

DIM ws as Worksheet
Set ws = Activesheet



"Jonathan Cooper" wrote:

> 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?
>
>