Ranges values with properties problems
 

Hi everyone,

I have a problem that i do not know how to solve.
I have two user forms that are "sending" a value to a place in an excel
sheet.
When the value is sent to the sheed a warning apears on the sheet.
It seems that the value has been sent to the sheet as text rather than a
number.

The two rows of code a

GE_Brightness.Value = Range("AA12:AA5000").Find(Select_entry,
LookIn:=xlValues).Offset(0, -20).Value

and

Range("A65536").End(xlUp).Offset(1, 6).Value = GE_Brightness.Value

How do i get the value to become a "number" rather than "text".
I get problems since i than have some conditional formating that do not like
"text".


Thank you in advance

Melker

Ranges values with properties problems
 

Melker,

What is GE_Brightness, a variabel? If so, this line looks wrong to me

GE_Brightness.Value = Range("AA12:AA5000").Find(Select_entry,
LookIn:=xlValues).Offset(0, -20).Value

it should be

GE_Brightness = Range("AA12:AA5000").Find(Select_entry,
LookIn:=xlValues).Offset(0, -20).Value


--

HTH

RP

"Melker" wrote in message
...
Hi everyone,

I have a problem that i do not know how to solve.
I have two user forms that are "sending" a value to a place in an excel
sheet.
When the value is sent to the sheed a warning apears on the sheet.
It seems that the value has been sent to the sheet as text rather than a
number.

The two rows of code a

GE_Brightness.Value = Range("AA12:AA5000").Find(Select_entry,
LookIn:=xlValues).Offset(0, -20).Value

and

Range("A65536").End(xlUp).Offset(1, 6).Value = GE_Brightness.Value

How do i get the value to become a "number" rather than "text".
I get problems since i than have some conditional formating that do not
like
"text".


Thank you in advance

Melker

Ranges values with properties problems
 

Assume GE_Brighness is a Textbox then

Range("A65536").End(xlUp).Offset(1, 6).Value = cdbl(GE_Brightness.Value)

--
Regards,
Tom Ogilvy

"Melker" wrote in message
...
Hi everyone,

I have a problem that i do not know how to solve.
I have two user forms that are "sending" a value to a place in an excel
sheet.
When the value is sent to the sheed a warning apears on the sheet.
It seems that the value has been sent to the sheet as text rather than a
number.

The two rows of code a

GE_Brightness.Value = Range("AA12:AA5000").Find(Select_entry,
LookIn:=xlValues).Offset(0, -20).Value

and

Range("A65536").End(xlUp).Offset(1, 6).Value = GE_Brightness.Value

How do i get the value to become a "number" rather than "text".
I get problems since i than have some conditional formating that do not
like
"text".


Thank you in advance

Melker