Visio 2003 - Check box question

[Office_dummy]

Hi there

I have relatively basic Visio skills, and want to know whether it is
possible to have a check box function in the process which allows to show if
a task is either:
1. not started
2. in progress
3. completed

the simpliest way was to get the staff to colour the box a different colour
as tasks were moved along but i would a way for them to just hit a check box
of one of the above and have the shape in which that task sits in to be a
different colour.

Thanks

 

[David Parker]

You can change the color of the shape according to the selection made from a
pull down list
For example, you could add a custom property/shape data row named, say
Status, with a a Type 1 (fixed lsit) and a Format "not started;in
progress;completed"
You could insert a User-defined cell called, say, StatusTrigger, with the
formula:
=DEPENDSON(Prop.Status)+SETF(GetRef(FillForegnd),INDEX(LOOKUP(Prop.Status,Prop.Status.Format),"RGB(255,0,0);RGB(255,255,0);RGB(0,255,0)"))

The user selects one of these items in the list, Red to Yellow to Green

These changes should be done to the Master shape so that any instances
inherit them automatically

I cover this sort of thing in my book "Visualizing Information with
Microsoft Office 2007"
www.VisualizingInformation.com

 

[Office_dummy]

Hi David,

Thanks for your reply. I vaguely understand what you are saying however,
don't know how to start the process of doing what you have instructed.

are you able to provide me a step by step?

Cheers
Office dummy

 

[David Parker]

Hi Dummy (?)

I have to go to bed now ... will answer more fully tomorrow!
In the meantime, here is some reading:
http://msdn2.microsoft.com/en-us/library/aa200959(office.10).aspx

 

[David Parker]

Oh, John G's blog is also worth reading:
http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html

 

[Office_dummy]

Hi David,

Thanks for the links. I realise that my skills in Visio are very very basic
from reading these blogs. I have never used anything more than dragging
shapes into the page and putting connectors and adding text. (Sorry thats why
i am calling myself dummy)
the most advance thing I can do is to add a hyperlink. i am sure you ROFL by
now.

thats why a step by step would be greatly appreciated!!!

 

[frank]

Can Visio files be converted to ACAD .dwg files???

 

[David Parker]

I didn't ask if you are using the Professional edition of Visio.
If so, yoiu could use Color By Value under Tools / Addons / Building Plan
No programming, but you will have to re-run when you have shnaged values, I
think

 

[Office_dummy]

Hi there,

yes I am using Professional edition.

Cheers
dummy

 

[David Parker]

Did you try Color By Value?

Hi there,

yes I am using Professional edition.

Cheers
dummy