Jump to Cell Based on Forula Value

WTFCIVILENG said:

.... if if put 2.20, if jumps down to cell C220. Want to create the VBS code and then attach it to an image.

Click to expand...

WIll that value always be contained in cell C220? What happens if the list gets updated and things get shifted around? The better option would be create a search box that users can type into (2.20 for example) and then jump to the cell containing the value. You can achieve this with a ActiveX control search box.

Here are some examples:

the location of the cell will shift but the text or value will remain constant. will try the search box now.

That is really handy to see what you have entered for that cell value, but need to jump down to row 220 to enter the data. I've used =MATCH(B6,C:C,0) to figure out the row number for the specific text (this formula will always remain in the same spot, but now ned to create a method to jump down to that row. Bear in mnd that the row the text in will change depending on data input. so thought if there is a way to create a vba code to jump to that row based on the formula input?

Screenshot is the excel sheet. basically song names 1.01 up to 1.99 is in clumn C. Column A orks out the row the first time 1.01, 1.02, 1.03 etc. is listed