Require draggable control within Excel
 

Hi all. I am doing some Excel VBA programming for an engineering group
in the area of production scheduling. Most of it is going OK but they
have some ideas for a bit of a dream tool. Eventually this stuff will
be replaced by SAP APO, but right now it is all in Excel.

They want to show visually the status of various schedules, in a format
very similar to a gantt chart in MSProject. Each day they want to play
with the schedules, taking one schedule and lengthening it or
shortening it not by changing the data, but by dragging the actual
schedule itself longer or shorter.

Can this be done in Excel?
Should I be trying to use an MSProject control through ActiveX?
Is there a simpler and more suitable ActiveX control anyone can
recommend?

Maybe the the control would need to be bound to the data in the
underlying cells somehow (don't know how this would work)?

Say you had dates in coloumns across the top of the sheet. The control
would basically be a coloured rectangle that the user can stretch to
cover 3 days instead of two if the schedule slips - or shorten to one
day if the ship is loaded quicker than expected. It's hard to explain
in words - anyway, like a Gantt chart.

Any ideas?
Thanks
Simon Cullen
Simon.Cullen@ BHPBilliton.com (remove the space to reply)

Require draggable control within Excel
 

See answer to later posting of this question.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Hi all. I am doing some Excel VBA programming for an engineering group
in the area of production scheduling. Most of it is going OK but they
have some ideas for a bit of a dream tool. Eventually this stuff will
be replaced by SAP APO, but right now it is all in Excel.

They want to show visually the status of various schedules, in a format
very similar to a gantt chart in MSProject. Each day they want to play
with the schedules, taking one schedule and lengthening it or
shortening it not by changing the data, but by dragging the actual
schedule itself longer or shorter.

Can this be done in Excel?
Should I be trying to use an MSProject control through ActiveX?
Is there a simpler and more suitable ActiveX control anyone can
recommend?

Maybe the the control would need to be bound to the data in the
underlying cells somehow (don't know how this would work)?

Say you had dates in coloumns across the top of the sheet. The control
would basically be a coloured rectangle that the user can stretch to
cover 3 days instead of two if the schedule slips - or shorten to one
day if the ship is loaded quicker than expected. It's hard to explain
in words - anyway, like a Gantt chart.

Any ideas?
Thanks
Simon Cullen
Simon.Cullen@ BHPBilliton.com (remove the space to reply)