Does any one know how I can create a UserForm that I can
use to update a wine list that i am keeping in a
worksheet?

My problem is that I have created a combo box that lists
the regions but I don't know how to get the ControlSource
to move each time to the next empty row?

Does that make sense?

Any help would be most appreciated.

Thanks

controlsource should be used for a static reference/link. If you want to
make it dynamic, then you need to use code to find the blank row and write
the data there.


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://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

Might help you out.

--
Regards,
Tom Ogilvy




Gary Hall wrote in message
...
Does any one know how I can create a UserForm that I can
use to update a wine list that i am keeping in a
worksheet?

My problem is that I have created a combo box that lists
the regions but I don't know how to get the ControlSource
to move each time to the next empty row?

Does that make sense?

Any help would be most appreciated.

Thanks