I would need to see an example of what you are trying to accomplish. Theoretically it is possible. But complicated and not very cheap for me to program.
I would not use ActiveX controls though as there is a whole host of problem associated with it. But it is certainly possible to create a click event when something is clicked on some data is copied from one sheet to another.
how do you determine when a command button is clicked which row to pull data from?
that would help, but I only need it for a few of them as an example.
Also is the text box to the right, when a button is clicked will that be appended to the text box, in other words if there is already text, will the new text be added? Or will the text box be cleared out each time and replaced with new text?
Also which column(s) on the master sheet populate to the text box?
which column is the master sheet data coming from to go into the text box?
so the whole row, but each cell, would have a carrage return after it?
ok, I think it is all possible.
Now the cost.
It will be $150 to create a macro of this type.
Now most people have a problem once they here the price.
But keep these things in mind.
1. This is how I make a living.
2. The price also includes troubleshooting, if for some reason you cannot run the macro or you get errors, or it doesn't quite work right.
3. The price was arrived at based on my experience, and how long it takes and what is involved in the process on doing this.
i would imagine. Keep in mind I don't control the billing..
ok, i sent the offer for the additional fee, when you accept it I can get started
i have not heard back from you