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.
Bookmarks