LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Books on "how to" program macros in Excel using VBA

I need help in finding a book to help me to learn how to program macros in
Excel using VBA. I'm fairly confident in my ability to write the code I need.
But I BADLY need help in the simple & mundane tasks of creating menus, macro
buttons, custom dialog boxes. I need "hold my hand, draw me a picture,
step-by-step" instructions on -

1.) How do I create a menu that the user will see first thing after
double clicking
to open the sheet?
2.) How do I "attach" the menu to my code so that when the menu choice is
clicked the code will activate?
3.) How do I create macro buttons (proper term?) that will appear on a
sheet?
And how do I "attach" them to my code?
4.) In short any help at all in the reccomendation of books that will
teach me
how to do things of that nature will be sincerely appreciated.

--
Gary
Houston, Texas USA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"excel "macros may be disabled" message using an xlam file frustrated Excel Worksheet Functions 2 July 13th 09 08:32 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"openinf file..."ENABLE MACROS...DISABLE MACROS" F. Lawrence Kulchar Excel Discussion (Misc queries) 3 September 12th 06 10:33 AM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" VJ[_3_] Excel Programming 0 December 11th 03 09:01 AM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"