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

In article . com,
says...
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