Data types.

[Tom]

Hello,

I have TextBox1 with this Value = 57.7
I need do something like this

MyNewVar = CDbl(TextBox1) .... but this is Type mismatch error 13

I need transform text value to number value.

Thanks Tom

 

[Tom]

I found the problem.
I need transform 57.7 to 57,7

 

[Dave Hawley]

Hi Tom

No need to convert it. Simply use


MyNewVar Textbox1.Value

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Tom]

Yes but after this it will be String, String is using for text, I need
Double or Single.

Tomas

 

[Dave Hawley]

No it wont. Not if the Textbox has a number and you use .Value

Unless you have dimmensioned MyNewVar as a String

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Tom]

This is big problem. for example when I want do tihs in Forms:

TextBox1 = 23
TextBox2 = 100

If TextBox1 > TextBox2 Then
MsgBox "YES"
End If


Program said YES. And same problem I hve in another parts in my program.

 

[Dave Hawley]

Tom. The default for a TextBox is Text. Simply use;

TextBox1.Value

NOT

Textbox1
or
Textbox1.Text

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Tom]

I tried this:

rem this is part which start after click on OK button in my Form

MyVar = TextBox.Value
MsgBox TypeName(MyVar)

and its String

 

[Tom]

I found this....I was supid

I used Double but I have to use Currency so:

MyNewVar = CCur(Text.Box)

its enough for me, now everything works like I need

Thanks

 

[dave]

Dim myVar As Double

Will fix that. I cannot see any point in passing a Text number to a
variant, then converting it after. It's double handling.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Tom]

I use it becase I give some data to TextBox for look in my Form and then I
take this data and put them to Worksheet.

 

[Tom]

No, it worked now is same problem...Type mismatch

Someone make game of me.