VBA autocomplations

Copper Contributor

Hey guys ,

why my excel VBA environment don't have auto completion help ,so i have to write the code without editor help ?

3 Replies

@bobey90 

In the Visual Basic Editor, select Tools > Options...

Make ure that the check box 'Auto List Members' is ticked.

S1743.png

Hey @Hans Vogelaar ,I Did but its still no functional.  

@bobey90 Try repairing your Office installation, and if that doesn't work, reinstalling it from scratch.