PDA

View Full Version : Solved: Combobox in Worksheet



RECrerar
11-05-2007, 09:50 AM
We have a whorksheet in a program, and to populate values in a column you click on a cell which brings up a bombo box containing a list of possible values that are allowed to be entered in that cell.

This list needs updating and I've been asked to help, the problem is that I have no idea where the information used to populate this listbox is likely to be stored. So the question is: Where is the information used to populate this listbox likelt to be stored? I have looked in the worksheet page in the VBE and it's not there.

RECrerar
11-05-2007, 09:58 AM
Sorry ignore that, have found it, was a data validation list.

Sorry for needless post