In that case you should consider to build your own userform.
(which sounds harder than it is.)
You should find some nice tutorials online.

If you have any problems, just ask.

Cheers

Carlo

On Nov 28, 5:14 am, Ant wrote:
Thanks for your reply. Do you know if it is possible to have a box with the
selection built in? Perhaps a drop down arrow with both choices available.
This would allow the user to simply select an option without having to type
in anything.



"JLGWhiz" wrote:
The simplest method would be the input box.

Sub opt1or2()
myOpt = Application.InputBox("Enter either a 1 or a 2.", "Pick Option",
Type:=1)
If myOpt = 1 Then
Call Macro1
ElseIf myOpt = 2 Then
Call Macro2
Else
Exit Sub
End If
End Sub

You can attach this to a button from the forms tool bar or the ToolBox tool
bar. See VBA help for using the ToolBox button.

"Ant" wrote:

I have 2 macros which I would like to combine into one. Basically I would
like the user to start the macro (push a button) and a window/balloon or
something will pop up with the choice of option 1 or option 2. Choosing
option 1 will run macro 1 and choosing option 2 will run macro 2.

Thanks in advance.- Hide quoted text -

- Show quoted text -