[cherry_?!]

Hi,

this is probably something I will kick myself for, but I have been going over and over it and ...well...help!

I have an excel worksheet with a combobox that lists 2 columns -location and location number. The combobox is filled via a named range that is populated via a odbc connection to access. The range appears to be populating correctly. What I would like to do is set a default value - based on the 2nd column - the location number, but I would like the box to display the 1st column - the location.

This mimics what happens when you click on the drop down and select it - the value is populated as the number and what the user sees selected is the name.

I have tried using the .value and the .text properties, but it gives me errors. Any ideas?

Thanks,
Cherry

[OBP]

Cherry, I do not quite understand your question. What "default" value are you trying to set? If you want to use the data in the Combo you can set it in the combobox properties.
Number of columns, bound column, column width and output cell.

[cherry_?!]

The default really just means that the combobox is pre-set with information and the user does not have to select an option from the list, unless the default (pre-set info we give them) needs to be changed.

The information to default is based on a function that gets their User ID and then searches a table to find the Location and Location number setup for their User ID(which is working). I want the combobox to display the location and for the value to be the location number - set the combobox to their location information as though they had selected it manually from the drop down, but we are setting it based on their User ID. Does that clarify things?

Thanks for any help,
Cherry

[OBP]

So does Excel know the ID when it opens the Worksheet with the Combo on it?

[cherry_?!]

As part of the Workbook Open action, it finds out their ID and checks that it is valid and returns their location info.

[OBP]

So what does Excel do with the value/text chosen in the Combo?
When you set the Combo.value to their ID what happens?

[cherry_?!]

I was choosing the wrong variable to set the value (I knew I would have to kick myself)- once I selected the correct variable with (with the location ID) it is now showing the location name correctly.

So this is solved. Thanks for the help.