excel 5 dialog sheets

[azcycles]

A long time ago I wrote an application in excel that used dialog sheets as entry forms. Now for the life of me I can't remember how to do this. I would use the generic data entry form but I would like to make some nicer controls and some lists.
Does anyone know how to do a custom form for data entry in newer excel versions? or old ones for that matter?

 

[Kevin Beckham]

Select the menu item Tools | Macro | Visual Basic Editor
then Insert | UserForm
There is an add-in that will do the conversions if you
need it.
"Baarns Dialog Converter for Excel 97"
www.baarns.com
see Developers only | Free tools

Kevin Beckham

-----Original Message-----
A long time ago I wrote an application in excel that used

dialog sheets as entry forms. Now for the life of me I
can't remember how to do this. I would use the generic
data entry form but I would like to make some nicer
controls and some lists.

Does anyone know how to do a custom form for data entry

in newer excel versions? or old ones for that matter?

 

[Vasant Nanavati]

You need to use UserForms for your entry forms. If you have specific
questions I'm sure you'll find answers here.

--

Vasant

A long time ago I wrote an application in excel that used dialog sheets as

entry forms. Now for the life of me I can't remember how to do this. I
would use the generic data entry form but I would like to make some nicer
controls and some lists.

Does anyone know how to do a custom form for data entry in newer excel

versions? or old ones for that matter?

 

[Harald Staff]

You can still use dialogsheets, they are the best when looks matter a lot.
Rightclick a sheet tab, choose Insert to create one.

However, for data entry I think userforms is a better choice. See
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please

A long time ago I wrote an application in excel that used dialog sheets as

entry forms. Now for the life of me I can't remember how to do this. I
would use the generic data entry form but I would like to make some nicer
controls and some lists.

Does anyone know how to do a custom form for data entry in newer excel

versions? or old ones for that matter?