MACROS

%3CLINGO-SUB%20id%3D%22lingo-sub-1525633%22%20slang%3D%22es-ES%22%3EMacros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525633%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20someone%20can%20help%20me%20with%20buttons%20in%20Excel%2C%20I%20need%20to%20make%20a%20button%20lead%20me%20to%20a%20new%20sheet%20but%20I%20do%20not%20know%20the%20formula%20that%20I%20have%20to%20insert%20in%20visual%20basic%20to%20achieve%20it.%20Help%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1525633%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527140%22%20slang%3D%22en-US%22%3ERe%3A%20MACROS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527140%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730311%22%20target%3D%22_blank%22%3E%40almeng%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F2879-excel-create-button-to-open-sheet.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F2879-excel-create-button-to-open-sheet.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527244%22%20slang%3D%22en-US%22%3ERe%3A%20MACROS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730311%22%20target%3D%22_blank%22%3E%40almeng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMany%20ways%20lead%20to%20Rome%20...%20one%20way%20is%20via%20hyperlink%3A%3DHYPERLINK(%22%23'Tabelle3'!C7%22%3B%22Spring!%22)%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAnother%20way%20with%20macros%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EPrivate%20Sub%20CommandButton1_Click()%3CBR%20%2F%3EApplication.Goto%20Sheets(%22Tabelle2%22).Range(%22C25%22)%3CBR%20%2F%3EEnd%20Sub%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hola, alguien me puede ayudar con los botones en Excel, necesito hacer que un botón me conduzca a una hoja nueva pero no se la formula que tengo que insertar en visual basic para lograrlo. Ayuda por favor.

2 Replies
Highlighted
Highlighted

@almeng 

 

Many ways lead to Rome ... one way is via hyperlink:=HYPERLINK("#'Tabelle3'!C7";"Spring!")

Another way with macros:

Private Sub CommandButton1_Click()
Application.Goto Sheets("Tabelle2").Range("C25")
End Sub

 

I would be happy to find out if I could help.

 

Nikolino

I know I don't know anything (Socrates)