references
 

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

references
 

Excel is not set up to show references in the project window. However, if
you go into the VB editor window and click Tool References it will display
a pop up dialog box with the References menu and the checked boxes indicate
the active references for your project.

"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

references
 

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