I have one frame in VBA and some objects in in (text boxes in my
case). I would like to copy the content of this frame into frame in
excell... How is this possible...

I tried using .picture but this only copies a picture from one frame
to the other not the entire content...

So, basiclly a screen shot of the frame is what I need.

Hope someone knows...

Thanks

In order to get a screen shot of anything in Windows, I would assume the
object/control would need to expose a handle (hwnd).
As most standard control from the Forms2 library do not, this may prove a
problem.
The Form does, so maybe one of the methods listed under the "PrintScreen"
section here may help:
http://vbnet.mvps.org/code/screen/index.html

NickHK

"Monte0682" wrote in message
ups.com...
I have one frame in VBA and some objects in in (text boxes in my
case). I would like to copy the content of this frame into frame in
excell... How is this possible...

I tried using .picture but this only copies a picture from one frame
to the other not the entire content...

So, basiclly a screen shot of the frame is what I need.

Hope someone knows...

Thanks