R
Rob Meade
Hi all,
Hoping someone can advise me on this one.
I have a form with about 10 text boxes. A user will be entering numbers in
each box, I have written a small function that will correct the format of
the numbers, so if a user enters 5 it becomes 5.00, if they enter 5.5 it
becomes 5.50 and so on.
At present I have this as a test and am calling it only on the one text box,
but I want to be able to call it from all of the boxes, I'm using the .Leave
method to run the function, but it has the specific text box in the Handles
part of the code. Whilst I appreciate that you can have multiple controls
listed after Handles etc, I thought there was probably a better way.
Any info appreciated,
Regards
Rob
Hoping someone can advise me on this one.
I have a form with about 10 text boxes. A user will be entering numbers in
each box, I have written a small function that will correct the format of
the numbers, so if a user enters 5 it becomes 5.00, if they enter 5.5 it
becomes 5.50 and so on.
At present I have this as a test and am calling it only on the one text box,
but I want to be able to call it from all of the boxes, I'm using the .Leave
method to run the function, but it has the specific text box in the Handles
part of the code. Whilst I appreciate that you can have multiple controls
listed after Handles etc, I thought there was probably a better way.
Any info appreciated,
Regards
Rob