Format user form text box

[ipbr21054]

Hi,
I’m looking for a solution to format a userform text box to & from a worksheet.

When a figure from a worksheet £12.34 is imported to the userform it needs to be shown as 12.34

Likewise when the figure in the userform 12.34 is exported to the worksheet it must show as £12.34

Worksheet cell is formatted as currency but can’t overcome the import side of things for the userform display.

Any advice please.

 

[dmt32]

Hi,
If your code is returning cell formatting to your textbox it suggest that you are using Range.Text property which returns what you see in the cell rather than its underlying value.

E.g.

Textbox1.Value = Cells(r,c).Text

If you want the value only then in the appropriate part of your code, change Text property shown in RED to Value

Textbox1.Value = Cells(r,c).Value

& see if this resolves your problem.

Dave

 

[ipbr21054]

Thanks for the info,will take a look.