Update/Refresh button

[ilovelagar]

Hi,

I'm looking to create a refresh/update button for my userform. What I have is various textboxes, of which the last textbox contains input from the other textboxes.

For example, I have 3 textboxes. The first one contains months, the second contains years, the third pulls from both the first two.

First: August
Second. 2009
Third: August 2009

What I need is if I change the text in either the first or second textbox, I can click the refresh button and it'll update the third box.

Any ideas

Cheers,

[telyni]

Assuming you've got textboxes named txtMonth, txtYear, and txtBoth, you could have this sort of function as the code for what happens when you click the button:

Please Login or Register  to view this content.

The Trim function would remove the middle space in case one or both of the text boxes are blank.

[ilovelagar]

Assuming you've got textboxes named txtMonth, txtYear, and txtBoth, you could have this sort of function as the code for what happens when you click the button:

Please Login or Register  to view this content.

The Trim function would remove the middle space in case one or both of the text boxes are blank.

Perfect, thanks!