General question when typing & seeing options in vba editor

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
4,079
Office Version
  1. 2007
Platform
  1. Windows
Morning,

More often than not when im typing in the vba editior i dont see the options drop down selector appear.

I mean if i start to type .Font a list of available options that can follow are then shown & you then select one so its then prefilled for you.

What am i doing wrong ?

Thanks
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,352
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Intellisense only works if the editor can determine the type of object that is being referenced. So if you type Activesheet followed by a dot for example, you won't get intellisense since Activesheet returns a generic Object type (the active sheet could be a Chart rather than a Worksheet). If you declare a variable as a Worksheet, then typing a dot after the variable name will provide Intellisense options since the editor knows that variable is a Worksheet (even if you assigned it using Activesheet)
 
Solution

Forum statistics

Threads
1,141,402
Messages
5,706,239
Members
421,433
Latest member
yash0468

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top