modifying the standard excel data entry form

[Perception]

Hi

I apologise if this is a remarkably silly question.

All I want to do is to use the auto-generated data entry form as a basic form that I can modify by going into the normal vba window.


In other words, I want to save the data-entry form that can be created automatically from a spreadsheet using the form button. Then I want to move the windows and add some extra controls on the form.


If that is not possible, are there any standard simple form templates I can use as a starting point. (Contextures site seems to be unobtainable)

[FONT=&quot]Thanks for any help you can give.[/FONT]<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

 

[dmt32]

Hi,

have a look here:http://spreadsheetpage.com/index.php/dataform/home

You can download & use the form in your project for free but if you want access to the code to customise it, you will need to contact the author.

Dave.

 

[Perception]

Hi,

have a look here:http://spreadsheetpage.com/index.php/dataform/home

You can download & use the form in your project for free but if you want access to the code to customise it, you will need to contact the author.

Dave.

Thanks Dave