Popup box help?

[Guest]

I would like to create a popup box that prompts the user to enter several
pieces of information that would be used to fill cells upon hitting enter. A
text string and a number will be used to fill two cells. It should also fill
a given cell "A1" with a macro "Macro", the contents of which are not
important for the user to know (does not need to display it to the user other
than on selecting that cell.) The event that activates the popup box needs
to be a specific entry in a particular cell (for instance, entering "B" in
the cell "C1" and hitting enter activates the popup box, but any other entry
does not. Anyone out there with the knowledge to do this without a huge time
investment? Turns out I'm way out of my league on this particular project.
Time to take a VBA class! Thanks in advance for the time!
-KAi

 

[Susan]

you'll need a userform, not just an excel pop-up one-liner entry
box...........

http://www.contextures.com/xlUserForm01.html

this is a good tutorial on userforms..... will (unfortunately) take
some time to learn & implement if you want to do it yourself. it's
very difficult for someone to design such a project on the internet;
we can post code, but not design userforms. somebody will have to do
it by e-mail if they want.

susan

 

[Ferris]

I would like to create a popup box that prompts the user to enter several
pieces of information that would be used to fill cells upon hitting enter. A
text string and a number will be used to fill two cells. It should also fill
a given cell "A1" with a macro "Macro", the contents of which are not
important for the user to know (does not need to display it to the user other
than on selecting that cell.) The event that activates the popup box needs
to be a specific entry in a particular cell (for instance, entering "B" in
the cell "C1" and hitting enter activates the popup box, but any other entry
does not. Anyone out there with the knowledge to do this without a huge time
investment? Turns out I'm way out of my league on this particular project.
Time to take a VBA class! Thanks in advance for the time!
-KAi

In addition to a userform you'll also need to enter some code for the
worksheet to catch the event of entering a "B" in cell C1. If you
search this forum for "ByEvent" you should see some examples you could
use.

 

[Guest]

Thanks a ton for the info!

: