Dialog Pop Up Box

L

Linda D F

Back in the early 90's when we first got Excel, I created Pop Up Dialog boxes
in the worksheet. The way it worked is when you opened the worksheet you
would click on a button to get started. The first pop up box would be
something you would create that would have a question, then you would fill in
the answer and once you hit enter then it would put the answer on the
designated cell in the spreadsheet. Another box would automatically pop for
the next question and so on. If you didn't have an answer for that question
you would just hit enter and that would leave that cell blank. It was real
easy to create, but I just can't remember how to do it or if the 2003 version
doesn't have that feature or has changed to something else. Does anyone know
what I'm talking about?
 
A

akphidelt

I assume you are talking about input boxes? Go to Tools-->Macro-->Visual
Basic Editor

Then go to the help menu and type in Input Box

Or you can even create your own userform, but most like the Input Box would
work for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top