Hi - I have a series of combo boxes which change values in a table. I have multiple versions of the same combo box on different sheets, linked to the same cell.
On ONE of the sheets where these comboboxes reside I would like to display a warning message that when changed, the following tables have also changed.
I have the message box working fine on different choices, great.
However when the combobox is changed from another sheet, the message pops up. I only want to show this box on a single sheet. I have the message box running from a copy of the drop list on the sheet specied using the worksheet_calculate function in vba. Can anyone please advise o this?
Many thanks
On ONE of the sheets where these comboboxes reside I would like to display a warning message that when changed, the following tables have also changed.
I have the message box working fine on different choices, great.
However when the combobox is changed from another sheet, the message pops up. I only want to show this box on a single sheet. I have the message box running from a copy of the drop list on the sheet specied using the worksheet_calculate function in vba. Can anyone please advise o this?
Many thanks