| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
![nollaig[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
