Forms - Set Control Source to insert data in next blank row

[Vicki Henley]

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

 

[Tom Ogilvy]

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

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.