Thanks Mike,

That sounds like it may work. How do I email you?

This is only a small part of a larger userform that I am building t
enter data onto an old spreadsheet, and the part I cant get to work i
making sure the values go in the correct rows. They upload to th
spreadsheet, but not to the row that corresponds to the selection fro
the combobox, which are static titles.

The form is just a replica of the old paper form used in th
stocktakes, so there may be further problems as well. I am only new t
VBA so can only plod along on one issue at a time.

cheers
Koal

--
koal
-----------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...fo&userid=1295
View this thread: http://www.excelforum.com/showthread.php?threadid=26761