| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question Reposted | Excel Worksheet Functions | |||
| Using Function (reposted) | Excel Discussion (Misc queries) | |||
| Can Excel ignore file links that do not yet exist? | Excel Discussion (Misc queries) | |||
| Ignore file links that do not exist. | Excel Discussion (Misc queries) | |||
| Reposted from .programming: "I don't get it, Whats going on here? | Excel Worksheet Functions | |||
Threaded Mode
