data info on a form

G

Gbiwan

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
 
T

Tom Ogilvy

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.
 
R

Ron de Bruin

flowers?

We are growing Chrysanthemums Patrick the whole year.
Excel is only a Hobby.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort on 3 columns when number of rows vary daily 1
Button to add Rows on Form in Excel 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Excel 2007 User form Enter Data Last Row @Table 1
Compare data, and if different, copy to another worksheet 2
Excel 2007 and Security key cards 3
Access Data Entry Form 0
Any ideas on how to do this? 7

Top