View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default prefix in text box

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