View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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)?