type mismatch error

[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,

 

[BSc Chem Eng Rick]

Hi

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

If this helps please click "Yes"
<><><><><><><><><><>

 

[Valeria]

it works beautifully, many thanks!
--
Valeria

Hi

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

If this helps please click "Yes"
<><><><><><><><><><>

 

[Mike H]

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