Custom Menus, Toolbars, etc

[Jason Paris]

Hi folks,

Forgive my utter ignorance of VBA......years ago I used to do quite a
lot of Excel programming with the old "Command Macro Language", but
never got started with VBA.

However, a project has arrived that requires me to create an Excel
"application"........ie, custom menus, toolbars and dialog boxes. I
used to find this stuff easy with the Macro Language, and I'm sure it
is with VBA too......for an experienced user.

Was wondering if someone would be able to give me some clues as to how
to begin, or direct me to a site that could provide similar
information.

Thank you in advance,

Jason Paris

 

[Tushar Mehta]

Check out the local library / bookstore / amazon.com There are several
websites you might find useful. Maybe, a good starting point is David
McRitchie's http://www.mvps.org/dmcritchie/excel/excel.htm

As far as menus and toolbars go I strongly recommend a data-driven approach.
A great starting point is John Walkenbach's
http://www.j-walk.com/ss/excel/tips/tip53.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

See my comments on books in a few posts previous (Any good books?)

I also mention some lessons at:

Gary Redley: http://users.bigpond.net.au/gradley/vbatutor/
Pan Pantziarka: http://www.techbookreport.com/tutorials/excel_vba1.html

VBA is really the basic programming language with the MS object model for
excel/office on top to allow the GUI access.

 

[NickHK]

Jason,
If it is sufficient for your needs, you can still use the Excel 4 macro
sheets to control Excel.

According to http://visio.mvps.org/Excel_2007.htm
"Compatibility
Excel 4 macros will still work."

VBA is certainly to way to go now, but depends if you wish to learn it if
you happy with macro sheets.

NickHK