vba Gurus:
Thanks in advance for your help. I attached the code below to a command button, but it takes 2 clicks to execute the code. Any ideas?? Could this be accomplished in a single click of the button.
Sub CnvtTextDate1()
Dim rng As Variant
For Each rng In Selection
rng.Value = Trim(rng)
rng.NumberFormat = "mm/dd/yy;@"
Next rng
End Sub
Thanks in advance for your help. I attached the code below to a command button, but it takes 2 clicks to execute the code. Any ideas?? Could this be accomplished in a single click of the button.
Sub CnvtTextDate1()
Dim rng As Variant
For Each rng In Selection
rng.Value = Trim(rng)
rng.NumberFormat = "mm/dd/yy;@"
Next rng
End Sub