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