EDN Admin
Well-known member
<table border="0" cellspacing="0" cellpadding="0" width="783" style="
<tbody>
<tr style="height:.2in
<td width="783" valign="bottom" style="width:469.5pt; padding:0in 5.4pt 0in 5.4pt; height:.2in
<p style="margin-bottom:0.0001pt I have work instructions for a factory Im putting in a spreadsheet. I print all the work instructions on a standard printer in portrait view. The worksheet typically has multiple pages stacked vertically. Each page consists
of a header about an inch and half tall, which is the same throughout all pages, then the page is split into four equal quadrants with one line of text as a footer. Margins are minimal.
</td>
</tr>
<tr style="height:.2in
<td width="783" valign="bottom" style="width:469.5pt; padding:0in 5.4pt 0in 5.4pt; height:.2in
<p style="margin-bottom:0.0001pt Each quad has a picture, a colored shape about 1/2" tall such as a triangle (inspect), square (work) or circle (verify) and then a number 1 thru 4 (text box) inside that shape depending on the quadrant. And finally each
quad has text describing the work associated with the picture above it. Often we have to add a step after a page has been completed.
I want to be able to highlight a/any quadrant, push a command button and then move that quadrant and all its contents along with all preceding quadrants, down one position in a "Z" pattern. This, so that I can insert a new instruction.
<p style="margin-bottom:0.0001pt At work I have some code written that moves cells content down when highlighted and the button is pushed, but it doesnt include pictures or objects and no "Z" pattern movement. You also have to select empty rows below the
cells so content isnt cut or erased.
<p style="margin-bottom:0.0001pt One way that I have been able to help is that Ive added a button allowing the user to pull in pictures from folders and vb automatically sizes them and positions them starting at a preselected cell, i.e near the top right
hand corner of each quadrant.
<p style="margin-bottom:0.0001pt Some ideas or help would be greatly appreciated.
<p style="margin-bottom:0.0001pt
</td>
</tr>
</tbody>
</table>
View the full article
<tbody>
<tr style="height:.2in
<td width="783" valign="bottom" style="width:469.5pt; padding:0in 5.4pt 0in 5.4pt; height:.2in
<p style="margin-bottom:0.0001pt I have work instructions for a factory Im putting in a spreadsheet. I print all the work instructions on a standard printer in portrait view. The worksheet typically has multiple pages stacked vertically. Each page consists
of a header about an inch and half tall, which is the same throughout all pages, then the page is split into four equal quadrants with one line of text as a footer. Margins are minimal.
</td>
</tr>
<tr style="height:.2in
<td width="783" valign="bottom" style="width:469.5pt; padding:0in 5.4pt 0in 5.4pt; height:.2in
<p style="margin-bottom:0.0001pt Each quad has a picture, a colored shape about 1/2" tall such as a triangle (inspect), square (work) or circle (verify) and then a number 1 thru 4 (text box) inside that shape depending on the quadrant. And finally each
quad has text describing the work associated with the picture above it. Often we have to add a step after a page has been completed.
I want to be able to highlight a/any quadrant, push a command button and then move that quadrant and all its contents along with all preceding quadrants, down one position in a "Z" pattern. This, so that I can insert a new instruction.
<p style="margin-bottom:0.0001pt At work I have some code written that moves cells content down when highlighted and the button is pushed, but it doesnt include pictures or objects and no "Z" pattern movement. You also have to select empty rows below the
cells so content isnt cut or erased.
<p style="margin-bottom:0.0001pt One way that I have been able to help is that Ive added a button allowing the user to pull in pictures from folders and vb automatically sizes them and positions them starting at a preselected cell, i.e near the top right
hand corner of each quadrant.
<p style="margin-bottom:0.0001pt Some ideas or help would be greatly appreciated.
<p style="margin-bottom:0.0001pt
</td>
</tr>
</tbody>
</table>
View the full article