469,081 Members | 1,885 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Require draggable visual object in Excel VBA

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

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?
Simon Cullen
Simon.Cullen@ BHPBilliton.com (remove the space to reply)

Jul 17 '05 #1
0 2851

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Dominique MILLOT | last post: by
1 post views Thread by Marc Miller | last post: by
7 posts views Thread by Alan Roberts | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.