In the VBE, Click Tools--Options. On the Editor Tab check "Auto List
Members"

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Martyn" wrote in message
...
I must have done something wrong. While I was in the VBE Editor working on
a
macro, Excel2000 used to show me suitable commands as I type in...Now
suddenly it stopped. I'd appreciate if someone help me correct this.
TIA
Martyn