Arrhg! Userforms again

robfo0 · Mar 29th, 2002, 05:18 PM

Can you not format a field in a userform as a percentage? I'm trying to use this code:
FIRST_RATE = Format(Worksheets("Sheet1").Range("RATE"), "0.00%")

But i keep getting a Type Mismatch error. The data in the cell named "RATE" is formatted as a percentage also.

HELP! Thanks

daleyman · Mar 29th, 2002, 05:21 PM

You might want to check that the value in the referenced cell is actually numerical, that is to say the percentage symbol appears due to the cell format, rather than actually being in the cell contents.

robfo0 · Mar 29th, 2002, 05:27 PM

It is...i input 12.99 in the reference cell. I tested it in a payment to make sure it is right

any other ideas? thanks

Dave Hawley · Mar 29th, 2002, 05:30 PM

Hi robfo0

I just tried this and it worked ok.

TextBox1.Value = Format(Range("A1"), "0.00%")

What sort of Control are you parsing to?

Ivan F Moala · Mar 29th, 2002, 05:55 PM

Quote:

On 2002-03-29 16:18, robfo0 wrote:

But i keep getting a Type Mismatch error. The data in the cell named "RATE" is formatted as a percentage also.

HELP! Thanks

Hi
It worked for Me ??
You say <>

What control are you using ??

Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 05:18 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Can you not format a field in a userform as a percentage? I'm trying to use this code: FIRST_RATE = Format(Worksheets("Sheet1").Range("RATE"), "0.00%") But i keep getting a Type Mismatch error. The data in the cell named "RATE" is formatted as a percentage also. HELP! Thanks

Mar 29th, 2002, 05:21 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	You might want to check that the value in the referenced cell is actually numerical, that is to say the percentage symbol appears due to the cell format, rather than actually being in the cell contents.

Mar 29th, 2002, 05:27 PM	#3
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	It is...i input 12.99 in the reference cell. I tested it in a payment to make sure it is right any other ideas? thanks

Mar 29th, 2002, 05:30 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi robfo0 I just tried this and it worked ok. TextBox1.Value = Format(Range("A1"), "0.00%") What sort of Control are you parsing to?