Hello,

I am trying to format the textboxes on userform with the followin
code, but I cannot see the problem why I cannot make it working....

For i=1 To 21

With "price0" & (i)
.value=Format (.value, "£#,##0.00")
End With

Next i

my textbox names are : price01, price02, price03......

Please assist me to make it work,

Regards,

gk

--
Message posted from http://www.ExcelForum.com