ExcelBanter - Ignore this.......Reposted to excel.links......

"Susan Lammi" wrote in message
...
I have a cells on my worksheet which are populated by comboboxes which
get
their
selection list from a linked worksheet.

I am trying to display a message when ever the user changes the value in
this cell using the dropdown list. They will not be allowed to enter
directly into the linked cell.

The problem seems to be that when the workbook is opened and the links are
refreshed it fires the change event for the comboboxes.

I tried the worksheet change event but that does not seem to fire when the
combo box changes the data in the cells

Private Sub Worksheet_Change(ByVal Target As Range)
For intx = 1 To Range("trsegsmapped").Rows.Count
If Target.Address = Range("trsegsmapped")(intx).Address Then SegMsg
Next intx
End Sub

Where is the proper place to place the code to display the message so it
only occurs when the user makes a change

Thanks