Real time update of Userform label with cell value

hi,

I have search for some info regarding real time update of Userform label with the cell value but I got no luck. I hope some excel experts here can help me. I have a userform with a label. I would like to have that label be updated in realtime each time the cell value on the worksheet changes. Say cell value A3 has 150, in my Userform label caption appears as 150. If A3 cell value changes to 200, the label in my Userform changes to 200 as well at the same time. Is this possible using excel vba? Im new to this language but interested to learn. Thanks!

Kyle

hi,

Originally Posted by royuk

How are you changing the cell/ To change the cell other than by code from the UserForm would need the UserForm to be modeless.

The cell value changes according to the sum given from column B and C. I have no idea what Userform modeless is. Sorry still learning vba

Originally Posted by royuk

If you use a TextBox instead of a label you can set it's ControlSource to the cell. The TextBox would update automatically. However, any changes to the textbox would change the cell's value. To get round this change the TextBox's Enabled property to False.

How do I set the control source thing? Can you show me?

Thanks,

Kyle

Go to VBA editor(alt+F11) then click on the textbox you would like to modify, then in the Properties box you will see "Control Source" followed by a blank box, enter the cell you would like to associate with that textbox.
P.S. if you do not see the properties box go to View, then "properties Window"