Thread: dialog boxes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default dialog boxes

All their code is to be written in a standard module, assigned to controls
by rightclick - assign macro, just like drawing objects on spreadsheets.
Dialogs and their objects doesn't have events like keydown, mousemove, exit
and all that.

They can handle almost all kinds of graphics, including the extremely sexy
live spreadsheet pictures generated by the camera tool. Dialogs' and their
controls are parts of distinct collections (as in Editboxes(1),
Editboxes(2), ... ). So they make a great supplement to your familiar
weapons.

HTH. Best wishes Harald

"Dave F" skrev i melding
...
Right, I've only created userforms before.

I use XL2000 @ work and was playing around with the dialogue box option.

Thanks for the info.
--
Brevity is the soul of wit.


"Harald Staff" wrote:

Making fun of the elderly now, are we? There are some things Dialogs

can do
that Userforms can't. But Dialogs are not for those who need Sub-End Sub

to
be generated automatically for them <gd&r

Best wishes Harald

"Dave Peterson" skrev i melding
...
DialogSheets("dialog1").Show

Except for a few people (Harald Staff, <vbg) (and support for

existing
workbooks), dialogsheets have been (mostly) replaced by userforms

(since
xl97).