ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dialog Pop Up Box (https://www.excelbanter.com/excel-discussion-misc-queries/187804-dialog-pop-up-box.html)

Linda D F

Dialog Pop Up Box
 
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?

AKphidelt

Dialog Pop Up Box
 
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.

"Linda D F" wrote:

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?



All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com