What Is MS Excel 5.0 Dialog?

Written by louise jones
  • Share
  • Tweet
  • Share
  • Pin
  • Email
What Is MS Excel 5.0 Dialog?
MS Excel 5.0 Dialog opens an Excel 5.0 Dialog sheet. (resuscitate form image by Keith Frith from Fotolia.com)

In Excel 5.0 and Excel 95, dialogue sheets were used to create custom dialogue boxes and forms. These have been superseded by user forms, which are created via the "Developer tab," but have been left available for use in later versions of Excel.

Dialogue Sheet

A dialogue sheet is a grid drawing sheet that can have buttons, text boxes and messages entered can be used to create forms to control access and data. They were often used to create password log on boxes to control access, or to create data entry forms to control the information put into a spreadsheet.

Opening a MS Excel 5.0 Dialog Sheet

To open a dialogue sheet in later versions of Excel right click on a spreadsheet tab, click on select and double click on the MS Excel 5.0 Dialog icon. The Excel 95 and 5.0 Dialog Sheet will automatically open.

User Forms and Dialog Sheets

Microsoft Excel 97 introduced user forms, which offer a lot more functionality and are generally accepted as being easier to use than dialogue sheets. User forms also allow buttons, radials and text boxes to be inserted into the same "grid" style back ground, and are accessed via the Visual Basic Editor.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.