value in userform

[antonov]

hello again everybody. I need some values from my userform to my sheet to be
always in Euros. Even though I've formatted the receiving cells to
currency (euro) this doesn't happen. Can somebody please help?
thanks

[Flemming Dahl]

Hi

You properly have the value in a TextBox, which returns a string. A string
is a text and not a value, so you need to convert the text to a value before
you sendt it to the worksheet.
It could be something ike this...

If IsNumeric(TextBox1.Text) Then Range("A1").Value = Cdbl(TextBox1.Text)

There are lots of ways to do this.
Cheers,
Flemming


"antonov" <antonov@dds.nl> wrote in message
news:OShtf.10328$av6.5940@tornado.fastwebnet.it...
> hello again everybody. I need some values from my userform to my sheet to
> be
> always in Euros. Even though I've formatted the receiving cells to
> currency (euro) this doesn't happen. Can somebody please help?
> thanks
>
>