data info on a form
 

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

data info on a form
 

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

data info on a form
 

Thanks Tom!

WOW! Great Info!
Have a Great weekend!

TTFN
Greg

"Tom Ogilvy" wrote in message
...
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

data info on a form
 

A new one Tom to add to your list

How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel
http://support.microsoft.com/default...b;en-us;829070

I hope to have time to read it next week (very busy in the flowers on this moment)


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Tom Ogilvy" wrote in message ...
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

data info on a form
 

Thanks Ron!


"Ron de Bruin" wrote in message
...
A new one Tom to add to your list

How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default...b;en-us;829070

I hope to have time to read it next week (very busy in the flowers on this
moment)


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Tom Ogilvy" wrote in message
...
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