Userform combo box storing data as text 1

[Kurupt55]

I am new to VBA and am having some trouble with combobox storing numbers as text.
The combobox pulls data from a named range in a sheet containing numbers (stored as numbers)
the user selects a number and then hits a confirm command button with the following code

Private Sub Confirm_Click()

Application.ScreenUpdating = False
Sheets("data").Visible = True

Sheets("data").Range("J1").Value = case1
YourCase.Hide

Sheets("data").Visible = xlVeryHidden
Application.ScreenUpdating = True


End Sub

Case1 is the combobox.
When this puts the data in the cell it returns N/A error with my vlookup in the sheet.
How do i ensure that this is stored as a number compatible with my vlookup

Thanks

Impossible is Nothing

 

[GVF]

Hello,

Comboboxes, dropdowns, etc. all hold values as strings. Use the VAL function to change the combobox value to a number.

Sheets("data").Range("J1").Value = Val(case1)

If you allow a user to input something then you should add a couple of lines of code that check to make sure that the user actually input a number. See IsNumeric in VBA help or the worksheet function IsText in Excel help.

 

[Kurupt55]

Thanks for that, did the trick nicely.
The user will be resticted to choosing one of the options provided, so it will always be a number but thanks for the tip.
Star for you

Impossible is Nothing