Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
value in userform
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
value in userform
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |