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
-----Original Message-----
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
.

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

-----Original Message-----
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
-----Original Message-----
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
.

.

You lost me. But maybe I did not make myself very clear.

Or maybe you thought the solution was irrelevant because you never heard of
it and didn't investigate further. Chan is correct, you need a userform with
a listbox or a combobox on it. Here's how to get started:

http://www.microsoft.com/OfficeDev/A...PG/012/012.htm
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Pete" skrev i melding
...
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

-----Original Message-----
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