dual textbox actions

Im useing a piece of code (below) which take the mid values of a string from one text box and generates it into differant Month format (09_Sep).
On a seperate tab on the same user form I have a second text box which will have differant values entered into it.
Is there anyway that I can use the below pice of code for both txt boxes?

Strings 'ThisWeekDate' & 'LendingMonth' are defined earlier in the code.
Thanks

Please Login or Register  to view this content.

Hey Andy,
The problum is that the strings are in differant Date Formats.
Thisweek date = dd-mm-yyyy
LendingMonth = mm
Any ideas??

Hey Andy
"a second text box which will have differant values entered into it" - Apologies, I see how that can be misunderstood as a differant date (in the same format). I should have made that clearer.

Cheers for that Andy