Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL 97 - designing form with zooming capabilities
Hi,
For a Glass House Plants Grower I'm designing an application that will keep track of his plants. More specific: at which location exacly in his acres big glass house are at any given time his plants (so he knows where the plants are that need pruning after x weeks, that need bigger pots after y weeks etc.) The plants are on rolling tables. The tables are on 100+ tracks (lets say: all are laying direction North-South) Adjacent to the tracks are 2 extra tracks (1 at the North-side and 1 at the South-side) laying East-West On each of these 2 trackts are moving devices (call 'm trains if you like) that are able to pick up a rolling table from one of the 100 tracks and move it to and "drop" it on another different track. I'm looking for a good way to present the tracklayout on a form I tried to use screen-wide "thin" labels presenting the tracks and small "thin" labels in different color presenting the rolling tables. That in itself works but probably there is graphically-wise a better way to do it. Also I' don't know how to implement some sort of zooming. One example that I could find that comes close is the Sysinternals DiskView utility: http://www.sysinternals.com/Utilities/DiskView.html Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL 97 - designing form with zooming capabilities
Why not just use the worksheet and have the columns be the North-South
tracks with row 1 as the North-side track and the last row as the South-side track. Assume your tables are numbered, put the number in the cell to indicate location. (of course you can color the cells as well). Then you can zoom in and out on the worksheet using the Zoom under view. -- Regards, Tom Ogilvy wrote in message oups.com... Hi, For a Glass House Plants Grower I'm designing an application that will keep track of his plants. More specific: at which location exacly in his acres big glass house are at any given time his plants (so he knows where the plants are that need pruning after x weeks, that need bigger pots after y weeks etc.) The plants are on rolling tables. The tables are on 100+ tracks (lets say: all are laying direction North-South) Adjacent to the tracks are 2 extra tracks (1 at the North-side and 1 at the South-side) laying East-West On each of these 2 trackts are moving devices (call 'm trains if you like) that are able to pick up a rolling table from one of the 100 tracks and move it to and "drop" it on another different track. I'm looking for a good way to present the tracklayout on a form I tried to use screen-wide "thin" labels presenting the tracks and small "thin" labels in different color presenting the rolling tables. That in itself works but probably there is graphically-wise a better way to do it. Also I' don't know how to implement some sort of zooming. One example that I could find that comes close is the Sysinternals DiskView utility: http://www.sysinternals.com/Utilities/DiskView.html Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Designing Form | New Users to Excel | |||
Designing a Form | Excel Discussion (Misc queries) | |||
Zooming in on a row | Excel Discussion (Misc queries) | |||
Keep the same center while zooming | Excel Programming | |||
designing a form that will update each month | Excel Programming |