How do I restrict Shape Data values entered by users to a specific range?
I am trying to restrict values for Shape Data items to specific ranges (eg the end date is after the start date!). Is this possible in the Visio front end, or do I need to revert to VBA?
April 30th, 2013 7:58am

You could put a formula in a User-defined cell like this:

=IF(AND(Prop.StartDate,Prop.EndDate),IF(Prop.EndDate<Prop.StartDate,SETF(GetRef(Prop.EndDate),Prop.StartDate),0),0)

Free Windows Admin Tool Kit Click here and download it now
June 15th, 2013 6:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics