View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin Beckham Kevin Beckham is offline
external usenet poster
 
Posts: 78
Default excel 5 dialog sheets

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