dual textbox actions

[TonyforVBA]

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.

[Andy Pope]

create a function rather than a subroutine.
The function takes an argument and returns a value

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[TonyforVBA]

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

[Andy Pope]

Where in your original post did it say that?

[TonyforVBA]

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.

[Andy Pope]

Please Login or Register  to view this content.

[TonyforVBA]

Cheers for that Andy