I have recorded three macros. to be deployed to various users. My intent is to move the macros into each users Personal.xls and to place three appropriatly linked icons on their toolbars. It occurs to me that there must be away to place all three macros into a single statement, but provide dialogs between each set of actions that would allow the user to bail out or proceed depending upon which is appropriate to their needs.
I'm hoping there is an obvious answer that as a novice I am just missing. Thanks in advance for you input. Mike
This conversation is currently closed to new comments.
There are multitudes of ways to do what you are asking. Perhaps the most basic way to do so is utilize message boxes between the calls to each routine. Message boxes can display a prompt with a Yes/No question which your code can react to. The sample assumes you have recorded three routines you are trying to call. This routine will prompt you to run each one, if yes continue, no stop. You will get a message box for each routine.
Public Sub Main() Dim intContinue As Integer intContinue = MsgBox(prompt:="Execute routine1?", Buttons:=vbYesNo)
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Macros with User Interaction
I'm hoping there is an obvious answer that as a novice I am just missing. Thanks in advance for you input. Mike