Trying to Update Userform Label with worksheet cells

I am trying to copy the text I created in the worksheet cells to the Userform and have it automatically update every time to the cells text changes in the worksheet. I can get it to work if I use the click event but I want it to change automatically. Any suggestions would be appreciated! Thanks

Please Login or Register  to view this content.

If you want to update the label in the form when you update the cell in the worksheet, you need to reverse the process ... use a Worksheet Change event to monitor cell A2 and, when it changes, change the form.


Regards, TMS

Assuming that the useform is loaded as modeless then you can use change it programmatically like this:

Please Login or Register  to view this content.

abousetta