I am trying to setup a simulation for a process flow of carts on a
factory floor and I want to make a simulation in Excel. What we do is
have cards that represent carts and we move the carts from machine to
machine according to the rules at each machine. This is all done with
paper cards on a desk. What I am thinking is putting obejects on the
screen of Excel, like command buttons or flow chart shapes, and then
visually move them from 1 location (cell) to another as my VB code
runs thru each increment of time and what is supposed to happen with
each cart. This is where I am struggling. I would like to have the
cart "object", what ever that is, have some additional properties.
Something like this:
Cart_1.movetime
Cart_1.timeatmachine
Cart_1.partcount
etc.
How and what would be the best "object" to use to be able to add
properties to like above and then change them as the VB program walks
thru a time range and moves the carts according to their individual
parameters.
I am not looking for someone elses program to do this, as I have seen
them, I want to set it up to run the way I want it to work.
I am pretty good with VBA so do hold back on a solution that would be
great but complicated to create.

I appreciate any help or direction you can give me.
Thanks
Scott