what combo

[Guest]

Hi,
I have been given a .xls workbook created by a pervious employee of the
company I work for. On the workbook they have used combo boxes to give five
options to the user. I am unable to find out what type of combo box is used
here and also where the data is from. I need to be able to add extra options
to the list. These combo boxes only appear when you click into the cell and
dissapear when the choice is made. I have included a link to a screen shot if
this helps. Any help on where I edit the data for these boxes would be much
apperiated.

Link - http://www.hillsdata.co.uk/public/jonkeane/excel_combo_qry.jpg

Regards

Jon

 

[Dave Peterson]

I couldn't tell from the picture, but dropdowns are usually created in 3 ways:

#1. Try Data|Validation to see if you get anything that looks like it's
prepopulated with info. If yes, you can see if that list of values is typed
into that dialog directly or pointed to (a range--maybe on a hidden
worksheet??).

#2. If it's not data|validation, try rightclicking on the dropdown. If you see
an option for "assign macro", then this is a dropdown from the Forms toolbar
(view|toolbars will allow you to turn see it).

Rightclick on that dropdown and choose Format control.

On the "control" tab, you'll see a spot where the linked cell and input range is
defined.

#3. If it's not either of the above, it's a combobox from the control toolbox
toolbar. Show that toolbar (view|toolbars) and click on the Design Mode icon.
Then rightclick on the combobox. Select properties.

Look for LinkedCell and ListFillRange

======
I think I'd do this against a copy of the workbook--one time for practice???

 

[Guest]

Dave,

Thanks very much for the responce. I havnt had chance to look at any of your
suggestions as yet, but will do when I have a spare 5 minutes. Seems like one
of those has to be it.

Regards

Jon
--------