Jump to Cell Based on Forula Value

WTFCIVILENG

New Member
Joined
May 25, 2024
Messages
4
Office Version
  1. 2021
Platform
  1. Windows
Trying to create a jump button as have a very long lis of values. want to be able to enter a value in cell D, then the cell selected jump down to where it is in the list. So if i put in 1.04, the cursor or selected cell jumps down to C8, if I put in D1 vlaue 1.10, it jumps down to C20 where it lists 1.10, if if put 2.20, if jumps down to cell C220. Want to create the VBS code and then attach it to an image.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
.... if if put 2.20, if jumps down to cell C220. Want to create the VBS code and then attach it to an image.

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:
 
Upvote 0
the location of the cell will shift but the text or value will remain constant. will try the search box now.
 
Upvote 0
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?
 
Upvote 0
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
 

Attachments

  • Screenshot 2024-05-26 174102.jpg
    Screenshot 2024-05-26 174102.jpg
    120.6 KB · Views: 1
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top