Jump to specific column/ Cell when choosing a value in a combo box

[Dedeke]

hi there,
Im using the code below to jump to the name chosen in the combobox.
Is it possible to change the c.select (which is the matching cell) to jump 3 cells down.

Example: Combobox select name x ( lets say this name is in range H2)
Now i want to jump to range H6 instead of H2(wich is defined by c.select)
Why?? My range H2:Bx3 contains formulas like ==Data!B24

Private Sub ComboBox1_Change()
'Om naam te kiezen en onmiddellijk naar deze kolom te gaan
Dim c As Range
For Each c In Range("H2:Bx3") '(this is where the values are)
If c.Value = ComboBox1.Value Then
c.Select
On Error Resume Next
Exit Sub
End If
Next
End Sub

 

[breynolds0431]

hi there,
Im using the code below to jump to the name chosen in the combobox.
Is it possible to change the c.select (which is the matching cell) to jump 3 cells down.

Example: Combobox select name x ( lets say this name is in range H2)
Now i want to jump to range H6 instead of H2(wich is defined by c.select)
Why?? My range H2:Bx3 contains formulas like ==Data!B24

Private Sub ComboBox1_Change()
'Om naam te kiezen en onmiddellijk naar deze kolom te gaan
Dim c As Range
For Each c In Range("H2:Bx3") '(this is where the values are)
If c.Value = ComboBox1.Value Then
c.Select
On Error Resume Next
Exit Sub
End If
Next
End Sub

Try using offset(r,c):

Instead of using:

c.Select

Try replacing with:

c.Offset(4,0).Select

 

[Dedeke]

Try using offset(r,c):

Instead of using:

c.Select

Try replacing with:

c.Offset(4,0).Select

Thx Breynolds0431

This works fine for me.
Marked as solution as well.

 

[Joe4]

Thx Breynolds0431

This works fine for me.
Marked as solution as well.

In the future, when marking a post as the solution, please be sure to actually mark the first post that contained the solution (not your own thread acknowledging that some other post is the solution).
I have corrected this for you.
Thanks.