| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51239 | 2004-11-15 06:52:00 | excel | Trev O (452) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 292408 | 2004-11-15 06:52:00 | I've made a drop down menu for every cell in column A and B does anyone know how I can make the menu more than 8 rows deep? Thanks Trev |
Trev O (452) | ||
| 292409 | 2004-11-16 00:15:00 | Try this site mrexcel (www.mrexcel.com) hth |
johnboy (217) | ||
| 292410 | 2004-11-16 04:41:00 | More information required - post your macro code and we'll see what can be done. | Russell D (18) | ||
| 292411 | 2004-11-16 08:15:00 | OK sorry a bit skimpy on the problem, I'm using excel xp prof under xp home and in a work book of 15 sheets one of them has the names in it (in a cloumn) I found how to do a drop down list some how and if you type in the help file, 'validation list' and then pick, 'Enter data in a cell from a list you specify' you'll know about as much as I do! I have been using it for a couple of years now and all is well but improvement, if it's not over my head would be great too!! Thanks Trev |
Trev O (452) | ||
| 292412 | 2004-11-16 21:48:00 | Sounds like you may have turned on Autofiltering via the menu Data/DataFilter/Autofilter. When Autfilter is turned on, drop down boxes appear in any area of continuous columns where the mouse pointer is sitting. The drop downs populate themselves with all the unique entries in the column with about 19 rows showing on a high resolution screen and side bars allow scrolling down to further entries. Have a play with Autofilter and see if it suites. |
Russell D (18) | ||
| 292413 | 2004-11-16 22:44:00 | thanks Russell D My drop down boxes come from >data>validation and are linked to >insert>name>define.. but 19 rows sounds like just what I want, so I'll have a play with the Autofilter later (I've never looked at that before!) Trev |
Trev O (452) | ||
| 292414 | 2004-11-17 02:36:00 | I have never used Data Validation - must have a look at it out of interest. | Russell D (18) | ||
| 292415 | 2004-11-17 06:29:00 | Actually what I've been doing is better described in the excel help files, under dropdown>Enter data in a cell from a list you specify. what I can do with it is click in a cell>click the arrow to produce the drop-down and then pick out of it any of about 60 names from another worksheet (in the same workbook) The hassel is I have to slide up and down to find the name and on the laptop it's a bit fiddley. I should have described it better earlier still no sign of extending the drop down list in the help file and I don't think the auto-filter is what I'm after... any other suggestions..? cheers Trev |
Trev O (452) | ||
| 292416 | 2004-11-17 07:22:00 | Hi Trev, if your wanting your own list then Data Validation is a simple method to achieve this. First create a list (perhaps column AA or far enough out of sight from your main data) on the same sheet. Data Validation will not allow a list to be on another sheet. Once youve created your list (I created a list of the alphabet so you can do 26 options comfortably) select the cells where your wanting the list to appear & select Data|Validation. In the Settings tab choose List from the options in the Allow drop down and enter the cell reference of the list in the Source box. Tip - you can click inside the source box then select the list with your mouse & the reference will be auto added. The other two tabs are to do with messages. The Input Message tab allows you to have a custom message indicating what the user should enter in the cell (eg please select an item from the list) while the Error Alert tab is where you can have a custom message if the user breaks the rules (eg You must select an item from the list). Validation boxes arent perfect to enforce rules so I usually use code as well to perform validation. The other option is to create ComboBoxes or other controls but these appear over a cell rather than within a cell so are not suited to having a control per cell. I usually use custom forms but you will need coding experience for that. regards Parry |
parry (27) | ||
| 292417 | 2004-11-17 09:06:00 | Thanks Parry, that is what I'm doing already (although I am able to put the list on another sheet if I name it something and then type the name in the source box of the data validation) What I'm after and obviously am not describing very well at all! is the drop-down menu to be greater than 8 rows visible... I'd like to see as much as possible rather than have such a short drop-down... I know nothing about coding any ideas? |
Trev O (452) | ||
| 1 2 | |||||