On Jan 19, 9:07 am, pswanie wrote:
would it be posible to default the amount enterd in a text box with the
prefix "R" and "." to seperate sents? we use amounts like R1125.80

and show amounts in lable as that to?

i got this:

Label24.Caption = Range("l65536").End(xlUp).Value

No need for code. You can define a custom format for the cells with
those values. Select the cells then Menu - Format - Cells -
Custom. Then select the "0.00" format and insert the "R" to the left
of the number format. The R will then be prefixed to values that
people add into the worksheet.

If you want to use code, macro capture of the above sequence gives
you:

Range("C7:C10").Select
Selection.NumberFormat = "R0.00"

You can include the NumberFormat line in your subs to give you what
you want.

SteveM