| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51239 | 2004-11-15 06:52:00 | excel | Trev O (452) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 292418 | 2004-11-17 10:49:00 | Ah I see. Unfortunately there are no editable properties for the behaviour of validation boxes. An ActiveX ComboBox has a ListRows property that can alter the number of rows displayed in the control. It would be possible to fudge it by using a Worksheet_SelectionChange event (a macro thats triggered when you select a cell) and show/hide the ComboBox thus giving the impression the box appears when you click a cell although it sits on top of the active cell obscuring any data within but it could display the cell value as the current list option (if valid). A lot of mucking around just to get a few more rows in a box and is probably not worth the effort. If I attempted this it would be merely to show it could be done as opposed to any real practical benefit over a validation box and may result in other issues. If your wanting to control input then forms are a good way to do this as you can have more control, but it depends upon what your data looks like and what you want to achieve. You may have to grin and bear it. :-) regards Parry. |
parry (27) | ||
| 292419 | 2004-11-17 18:44:00 | Thanks Parry, I was begining to think it was a lost cause, worth asking though, just in case Trev |
Trev O (452) | ||
| 1 2 | |||||