Create a button to move up/down sheet or a drop down

drop05

Active Member
Joined
Mar 23, 2021
Messages
285
Office Version
  1. 365
Platform
  1. Windows
Hello, I wanted to see if it is possible to create either a button or a drop down that can take me to a section on an excel sheet. I have 10 sections that are the same but can take different values in the section

The title "Section 1" is on C12 then the next section is c78 and so on meaning each section is 66 rows a part is there a way to create a button to go up or down that many rows to show the sections, or a better maybe a drop down where I can select what section to go to from section 1-10 that way i dont have to scroll all the way up to hit the button at the top?
Unless i freeze the frame so the button stays there but i feel a drop down would be nicer and easier so no need to click the button multiple times. Thank you!
VBA or maybe a macro is what i was thinking
Thank you in advance
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Hello. A simple solution would be to create a Range Name on each section's header. Then from anywhere just hit F5 and pick from the list of Range Names. Does pretty much the same thing as a dropdown list. Cheers.
 
Upvote 0
Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
Double click on the range in column C that you mentioned, and the script should take you to the next range

Just double click on the range your taken to and you will taken to that range
The selected cell will be color Yellow
Just double click on that cell to be taken to next Range
VBA Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  2/18/2022  1:58:02 PM  EST
Cancel = True
Dim ans As String
Select Case Target.Address

    Case "$C$12", "$C$78", "$C$144", "$C$210", "$C$276", "$C$342", "$C$342", "$C$408", "$C$474", "$C$540"
        ans = Target.Address
              Range(ans).Offset(66).Select
              Selection.Interior.Color = vbYellow
        End Select
        End Sub
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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