How to keep updated textbox on user form

Dear Sirs. Hope general description will be enough. My problem: I have a user form with few cbboxes. All cbboxes are connected to certain cells listed as source control in each cbbox property. Somewhere in excel spreadsheet, some simple calculation is done based on values in those cells and I want to show the result on the same user form for example in dedicated text box. It works only one time, in order to see newer result caused by changing value in one of the cbboxes I have to close user form and open again. Is is possible to see immediately results based on calculation which is using actual values from cbboxes without closing and reopening user form?

Hi

This is possible.

I created a userform with a text box.

On activation the text box picks up the value of H1.

The userform is modeless so you can move it around and modify the spreadsheet with the user form open.

Finally.

If you modify the spreadsheet the textbox is automatically updated.

To see that code right click on the sheet name at the bottom of excel and select view code.

Dear Mehmetcik
Thanks for your time but my problem is still unsolved. I tried modeless user form and it did not help. Let me be little bit more specific. My user form has 4 cb boxes. Each cb box is used to chose number; cb box#1 represents hours the cbbox#2 represent minutes of the beginning of the event. Another two cb boxes are used also to enter time , cb box #3 hours and cbbox#4 minutes the end of event. Each cbbox has its own assigned control source cell. User form has also a text box which has to show the time duration of the event. Lets say cell "H5" has the value of duration time. Time which was calculated based on values stored in source control cells assigned to each cb box. The TextBox.value=range("H5").value does not work. What I need, I need TextBox to show immediately changes caused by changing values in any of the cbboxes. Honestly it works but not always, sometimes duration time is changed but those changes are not correct. Means TextBox will show me e.g. 5:15 (5 hours 15 minutes) while cell H5 is for instance 5:20 . But it was 5:15 some time ago when I was doing other changes. Briefly, TextBox value is sometimes changing but I can not figure out how this mechanism works. Please help.
Flowerski

Originally Posted by mehmetcik

Hi

This is possible.

I created a userform with a text box.

On activation the text box picks up the value of H1.

The userform is modeless so you can move it around and modify the spreadsheet with the user form open.

Finally.

If you modify the spreadsheet the textbox is automatically updated.

To see that code right click on the sheet name at the bottom of excel and select view code.