Maybe you could use some of the techniques that Debra Dalgleish used:
http://contextures.com/xlUserForm01.html

She used textboxes, but the way she wrote to the worksheet should be pretty much
the same.

buckchow wrote:

I have a combobox on a userform that is linked to a named range to
provide a list for users to select. The form works well in feeding
data from the form to a row in the worksheet. My problem is that I
can't get the userform to feed data to the worksheet when the user
inputs new data into the combobox. If new data is added to the
combobox I would like this data to be fed to the next empty row below
the row already populated on the worksheet.

--
buckchow
------------------------------------------------------------------------
buckchow's Profile: http://www.officehelp.in/member.php?userid=5975
View this thread: http://www.officehelp.in/showthread.php?t=1323980

Posted from - http://www.officehelp.in

--

Dave Peterson