"LinkedCell" Textbox not updating

Hi all,

I'm having an issue with an activeX Textbox not updating when the cell that it has been linked to updates

There are identical textboxes in separate worksheets(A to E), with each one being linked to the same reference cell (in sheet F), such that any change in the text of one textbox will automatically update the other textboxes in worksheets A-E

All of the textboxes are updating fine, expect for the one in worksheet E, which does not update when any of the textboxes in sheets A-D are changed. However, changing the textbox in sheet E will update the textboxes in A-D, which means the linkedcell is partially working.

Has anyone had a similar experience, and can shed some light on my problem?

Cheers

Thanks for the reply Andy, I added the code to sheet with the reference cell (sheet F) but the textbox in E still doesn't refresh when there is a change in value.

The code i attempted to use:

Please Login or Register  to view this content.

Andy, the "TextBox" in the above code is just a placeholder for the actual name i assigned to the textbox

Could you assist with the coding for the msgbox? still quite new to VBA.