Visual Basic

[Guest]

I have absolutely no experience with Visual Basic so I really have no idea
how to write this code. I need to write one that creates a timeline - so it
would create different lengths for rectangles based on how long a project
lasts. Thanks for any and all help.

 

[Alex Dybenko]

Hi,
Not sure that somebody can write you whole procedure here. Probably you can
look at a product which has such functionality - for example MS Project

 

[John Nurick]

This isn't exactly a beginner's programming exercise, so unless you have
some graphics programming experience in other languages I'd strongly
advise you not to start from here.

But you can probably you can get what you describe without any coding,
by using a stacked column chart with just one column and feeding it the
appropriate data.

 

[Guest]

I don't know if I'm being incredibly thick here but, try this.

Create a rectangle on a form. Ensure that the back style is set to normal
and that the back colour is set to anything other than the form colour.

Create a text box and in the 'After Update' Event Write:

Me.Box54.Width = Me.Text55 * 50 - Box55 and Text55 were the names of my two
controls. Change these to reflect the controls on your form.

To test run the form and enter a number in the text box. This number is
multiplied by 50 twips to increase or decrease the width of the box.
Presumably when you've added all your bits and pieces the number will be
derived from somewhere else.

I'm sure that a 'guru' would put me to shame on this.

Michael K