Question re 'VBA and Macros for Microsoft Excel'

[mattty]

I have just bought this book. On p.6 there is a note saying that a list of general differences between VBA on Mac platforms can be found at http://www.mrexcel.com/macvba.html, which doesn't seem to exist.

Any ideas on if this has been moved, or if it is even still relevant?

 

[starl]

I don't have anything "pretty" and i have had a chance to test on the latest Macs, but here's a list I use:

• application.screenupdating doesn't work
• usersforms - don't recommend using big labels. We have no control over the fonts, so it can cause a problem. Actually, the more we can avoid UserForms, the better
• ActiveX controls - do not work; have to use Form Controls
• No dlls. That means if you want to let the user lookup a file, you have to do it the hard way
• Functions: some VB functions may not be available - like split, replace
• Database files: not allowed
• Best rule: Program as if the user has Excel 97