+ Reply to Thread
Results 1 to 2 of 2

Linking a form button to a worksheet with a condition statement

  1. #1
    Registered User
    Join Date
    03-13-2007
    Posts
    5

    Linking a form button to a worksheet with a condition statement

    Hi,

    I know how to record macros and create IF statements. I am having trouble creating an IF statement in VB (don't know VB) to assign to a button so that when the button is pressed, Excel will take the user to a specific worksheet in the workbook given a certain "True" value for a cell.

    Does anyone know how to do this?

    Thanks,
    Serwar

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Something like this should work:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1