want to use single button to goto multiple cell

Hello All,
I need help to program a button to just navigate to different cell which I specify for example I have a button and if click 1st time so it should goto D43 and when click again it should goto D59 and if click again should goto D60 and so on. But I want to use just one button.

if it cannot possible from a single button so I can also use spinbutton or something but it will not look good in my way.

thank you guys in advance hopefully you can help me

Re: want to use single button to goto multiple cell (excel)

Thank you soo much dear this is very helpful

Re: want to use single button to goto multiple cell (excel)

Quote from NoSparks;775759

Perhaps you could use a macro along the lines of this assigned to the button

Code

Option Explicit
Dim nextClick As Long


Sub WhereToGo()
  If nextClick = 0 Or nextClick > 3 Then nextClick = 1
  Range("D" & Choose(nextClick, 43, 59, 60)).Select
  nextClick = nextClick + 1
End Sub

Thank you very much it is perfect for me