#1   Report Post  
Posted to microsoft.public.excel.misc
alm09
 
Posts: n/a
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel custom function dialog [email protected] Excel Worksheet Functions 0 February 16th 06 01:08 AM
Chart -- Source Data... -- Series dialog window Sarah Jane Charts and Charting in Excel 2 January 24th 06 10:27 AM
excel and VB Open Dialog box Anakin Moonwalker Excel Discussion (Misc queries) 2 September 13th 05 08:38 AM
Automatically Close Dialog Boxes chriskane Excel Worksheet Functions 2 August 9th 05 12:14 PM
Excel's Dialog Box Dialog Box Excel Discussion (Misc queries) 1 February 12th 05 12:53 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"