Results 1 to 5 of 5

Run Macro on different worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    Roseville, USA
    MS-Off Ver
    Excel 2013
    Posts
    15

    Run Macro on different worksheet

    Hi - My Excel 2013 Spreadsheet/Workbook has two sheets, Tool and Positions. The Positions sheet is simply a number of columns with filters applied. I created checkboxes that call macros that apply filtering. Everything works perfectly fine as long as the checkboxes are on the Positions sheet where the data is. Issue is - I need the checkboxes on the Tool sheet. I have searched for a few hours now and cannot seem to find what I have to think is a small bit of code that let's me create the checkboxes on the Tool sheet while having the macro on the checkbox run on the Positions sheet. My macro code follows:

    Private Sub AppBar_Click()
    Select Case AppBar.Value
        Case True: Call AppBarYes
        Case False: Call AppBarNo
    End Select
    End Sub
    To reiterate the code above is on the checkboxes that are sitting on the Positions sheet. I need tthe checkboxes on the Tool sheet. Is there a line of code or two I can add to the code above allowing me to create the checkboxes on the Tool sheet and tell the marco to run on the Positions sheet where the filtered data is?

    Thanks in advance for any assistance.
    Last edited by Leith Ross; 04-02-2014 at 09:44 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro/VBA code to Copy data from primary worksheet to a worksheet opened by macro
    By MHamid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2013, 11:10 AM
  2. Macro to select worksheet based on cell value and then return data to diff worksheet
    By clnossok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2013, 07:48 PM
  3. Excel 2010 Macro to copy worksheet, update formula and rename worksheet
    By madmak0203 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:18 PM
  4. Replies: 1
    Last Post: 08-29-2012, 07:11 PM
  5. [SOLVED] Macro to copy cells from one worksheet to another copies worksheet data as image instead??
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2012, 11:26 AM

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