View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin B[_3_] Kevin B[_3_] is offline
external usenet poster
 
Posts: 20
Default MSGBOX, InputBox or some other method question

I would use a VB form for all questions and responses and limit the number of
popup dialog boxes.

Press Alt + F11 to open the Visual Basic Editor, click on INSERT in the menu
and select USER FORM.

You can write the responses captured by the form back to your workbook when
all questions have been answered by your user.
--
Kevin Backmann
Dallas, TX


"Don M." wrote:

I am writing a simple macro to ask the user a few questions. The first three
questions are straight answers that the user types in themselves. I have that
working with a standard Application.InputBox() statement. On the fourth pop
up box I need to have three buttons that the user can click on. The button
that is clicked on then routes to one of three different parts of the macro
and continues running thorugh the macro.

To be specific, the user will be asked, "What grade is the student in?". I
want these three choices to be on this window, K/1, 2/3 and 4/5. By clicking
on one of these three buttons/choices I then need to direct the macro to one
of three corresponding sections of code.

How do I get a custom named button to appear in a pop up window?

Don