| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a cell in a user form text box -- Excel 2003 VBA | Excel Discussion (Misc queries) | |||
| display current cell contents in another worksheet | Excel Worksheet Functions | |||
| Display cell contents in a second worksheet file | Excel Discussion (Misc queries) | |||
| Display Worksheet image on a form | Excel Programming | |||
| Display Worksheet image on a form | Excel Programming | |||
![Gixxer_J_97[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
