Problem with the VBA / Excel interface
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. |
All times are GMT +1. The time now is 06:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com