ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dialog box (https://www.excelbanter.com/excel-discussion-misc-queries/80814-dialog-box.html)

alm09

dialog box
 
Does Excel allow you to create your own dialog boxes? If so, how is it done?

I am looking to create a file that asks the user a series of questions for
data input.



Kevin B

dialog box
 
You can use MS Forms in any office application. For simpler procedures you
can use the INPUTBOX function or the MSGBOX function to capture or return
values based upon user input.

All of these items are available in the VB editor. (Alt+F11)
--
Kevin Backmann


"alm09" wrote:

Does Excel allow you to create your own dialog boxes? If so, how is it done?

I am looking to create a file that asks the user a series of questions for
data input.




All times are GMT +1. The time now is 05:47 PM.

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