Setting up project management calendar with VBA

[wsk92]

Im completely new with VBA and despite my attempts i cant seem to get very far.

I have created a project calendar with the projects across the top and the dates along the side. I basically want to take dates from another workbook and insert them into the calendar automatically.

For instance taking the project start and putting it into the correct date and the right project.

Can anybody help me?

Thanks,

Will

 

[ranman256]

I would have a userform, with a listbox. The listbox has the list of projects.
user picks a project
this shows the date,
enter new date in New Date box.
click button...this would assign it.

 

[wsk92]

thanks for the help.
I actually already have something close to that description that is not using vba. I can type in a project number and it will show me the start date and finish date of each part of a project.

What id like to be able to do is take that info and put it out onto one calendar with all the data there for the reader to see straight away.

The main issue i am having is knowing which functions i should use.

Thanks again!

I would have a userform, with a listbox. The listbox has the list of projects.
user picks a project
this shows the date,
enter new date in New Date box.
click button...this would assign it.