![]() |
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? |
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