3

I've had a good search if this is possible and I doubt it but can anyone confirm: is there any way to have the IDE provide intellisense in the same way as say Visual Studio in the .Net family i.e. it's automatic, no need to press Ctrl+Space for a new item?

The object.period functionality is fine but it would be great if it could for example predict which of your variables you want next, so If I dim a recordset called rst and start typing "Set" then a list of declared objects would show, including rst, again, just like in .Net. Thanks.

Absinthe
  • 524

1 Answers1

0

Sadly, this functionality doesn't exist (perfectly) within the native VBA IDE.

Some people report checking "Auto List Members" in Tools > Options helps.

wizlog
  • 13,573