Custom Menus, Toolbars, etc

  • Thread starter Thread starter Jason Paris
  • Start date Start date
J

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
 
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
 
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
 
Back
Top