What you are talking about is intellisence and it is built into XL VBA. That
being said there are a few stipulations. Anything starting with the word
Active does not come with intellisence. Any objects that are not declared
also will not have intellisence. Additionally there are a few quirks like
Range has intellisence while Cells does not (dispite the fact that both
return a range object).

Things to try... Note some will have intellisence while others won't
Sub test
Dim rng1 as range
Dim rng2 as variant
dim wks1 as worksheet

set wks = Activesheet
set rng1 = wks.range("A1")
set rng2 = wks.range("A1")

'Add the dot to each of these
activesheet
rng1
rng2
wks.range("A1")
wks.cells(1, 1)
Worksheets("Sheet1")
Sheet1

end sub

--
HTH...

Jim Thomlinson


"Curt" wrote:

downloaded a MVP word VBA basics showing procedure writing. Article by Bill
Coan Following his instructions Sub Test typeing ActiveDocument(.) a pop up
list apears. Noticed that references was showing on left project window how
can I get this same action in Excel. Possible?
Thanks