generic data entry form

[tholman]

Does anyone have 'open' code that is:

a) simple to follow
b) easy to adapt

that will allow data entry to a table that will be created in Excel?
(2000 or XP)

Have looked around, but no code seems too easy to follow or adapt. Am
at intermediate / advanced VBA for excel.

thanks in anticipation

 

[jaf]

Data>form ?

 

[Tom Ogilvy]

This code is pretty easy to follow:

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