ExcelBanter - Auto Quick Info

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto Quick Info (https://www.excelbanter.com/excel-programming/284314-auto-quick-info.html)

I have in Visual Basic Studio a feature that appears to be in the VBA for
excel.

When I start typing a line of code the program will automatically popup with
suggested and valid methods that are associated with it. I think this is
called Auto Quick Info.

I have this set on in Excel but it is not doing the popup.

Is there another setting somewhere to turn this functionality on?

Thanks alot.

Sharlene England

You have to declare your objects/variables for this to work.

--
Regards,
Tom Ogilvy

"Sharlene England" wrote in message
...
I have in Visual Basic Studio a feature that appears to be in the VBA for
excel.

When I start typing a line of code the program will automatically popup
with
suggested and valid methods that are associated with it. I think this is
called Auto Quick Info.

I have this set on in Excel but it is not doing the popup.

Is there another setting somewhere to turn this functionality on?

Thanks alot.

Sharlene England

Check Tools, Options, Editor in the VBE.

--
Jim Rech
Excel MVP