Excel 20130 VBA inline suggestions

spyla

New Member
Joined
Jan 18, 2011
Messages
16
I seem to remember, maybe in excel 2003 VBA, as you are writing vba code suggestions would show up

for example if i typed

Sheets("Sheet1").

after I typed period, suggestions like cells, add, delete, move.... would show up

I am using 2013, how do i get this functionality
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
spyla

I notice the same thing. It works sometimes but not always. Hopefully someone here will explain it to us. I know if you type "Vba." then it will popup but it gives you a whole list of functions
 
Upvote 0
spyla

I notice the same thing. It works sometimes but not always. Hopefully someone here will explain it to us. I know if you type "Vba." then it will popup but it gives you a whole list of functions

when I tried vba. it gave me suggestions but not for my example
 
Upvote 0
Compile errors can break Intellisense. Get a clean compile, then resume coding.
 
Upvote 0
If you type this: "Cells." then it will popup a list of suggestions like "activate"
 
Upvote 0

Forum statistics

Threads
1,222,095
Messages
6,163,900
Members
451,865
Latest member
dunworthc

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
Back
Top