Missing Paramenter List

[Guest]

Hi!

I am new to programming in Excel 2000 and have the following problem.

if I type the following code

dim rg as range

Set rg = Worksheets(1).Range("B1:B50")

when I type

"rg."

no property list pops up and rg is not a variant

This is happening with many other properties and objects

What is going on?

 

[Rob van Gelder]

Looks good to me...

This procedures works fine inside a standard module:

Sub test()
Dim rg As Range

Set rg = Worksheets(1).Range("B1:B50")

rg.Select
End Sub

 

[Guest]

Rob,

this is not what I am asking for. I just want to know why the property list
for the rg object is not automatically displayed when I type "rg."

These two sentences make rg an range-type object

Dim rg As Range
Set rg = Worksheets(1).Range("B1:B50")

Therefore, should display automacally the property list for the range object
when I type "rg."

Thanks

 

[Rob van Gelder]

Sorry - I should have been clearer with my response.

With the code I replied with, when I typed the fullstop in rg.Select,
Intellisense displayed the property list.

I don't think it's your code, but something external to that code block
interfering.
Try to put that code block into a new workbook and see what happens.

 

[Bob Phillips]

Jess,

Do you have it enabled?

In VBA, go to the Tools>Options, then on the Editor tab. There, check that
"Auto Data Tips" is checked.