Run Dialog

  • Thread starter Thread starter VILLABILLA
  • Start date Start date
V

VILLABILLA

Hello everyone,

I am using the Forms toolbar quit much, you can use severel of its
functions in combination with lookup functions etc, which is handy in
my spreadsheets. One particular function on the Forms toolbar, is 'Run
Dialog'. I would like to use this function, however, it is not
available to use, it is not highlighted... Why is that? And is there a
way to use the Dialog box without the direct use of VBE language.

The idea is that I would like to press a button or autoshape, a dialog
box would appear and on this dialog box I would like to put in for
example a Combo Box from the Froms toolbar.

Is this possible? If yes, how...

Some hints in how to proceed would be very much appreciated!

Robby
 
The Forms toolbar is a remnant from Excel 5. Excel 5 introduced "dialog
sheets" and all later versions of Excel support them. But starting with
Excel 97 "userforms" because the preferred way of creating dialog boxes.

Although dialog sheets are "old technology" you can still use them. You do
this by right-clicking on a worksheet tab and picking Insert and then
Dialogsheet. When you are on a dialog sheet the Run Dialog button is
available. This is just used in developing/testing the dialog.

Forms toolbar controls can be used only on a dialog sheet or on a worksheet
(some controls). Control Toolbox controls can be used only on a userform
or a worksheet.

--
Jim Rech
Excel MVP
| Hello everyone,
|
| I am using the Forms toolbar quit much, you can use severel of its
| functions in combination with lookup functions etc, which is handy in
| my spreadsheets. One particular function on the Forms toolbar, is 'Run
| Dialog'. I would like to use this function, however, it is not
| available to use, it is not highlighted... Why is that? And is there a
| way to use the Dialog box without the direct use of VBE language.
|
| The idea is that I would like to press a button or autoshape, a dialog
| box would appear and on this dialog box I would like to put in for
| example a Combo Box from the Froms toolbar.
|
| Is this possible? If yes, how...
|
| Some hints in how to proceed would be very much appreciated!
|
| Robby
|
|
| ---
| Message posted
|
 
Back
Top