|I have combobox (active control) with list range, if I select a value from that list, I want to go to a cell in a column with that exact value. (Match the value selected from combobox)|
This code works, but only with the value "costs". I want to replace the static value "costs" which I put in, with a selection from the combobox.
Private Sub combobox1_Change()
Cells.Find(what:="Cost", After:=ActiveCell, LookIn _
:=xlValues, Lookat:=xlWhole, Searchorder:=xlByRows, Searchdirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate