Tag Archives: Intellisense

A Guided Tour Through The VBA IDE’s Options

The VBA Integrated Development Environment provides a limited set of options under Tools > Options which will let you customise the environment for your own personal needs. Microsoft hasn’t added anything new to this part of MS Office for many years … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , | 8 Comments

Making Sense Of Cells Intellisense – Part 2

I’m going to follow on from my last post by demonstrating a VBA IDE Intellisense bug when using the Cells property. In my earlier post I used the Worksheet.Cells property but here I’m going to use Range.Cells to avoid Out of Memory … Continue reading

Posted in Microsoft Excel | Tagged , , , , , | 1 Comment

Making Sense of Cells Intellisense – Part 1

A friend of mine asked me a good question today: Why is it that when I type Cells. into the VBA IDE I get Intellisense whereas when I type something like Cells(1). or Cells(1,1). I don’t? Being a strong VBA programmer … Continue reading

Posted in Microsoft Excel | Tagged , , , , , | 5 Comments