google DOCMD and you can see all the functions available for shapesheet and all available for VBA
I have used DOCMD(1312) in user cells and event drop and eventdblclk
you can get real slick and build context drop downs. Things like
- show a subset of props....network parameters only....server parameters...etc using actions
some thing like
action.net = setf(getref(action.net.checked), if action.net.checked = 0,1,0)
action.server = setf(getref(action.server.checked), if action.server.checked = 0,1,0)
user.selection = if (action.net.checked, 2, if (action.server.checked, 3, 0) + docmd(1312) //or similar
props.ipaddr.showhide = if user.selection =2, 0,1
props.dram.showhide = if user.selection = 3, 0,1
so when actions used, user.selection update which trigger docmd(1312) after update
- show a subset of props by a menu via props that value in a high level props
- or even a right click and select network or server
- etc.
the problem is that since this does not work at top level, it makes doing these kinds of things less impactful
since its unlikely a user would tunnel into some child shape to then do all this
Note, if you do these kinds of things the shape in and of itself grows.
I have done this for blades...a single blade shape would be about 500KB for something like 50 parameters
