Nytmare
David Jose
I know that there has to be at least one other person in here who has a working knowledge of coding visual basic in Excel.
First and foremost, I want to know who you are so that we can bounce problems off of each other while we use this god awful program for our character sheets.
Secondly, I need to solve this problem, and I don't even know how to word it properly for a google search.
What I know how to do: I push a button, and the program grabs a bunch of information from a bunch of cells and builds a comment box. That part is fine. The problem: I have 80 other instances where I want to use this program, but I don't want to program 80 different buttons for each different set of cells.
My solution is that each button has a different ID as it's name and the program looks at a different spot in the matrix based off of what button was pushed. I just have absolutely no idea how vba interacts with button names, or what to search for to find out.
First and foremost, I want to know who you are so that we can bounce problems off of each other while we use this god awful program for our character sheets.
Secondly, I need to solve this problem, and I don't even know how to word it properly for a google search.
What I know how to do: I push a button, and the program grabs a bunch of information from a bunch of cells and builds a comment box. That part is fine. The problem: I have 80 other instances where I want to use this program, but I don't want to program 80 different buttons for each different set of cells.
My solution is that each button has a different ID as it's name and the program looks at a different spot in the matrix based off of what button was pushed. I just have absolutely no idea how vba interacts with button names, or what to search for to find out.
Last edited: