Okay, hopefully I'll explain this correctly so it makes sense.
Sheet1 is named "Home Page", and on here I have 15 different form control buttons that are set up to filter my main set of data on Sheet2 "Division IDPs". These macros work fine. (Don't ask, I needed a template for a bunch of groups/divisions that can't do basic filtering in Excel.)
The problem I'm having is that on Sheet3 "Rep List" I have a list of names in the range of K2:K16. I'm trying to set it up using VBA to change the text on the 15 form control button.
The 15 buttons are named "DivRep1" thru "DivRep15 to correspond with the range K2:K16.
I'll wind up having about 20 different files for all the different divisions and trying not to have to manually change the text on each of the buttons.
Any help would be greatly appreciated.
Thanks.
Bookmarks