Creating a User Form to update a list
 

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

Creating a User Form to update a list
 

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