Ok,

I have a userform where the user enters data, by clicking on the
commit button in the user form, the data is enetered into the
spreadsheet, eg txttitle.value is entered into cell B1,
txtauthor.value is entered into cell B2 etc.
However id it possible when the user enters the data, that a
drop dwn list could automatically be created consisting of the
users inputs?Some of these lists are rather lengthy & at the
moment, I have them in a horizontal forma that go way beyond
what the user can see, the user should not need to scroll.
So a drop down list would prove useful!!!

--
nollai
-----------------------------------------------------------------------
nollaig's Profile: http://www.excelforum.com/member.php...fo&userid=2125
View this thread: http://www.excelforum.com/showthread.php?threadid=37636