I have a Worksheet that uses Combo Boxes created from the
Forms Toolbar. The Combo Boxes each retrieve their data
from alphabetically-sorted columns of data in a worksheet
in the same workbook. This data is retreived from a SQL
database that is constantly being updated with new
values. The queries that retreive this data are set
to "Enable background refresh" and "Refresh data on file
open" so that the user can always choose values from the
most current data. The problem I'm having is this...A
user chooses a value from the Combo box and saves the
spreadsheet. When the user opens the spreadsheet at a
later time, if cells were added/deleted to/from the data
columns, these changes are affecting the value that was
originally saved in the combo box. For instance, the
original list contained the values of 1,2,3,4 and the user
originally chose value "4". Two new values of "1.5"
and "2.5" were subsequently added to the data list. When
the spreadsheet is opened again and the queries refresh,
the Combo Box value also refreshes and now displays "2.5"
seemingly because the "2.5" cell is in the former position
of the "4" value cell. Is there a way to stop the chosen
value from changing? (The worksheet w/ the combo boxes is
usually emailed between two individuals who fill out
different parts. Then it is finally emailed to a seperate
individual who prints it and uses it for data entry.)

Break the link and update with code. then you can determine when it is
updated. Otherwise, no. Linking a combobox to a cell is like linking a cell
to a cell. When a calculate is peformed, the combobox is updated. You
could try setting calculation to manual, but I am not sure this would be
reliable - especially since you can't guarantee that is the setting on both
machines whenever the workbook is opened.

--
Regards,
Tom Ogilvy

LJK wrote in message
...
I have a Worksheet that uses Combo Boxes created from the
Forms Toolbar. The Combo Boxes each retrieve their data
from alphabetically-sorted columns of data in a worksheet
in the same workbook. This data is retreived from a SQL
database that is constantly being updated with new
values. The queries that retreive this data are set
to "Enable background refresh" and "Refresh data on file
open" so that the user can always choose values from the
most current data. The problem I'm having is this...A
user chooses a value from the Combo box and saves the
spreadsheet. When the user opens the spreadsheet at a
later time, if cells were added/deleted to/from the data
columns, these changes are affecting the value that was
originally saved in the combo box. For instance, the
original list contained the values of 1,2,3,4 and the user
originally chose value "4". Two new values of "1.5"
and "2.5" were subsequently added to the data list. When
the spreadsheet is opened again and the queries refresh,
the Combo Box value also refreshes and now displays "2.5"
seemingly because the "2.5" cell is in the former position
of the "4" value cell. Is there a way to stop the chosen
value from changing? (The worksheet w/ the combo boxes is
usually emailed between two individuals who fill out
different parts. Then it is finally emailed to a seperate
individual who prints it and uses it for data entry.)