Problem with the VBA / Excel interface

D

Dom

I'm just getting back to VBA for Excel, and I am now using Excel
2007. One thing in the VBA studio bothers me. The Intellisense
window sometimes does not pop-up. Usually, it fails to pop up after
the second level. For example, if I want to activate the first sheet
in the first book, I type "Workbooks(1).WorkSheets(1)". The
intellisense window does not come up to give me the properties and
methods exposed by the Worksheet. Can I change this?

Oddly, if I type "Dim s as Excel.Worksheet", then typing "s" will give
me the intellisense window that I want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA fails with Run-time Error 429 "ActiveX component can't create object" 1
Template with fields and premade texts.. 0
Doughnut Chart linked with the slicer in the pivot table 0
Need Help with a VBA subroutine 0
VB.NET Inserted Picture Ends Up in Wrong Cell 1
Word VBA DocumentMapPercentWidth Runtime Error 5891 3
Windows Script Host in Excel VBA 10
Big Problem with Excel 2000 / 2003 3

Top