type mismatch error

  • Thread starter Thread starter Valeria
  • Start date Start date
V

Valeria

Dear experts,
I am getting a type mismatch error with my sub
Private Sub OK_Btn_Click()
Dim Country_Name As String
Country_Name = Me.ComboBox1.Value
Worksheets("Choix").Cells("c15").value = Country_Name
Unload Me
End Sub

I guess it's because Country_Name is a string, and
Worksheets("Choix").Cells("c15").value is read as integer.
How can I set this up so that it works?

Many thanks in advance for your help,
Kind regards,
 
Hi

Change "Cells" to "Range" and your problem should be solved

If this helps please click "Yes"
<><><><><><><><><><>
 
it works beautifully, many thanks!
--
Valeria


BSc Chem Eng Rick said:
Hi

Change "Cells" to "Range" and your problem should be solved

If this helps please click "Yes"
<><><><><><><><><><>
Click to expand...
 
Hi,

Change this

Worksheets("Choix").Cells("c15").value = Country_Name

to this
Worksheets("Choix").Range("c15").value = Country_Name
or this
Worksheets("Choix").Cells(14, 3).Value = Country_Name

Mike


Mike
 
Back
Top