Auto Member List in Excel 2004

[Li Jianyong]

Dear Sirs,

I have just got a Mac OS and installed a Excel 2004. When I open the VB
Editor,I can not found the Auto member list when I write some code. I don't
know if it is not included in this Excel 2004 at all.

Please help!

r

 

[Chip Pearson]

I don't speak Mac, but you should first go to the Tools menu in the
VBA editor, choose Options, then the Editor tab. There, you should see
the checkboxes that enable Intellisense. In general, all the
checkboxes in the "Code Settings" group should be checked.

If these are not present or grayed out, then Instellisense is not
supported on the Mac.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)