Ranges values with properties problems

  • Thread starter Thread starter Melker
  • Start date Start date
M

Melker

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 are:

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
 
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
 
Assume GE_Brighness is a Textbox then

Range("A65536").End(xlUp).Offset(1, 6).Value = cdbl(GE_Brightness.Value)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code does not error but no copy either 4
Transfer array element offset value to a matched value 3
Object variable or with Block variable not set 9
Dynamic Offset from an Application.Goto cell = Date or Time 10
Convert A1 value to a sheet name and copy to it 2
Code works but goes into endless loop and crashes 1
conso macro 0
entering value without acivating sheet 4

Back
Top