Hello all,
I have column A with dates and named dts - column B with numbers
So the combobox row source is dts
The long story short this code cant see the combobox value to search and bring me what i ask
For i = 2 To lastrow
If Sheets("sheet1").Cells(i, "a") = combobox1.value then
textbox1.text= sheets("sheet1").cells(i,"b")
End If
Next
Thanx
I have column A with dates and named dts - column B with numbers
So the combobox row source is dts
The long story short this code cant see the combobox value to search and bring me what i ask
For i = 2 To lastrow
If Sheets("sheet1").Cells(i, "a") = combobox1.value then
textbox1.text= sheets("sheet1").cells(i,"b")
End If
Next
Thanx