cardona7
02-27-2010, 03:04 PM
Hi,
I'm new to the forms and relatively new to VBA. I'm a business student taking an engineering class with no prior programming experience. I just need some help getting this w/s to follow the rules of a game. The sheet is attached.
The rules are:
You start node1 and you can only click on node2 or node4, etc. You can only jump on a node that is attached to yours by arrows called Paths. If you going to ThisWorkbook in vba you'll see that their invisible.
I need code for when user clicks from currentNode to another legal Node, the invisible arrow inbetween becomes visible.
The problem is, since its invisible to begin with, an error comes up saying the shape is locked. How do i get to that unlocked shape?
also, how do I determine in code which moves are legal and which arent, IF statements?
I'm new to the forms and relatively new to VBA. I'm a business student taking an engineering class with no prior programming experience. I just need some help getting this w/s to follow the rules of a game. The sheet is attached.
The rules are:
You start node1 and you can only click on node2 or node4, etc. You can only jump on a node that is attached to yours by arrows called Paths. If you going to ThisWorkbook in vba you'll see that their invisible.
I need code for when user clicks from currentNode to another legal Node, the invisible arrow inbetween becomes visible.
The problem is, since its invisible to begin with, an error comes up saying the shape is locked. How do i get to that unlocked shape?
also, how do I determine in code which moves are legal and which arent, IF statements?