drop down list
 

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

drop down list
 

You could save them in a vertical list off screen (say column IA), and then
put a Data Validation list at that column.

--
HTH

Bob Phillips

"nollaig" wrote in
message ...

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!!!!


--
nollaig
------------------------------------------------------------------------
nollaig's Profile:
http://www.excelforum.com/member.php...o&userid=21258
View this thread: http://www.excelforum.com/showthread...hreadid=376362

drop down list
 

You could save them in a vertical list off screen (say column IA), and
then put a Data Validation list at that column.



But then the user wont be able to see the list???(if its in Cell IA)
And they have to be able to see it!!!. What I need is for the data
validation to be created automatically,ie within the code when the user
hits the command button.Is there any way in which this can be done????


--
nollaig
------------------------------------------------------------------------
nollaig's Profile: http://www.excelforum.com/member.php...o&userid=21258
View this thread: http://www.excelforum.com/showthread...hreadid=376362

drop down list
 

Yes they will, in the Data Validation list when they click on the arrow.

--
HTH

Bob Phillips

"nollaig" wrote in
message ...

You could save them in a vertical list off screen (say column IA), and
then put a Data Validation list at that column.



But then the user wont be able to see the list???(if its in Cell IA)
And they have to be able to see it!!!. What I need is for the data
validation to be created automatically,ie within the code when the user
hits the command button.Is there any way in which this can be done????


--
nollaig
------------------------------------------------------------------------
nollaig's Profile:
http://www.excelforum.com/member.php...o&userid=21258
View this thread: http://www.excelforum.com/showthread...hreadid=376362

drop down list
 

how???If its in Column IA, they will have to scroll over to click o
that arrow???

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