Activecell value inserted as number

[didrby]

In a macro, I have a form (Bedding_Tag_Information) that has been filled out with sizes (bti_length, bti_width, and bti_thickness. These are the variables assigned to the numbers keyed into the form. When I click the "Done" button, I want to paste the values into sheet (body) and starting at range (body_poly). I then have a vlookup on the bti_thickness for a calculation. The cells on the sheet (body) are formatted as numbers, but when I use Activecell.Value = bti_thickness, the macro puts the correct number in the cell but changes the format. Then the vlookup returns the #N/A. Any help? Thanks.

 

[Andrew Poulsom]

Try:

Activecell.Value = Val(bti_thickness)

It's probably a string from a TextBox.

 

[Aaron Blood]

Andrew's solution will work...

However, you should just explicitly state that you'd like to pass a value from the textbox.

Instead of:
Activecell.Value = bti_thickness

Use:
Activecell.Value = bti_thickness.Value

 

[Andrew Poulsom]

Andrew's solution will work...

However, you should just explicitly state that you'd like to pass a value from the textbox.

Instead of:
Activecell.Value = bti_thickness

Use:
Activecell.Value = bti_thickness.Value

Aaron,

The OP said "These are the variables assigned to the numbers keyed into the form."

So I assumed they weren't the TextBoxes.

 

[Aaron Blood]

Perhaps that's a fair assumption.

I think they're referring to textboxes even though they say, "variables".

I guess it is possible someone could create a textbox on a userform and then assign it to a variable:
bti_length = Textbox1

But, if they want to pass it as a value they should still use:
bti_length = Textbox1.Value


Whichever way they meant, I think we got em covered.

 

[didrby]

Thanks for the help. I an new at VBA and the teminology. It was a text box in the form. I did use the Activecell.Value = bti_thickness.Value and it worked great!