How to create a vba Form for entering data into Spreadsheet ?

[tmb]

How can I use vba to create a "Form" for a user to enter data into an Excel
spreadsheet?

thanks for any help.

[Mohamed Shafiee]

What for?
Just select the data range, and click Form in the Data menu.

"tmb" <topmailbox@yahoo.com> wrote in message
news:Hq22e.6233$vd.2916@tornado.tampabay.rr.com...
> How can I use vba to create a "Form" for a user to enter data into an
> Excel spreadsheet?
>
> thanks for any help.
>
>

[Bob Phillips]

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/default...;EN-US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--

HTH

RP
(remove nothere from the email address if mailing direct)


"tmb" <topmailbox@yahoo.com> wrote in message
news:Hq22e.6233$vd.2916@tornado.tampabay.rr.com...
> How can I use vba to create a "Form" for a user to enter data into an
Excel
> spreadsheet?
>
> thanks for any help.
>
>