casting percentage as double

[EUROSTOXX]

Hi

I have built an excel form where one of the textboxes is initialized with a percentage format. But when I try to extract values from that text box (either txtbox.Text or txtbox.Value) I get an error message because it is a type mis-match.

Any ideas on how I can keep the formatting (important) and be able get the values (without the % at the end) so I can use them in my formulas?

Thanks i tried casting CDbl(txtbox.Text) and CDBL(txtbox.Value) but errors both times

 

[shg]

One way:

mydouble = Val(txtbox.Text)/100#

In VBA, % is the type declaration character for an Integer.

 

[EUROSTOXX]

thanks for the speedly reply but I tried it out but it does work.

when I mouseover the highlited error, my txtbox.Text = "0.0035%"

any ideas

 

[shg]

Sorry, that wasn't too rigorous

d = evaluate(txtbox.Text)

 

[EUROSTOXX]

yes SIR.. that works...