Where should I format my Excel text box controls in my VBA code ?
Posted on 2013-10-26
I've created an Excel 2010 User form and I've been trying to format the VBA text box controls as currency fields :
Me.Controls("teUnitPrice" & i).Value = Format(Me.Controls("teUnitPrice" & i).Value, "#,##0.00")
But if I enter £300, for example, it doesn't autofill the pence zeroes as I would expect.
Is there a quicker or a better means of applying currency formats to control fields than formatting them individually ? Can they be formatted in Properties ?