Data validation in a MSG box

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Does anyone know how I can get a MSGbox to pop up when I
run a macro that list only certain items, then once the
item is selected the program will run the macro that was
created already for that selection. Similar to Data
validation only I need this to pop up one the program
opens.

Thanks in advance.
Pete W
 
Pete,

Sounds like you need to create a userform with some
command buttons on it. Once you create the form, you can
have it open when the worksheet opens. Then, you can link
specific macros to the buttons on that form.

In the VBA Help, type in userforms for more information!

Chan
 
Chan

You lost me. But maybe I did not make myself very clear.
When I run a certain macro I want the first dialog box to
pop up and say "what formula do you want to figure out"
Under that I need a validation box with about 15 possible
entries in it. When the user select one of them , that
certain macro will run and calculate the formula.

Any new idea's will be helpful.
Thanks
Pete W
 
Back
Top