display contents of a worksheet in a form/frame

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
capturing TabStrip events inside an MsForm 4
Making a frame visible or not using a command button 3
Excel 2013 Merge Data 2
Code for OptionButton displaying new frame 2
Userforms - automating the naming of frame and page tab captions 3
Method to automate page numbers on single worksheet 1
Displaying data in a VBA User Form 1

Back
Top