Using Command button to highlight row based on combo box value

Hi,

I've built a front end dashboard for a database, I have code that enables me to show the key details based on the value in a combobox, what I am trying to do is programme a command button to activate the row based on a the combo value. I have got the principle working but it currently highlights the row 10 too low eg using row 1 highlights row 10 and row 2 highlights 11 etc


Private Sub CommandButton1_Click()

Dim l As Long

Sheets("Tracker").Select
Rows("1")("1" & ComboBox1.ListIndex).Select


Sheets("Tracker").Select

Unload Me

End Sub

Any Idea where I'm going wrong?

Try

Please Login or Register  to view this content.

Also please edit your post to include code tags, the # icon in the reply/edit window

Bingo, Thanks, knew it was simples

You're welcome & thanks for the feedback