Adding a cell in sheet selection via vba

Hi Everybody,

I recently started to learn vba by myself so don't be too arsch if my questoin seems stupid.

In order to perform a more complicated task, I would like to create a button which directs me to another sheet. Here is my actual vba :

Private Sub CommandButton1_Click()

Sheets("06.01 - 10.01.2020").Select

End Sub

I would like to replace "06.01 - 10.01.2020" by the content of a cell in my active sheet, is it possible ? Does it change anything if the cell I want to use is on another sheet ?

Also, is it possible to implement a formula in this code ? (something like
Sheets("=RANK.EQ(A1:A55)").Select for example)

Thanks in advance for any answer that you may have !!

Please Login or Register  to view this content.

where the sheetname is in A1

for your 2nd question yes but its not clear what you are asking, where does the answer go?

Thanks for your answer !

For the 2nd, the formula I wanted to use was LARGE not RANK.EQ, sorry for that.

Let's say we have numbers in cells A1 to A55 (these numbers are also the names of the 55 sheets in my workbook). Can I insert LARGE into my vba so that the button directs me to sheet whose name is the 25th biggest number ?

thank you for the answer !

thank you !!