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/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

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

--
Regards,
Tom Ogilvy



"Gbiwan" wrote in message
...
HI!
I've been pretty lucky in the past with the responses on here... so I'm
going to try again... sorry if these questions seem to be pretty basic...

I need to write a macro attached to a button that if "yes" is pressed it
opens another form that the user would enter in 7 fields of information
and
when the user presses "write" would put that info in row 140 (starting in
column "a" if that makes a difference) and then allow the user to input
more
info into the same form above and put the info in row 141, then 142, etc
if
no more info needed then the user would press "done".

The amount of data needed would vary by period, if that matters, but must
always start on row 140 and overwrite the previous info if need be.

This seems to pretty straight forward but since this is my first attempt
at
this I want to ensure that I have an idea of how to do this before trying
to
write this...

As always any and all assistance is greatly appreciated!

Greg