I have a .xls that I want to use for a survey. I want to create a custom form that works similar to a user form in that it sets the control source for the form object to the next blank row. I already have headings for my results, so I need to have the control source set to a certain column and then to the next blank row. I don't have much time to dig for the answer and am hoping that someone here can help me.

So, how do I set the control source for a form object to be a specific column and the next blank row?

All help is appreciated.

Vicki

There is no control source that will do what you want. You need to work
with each control individually - but if you are doing it with code, there is
no reason to use the controlsource of the control, just write the data to
the row.

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

--
Regards,
Tom Ogilvy

"Vicki Henley" wrote in message
...
I have a .xls that I want to use for a survey. I want to create a custom
form that works similar to a user form in that it sets the control source
for the form object to the next blank row. I already have headings for my
results, so I need to have the control source set to a certain column and
then to the next blank row. I don't have much time to dig for the answer
and am hoping that someone here can help me.

So, how do I set the control source for a form object to be a specific
column and the next blank row?

All help is appreciated.

Vicki