excel 5 dialog sheets
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? |
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? . |
excel 5 dialog sheets
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? |
excel 5 dialog sheets
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? |
All times are GMT +1. The time now is 05:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com