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?

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?
.

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

--

Vasant

"azcycles" wrote in 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?

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

"azcycles" skrev i melding
...
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?