Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Simple Block Diagram UserInterface
Does any body know how to implement a simple block diagram user interface in
Excel. Here is a simplified version of what I have in mind. Say I have a palette consisting of a few blocks represented by some icons, say a circle, triangle, square, etc. that the user can choose from. I want the user to be able to create a (horizontal) chain of these blocks in any order (say 1-20 blocks in length) either by dragging the blocks from a palette with a mouse, or by choosing insert from a list. For example I might have a horizontal row of touching icons in any order, say square-circle-circle-tirangle-etc. I then want to be able to click on each block and fill in actual values for a common set of parameters: say price, temperature, weight, etc. I also want to be able to change the order of blocks by dragging a block into a different position and insert and delete blocks, if I decide the order is not right for some reason. In the end all that matters is how many blocks are in the chain, what type and order each one block is and of course the entered set of paramters. Then I copy the parameters to a table and do some basic calculations on the data, and generate output results in tablular and grapical format. Is this possible? Can anyone point me to a link with examples? Thanks, John. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if/then block within another if/then block needs a loop | Excel Programming | |||
How do I use a block diagram to draw a floor plan in Excel? | Excel Discussion (Misc queries) | |||
Diagram | Excel Discussion (Misc queries) | |||
Protect UserInterface VS Protect/Unprotect | Excel Programming | |||
Can't get userinterface variant to work on mac. | Excel Programming |