xltrader100
08-17-2008, 05:07 PM
Users of a program often don't want their Clipboard messed with while they're interacting with a userform, but the form still needs to copy things internally to perform it's function. I found some halfhearted solutions that involve saving the Clipboard contents to a file, or to a cell, or to internal memory and then restoring afterwards, but that seems totally unworkable to me because how do you know when "afterwards" is. It would have to be after every keystroke or mouse click to be totally transparent to the user.
I thought the Office Clipboard might be a way out, but everything I can find on that says it's not accessible by VBA. So, how do other people do it? Or is it not possible.
I thought the Office Clipboard might be a way out, but everything I can find on that says it's not accessible by VBA. So, how do other people do it? Or is it not possible.