Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

VBA - sub routines Help please

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard Wrigley - 22 Nov 2006 18:13 GMT
Greetings from Norfolk
I am trying to create a 'accounts' routine that allows the user to select
first (A) what they want to do (enter sales, monthly account etc.) then (B)
to select the month that they wish to work on.
I used buttons to select the first (A), then the macro that runs from the
button (common to all three butons) to display the list box (B) to select
the month.
The problem is that I cannot find a way to save the information on which
button has been operated to start the process.  The macro that runs from the
button (A) does not connect with the macro that runs FROM the pull down
list - they appear as two distinct routines.

--
Richard.

"I have yet to see any problem, however complicated, which when looked at in
the right way, did not become still more complicated"
Poul Anderson
Richard Wrigley - 22 Nov 2006 18:36 GMT
Greetings from Norfolk
I forgot to mention that I am running Excel 2000 should this be relevant

--
Richard.

"I have yet to see any problem, however complicated, which when looked at in
the right way, did not become still more complicated"
Poul Anderson
PapaDos - 23 Nov 2006 01:27 GMT
You seem to be using a button from the "Forms" toolbar.
If so,
application.caller
should give you the button's name...
Signature

Regards,
Luc.

"Festina Lente"

> Greetings from Norfolk
> I am trying to create a 'accounts' routine that allows the user to select
[quoted text clipped - 14 lines]
> the right way, did not become still more complicated"
> Poul Anderson
CLR - 23 Nov 2006 03:06 GMT
What I would normally do in a situation like yours, is to have three
individual master macros for each of my major choices, A, B or whatever, and
have them do and control the things that are unique to that selection, and
to call up any universal macros if and when needed as a step in the
procedure..........but the master
selection macro would be in control until the exercize was completed.

hth
Vaya con Dios,
Chuck, CABGx3

> Greetings from Norfolk
> I am trying to create a 'accounts' routine that allows the user to select
[quoted text clipped - 14 lines]
> the right way, did not become still more complicated"
> Poul Anderson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.