F
FA
I need a VBA function that takes two values
Dim Val1 As String
Dim Val2 As Date
Dim Val3 As String
Combine Val1Val2 and return a single value Val3 As String
With Val3 Add 001 for the first record 002 for the second record and so
on
insert Val3001 into a texbox
So for Example if Val1 = ABCDE, Val2 = 01/01/2006
Val3 shoule be = ABCDE01/01/2006001 --- for the first recode (or for
the first time)
Can someone help me please?
Thanks Bunch
Moe
Dim Val1 As String
Dim Val2 As Date
Dim Val3 As String
Combine Val1Val2 and return a single value Val3 As String
With Val3 Add 001 for the first record 002 for the second record and so
on
insert Val3001 into a texbox
So for Example if Val1 = ABCDE, Val2 = 01/01/2006
Val3 shoule be = ABCDE01/01/2006001 --- for the first recode (or for
the first time)
Can someone help me please?
Thanks Bunch
Moe