seandotson
New Member
- Joined
- Mar 30, 2015
- Messages
- 6
I have a sheet where I have a series of columns with info. I need the ability to click on a button or object in that row and copy that row (technically a range of that row) to the clipboard.
This could easily be solved with VB object control arrays but those do not exist in VBA.
Any suggestions on how to make this work...(I have the code to make the button copy, need help with the object to use to trigger the code)
A visual example: http://i.imgur.com/3BanpHS.png
This could easily be solved with VB object control arrays but those do not exist in VBA.
Any suggestions on how to make this work...(I have the code to make the button copy, need help with the object to use to trigger the code)
A visual example: http://i.imgur.com/3BanpHS.png