Goto Method of Application Object VBA

Goto Application Method in VBA is used to select any range on a worksheet or select any visual basic procedure in any workbook. If that specified workbook is not active, then it activates that workbook. Please find the syntax and examples of Goto Application Method in VBA.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


VBA Goto Application Method – Syntax

Here syntax for Goto method of application object in VBA.

Application. Goto (

[Reference], [Scroll])

Where
Reference: It is an Optional parameter. It specifies the destination. If you don’t specify this argument, the destination will be last used range.
Scroll: It is an Optional parameter. It has Boolean value either True or False. If the value is true then it will scroll through the window. If it is False then it won’t scroll through the window.
In the above syntax Application represents object and Goto is the method of Application.

VBA Goto Application Method: Example 1

Please find the below example for Goto method of application object in excel VBA. The below procedure select a cell ‘A250’ on the worksheet named Sheet1. And in the below statement mentioned ‘Scroll:=True’ it scrolls through the worksheet.

Sub Appl_Goto()
Application.Goto Reference:=Worksheets("Sheet1").Range("A200"), Scroll:=True
End Sub

VBA Goto Application Method – Instructions

Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 6: Now press F5 to execute the code and check how the Goto method is working in Worksheet.

LIMITED TIME OFFER

3 Comments

  1. Pawan Yadav December 24, 2015 at 9:36 AM - Reply

    Very Good Explanation.
    In addition you can also refer to any macro:

    Code: Application.Goto “Macro1”

    • Sabby March 22, 2016 at 1:48 PM - Reply

      I have a value in range of column ‘H’ which is the reference to the cell where the goto should apply, could you please help me with the VBA code where the goto takes the value from the active cell.

      Any help is appreciated

    • sai March 9, 2017 at 6:47 PM - Reply

      Hi Pawan Yadav,

      Could you please explain more about your code, please…

Leave A Comment


Related pages


count if in exceldelete rows in excel vbavba hide columnvba for ms accesspivot table basicsvba code for msgboxfind duplicates excel 2003vba cell valuevba run sql queryremoving password from excel 2007fte calculator excelhow to delete duplicate numbers in excelexcel unlock cellsactive worksheet vbavba repeat untilexcel vba wait functionhow to determine duplicates in excelpivot table in sql server 2008 exampleexcel vba passwordhow to use hlookup in excel 2007 with exampleconditional statements excelexcel formulas made easyvba create databasehow to use count function in excel 2007excel formula protectionmatch formula in excelwhat is vba macroinputbox excel vbaexcel vba collectionbreak excel workbook passwordexcel look up functionadvanced filter vbavba columns selectexcel consolidate multiple worksheetsfreshers interview questions and answersaccess vba rgb color codeslogical operators excelvba if statementhow to sort excel sheets alphabeticallyexcel string appenddashboard examples pptexcel vba workbooks.openresource capacity planning excel templatehow to lock the excel sheetvba numberformatfso deleteexcel tick boxespowerpivot tutorial 2010word and excel test for interviewvba exit loopwhere to find pivot table in excel 2010how to change macros in exceladvanced excel pptcreating macro in excelexcel vba msgbox vbyesnovba crlfsas coding for beginnersexcel merge cells formulaexcel merge sheets into onevba string containsms excel iserrorexcel vba range cellsmicrosoft word project management templatemicrosoft planner templatescomplex if statements in excelinsert button in excel 2007using iserror with vlookupscheduling templates excelexcel vba displayvba query accessspreadsheet for estimating construction costsexcel how to unhide column aexcel learning tutorialword add developer tab to ribboncells.find vba