VBA How to refresh a userform per button without restarting it.

Hello to all…

I would like to declare that i am an Excel newbie, so please be patient with me.
I am working for the first time ever with VBA and I have barely started my project and I am stuck already.

Could anybody tell me how to refresh a userform using a commandButton so the userform dosent need to be restarted.
To explain a little more, the cell values in my textboxes are basic entries and can be manualy modified in the userform and sent back to their cells. These cell values are part of a formula to calculate whitin the entire workbook and the results go in to an other cell witch is displayed again in my userform (or should be). Now when I send basic entries back to their cells, excel calculates but the results do not change in my userform because the userform only displays the values caled in the inicial (UserForm_Initialize()) I would like to create a button that refreshes the textbox and frame contents of my userform after modification without restarting the userform, or better integrate the code in my button that sends the values back to excel. That way it would not require an aditional button.

I hope my explanation is understandable… English is not my first language….

Thanks in advance for your help.

Or maybe try the worksheet_calculate event like:

Please Login or Register  to view this content.

You would have to change the names to suit.

Yes you could, if you wanted it to happen on a button click instead.