What 's DialogSheets?

  • Thread starter Thread starter EdgeOfCity
  • Start date Start date
E

EdgeOfCity

I have a workbook containing a dialogsheet.
i am usint XP and can't get help about "DialogSheets".What's it? and How
can I see it?
 
Dialog sheets were once used to create dialog forms. They have been
replaced with Userforms in VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I knew someone would say "they have been replaced with userforms" <g>. I always use them
when looks matter.

Workbooks with a dialogsheet would display it as a sheet with a sheet tab. If not then
it's hidden. You can insert a dialog sheet by rightclicking a sheet tab and choose
"insert" > "Excel 5 Dialog".

Dialogsheets have no VBA events and neither does their controls. So they are far worse and
quite limited for programming purposes. But on the good side; their controls are parts of
collections ("Loop all checkboxes" tasks), and they are superior to most Offfice things
when it comes to graphics.
 
Back
Top