Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 918
  • Last Modified:

VBA to go to another worksheet in same workbook via command button

Folks,
Another senior moment in paradise. What is the code for a command button that takes me to anoter worksheets I forgot.....
0
Frank Freese
Asked:
Frank Freese
  • 2
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
worksheets("____").select

or

worksheets("____").activate
0
 
JimFiveCommented:
ActiveWorkbook.Worksheets("WorksheetName").Activate
0
 
Frank FreeseAuthor Commented:
great - two good solutions to help this ole man out! I am very grateful
0
 
Frank FreeseAuthor Commented:
great job! thanks a lot. Both solutions got me what I needed
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now