Nope I can't. The workbook has 45 sheets, dozens of forms and modules. When
you get that big, Excel gets flaky. I switched to a combo box from the
control toolbar and all is fine.

On Tue, 02 Aug 2005 16:16:47 GMT, "STEVE BELL"
wrote:

Don,

You should be able to do what ever you want.

Just remember that the change event will fire with a change in any cell.
You can restrict this by using
If Target.Address=$A$1 ''' change to the appropriate cell
or
If Target.Row = 1 ''' change to the appropriate row
#
or
If Target.Column = 1 ''' change to the appropriate
column #

And it is wise to add the following to most code to suppress event firing
during the code:
At the beginning
Application.EnableEvents = False

at the end
Application.EnableEvents = True