Jump to a value in a Column...

[Matty]

Hello All,

I am well aware of Excel's "Find..." feature, but I'm interested to know whether the following is possible...

I have a Column of data (Column B). Is it possible, by means of entering a value in a text box, that if that value exists in Column B, I would be taken directly to the Cell that contains said value?

It's just a bit of functionality I'd like to have within a Worksheet I'm pulling together, as it would save a couple of clicks...

Thanks,

Matty

 

[VoG]

A text box on a UserForm or on a sheet?

 

[Matty]

It's on a Worksheet, VoG II.

Thanks,

Matty

 

[matthew230]

Easily done in a userform

 

[VoG]

Try

Sub TBValue()
Dim Found As Range
Set Found = Columns("B").Find(what:=ActiveSheet.TextBoxes("textbox 1").Text)
If Not Found Is Nothing Then Application.Goto reference:=Found, scroll:=True
End Sub

 

[Matty]

Thanks VoG II, but how/what executes the jump to occur?

Matty

 

[VoG]

Thanks VoG II, but how/what executes the jump to occur?

Matty

You do - Tools > Macro > Macros > highlight TBValue and click Run.