display contents of a worksheet in a form/frame
 

is there a way to display the contents (specifically a range) of a specific
worksheet in a user form? (or a frame - perhaps using tabs to display
multiple worksheets)?

display contents of a worksheet in a form/frame
 

Does the data need to be editable, or would a picture of the range be
enough?

If no need for editing you could use the copypicture method of the range,
and copy the resulting image into an image control on the form.

Tim.


"Gixxer_J_97" wrote in message
...
is there a way to display the contents (specifically a range) of a
specific
worksheet in a user form? (or a frame - perhaps using tabs to display
multiple worksheets)?

display contents of a worksheet in a form/frame
 

it doesn't need to be editable (but that would be a nice feature).

how do i paste the copied range to an image in a form?


"Tim Williams" wrote:

Does the data need to be editable, or would a picture of the range be
enough?

If no need for editing you could use the copypicture method of the range,
and copy the resulting image into an image control on the form.

Tim.


"Gixxer_J_97" wrote in message
...
is there a way to display the contents (specifically a range) of a
specific
worksheet in a user form? (or a frame - perhaps using tabs to display
multiple worksheets)?

display contents of a worksheet in a form/frame
 

Maybe look at "pastepicture.zip" he

http://www.bmsltd.ie/Excel/Default.htm


Tim


"Gixxer_J_97" wrote in message
...
it doesn't need to be editable (but that would be a nice feature).

how do i paste the copied range to an image in a form?


"Tim Williams" wrote:

Does the data need to be editable, or would a picture of the range be
enough?

If no need for editing you could use the copypicture method of the
range,
and copy the resulting image into an image control on the form.

Tim.


"Gixxer_J_97" wrote in message
...
is there a way to display the contents (specifically a range) of a
specific
worksheet in a user form? (or a frame - perhaps using tabs to display
multiple worksheets)?