excel 5 dialog sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...
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
Click to expand...
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 said:
A long time ago I wrote an application in excel that used dialog sheets as
Click to expand...
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
Click to expand...
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 said:
A long time ago I wrote an application in excel that used dialog sheets as
Click to expand...
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
Click to expand...
versions? or old ones for that matter?
 
Back
Top