Wednesday, November 6

Select Or Activate The Sheet In Excel With VBA

INTRODUCTION: Worksheets Are Part Of Workbook In Excel Application.

  1. Open Excel File
  2. Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.
  3. One Dialog Screen Will Get Open
  4. Click Insert And Add Module
  5. Create Sub Procedure With Any Name
  6. Make Sure The Procedure Name Start With String And Without Space.
  7. Write The Code In Between Sub And Sub End
  8. Click Run Button Or Insert A Form Button In Excel Sheet
  9. Any Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.
  10. DIFFERENCE := For Example Sheets(1).Range(“A1”).Select Like This You Can Apply Select Method To Select The Sheet & At the Same Time Range Too. But you Can’t Apply This Same Method For Activate That’s The Difference Between Select And Activate.
  11. That’s It 🙂
  12. Please Check The Images And Video For More Info.

Leave a Reply

Your email address will not be published. Required fields are marked *