Hi, I want to do a userform allowing users to create new "projects", each with a number of "milestones" and targeted completion dates for each milestones.
Right now, my userform allows users to (1) give the name of the new project (say "temp") and (2) give the number of milestones (say "x"). These are inputed in a data table with "temp" repeated "x" times (i.e. over "x" rows).
The columns "milestones names" and "milestones targeted completion dates" are left empty and must be filled manually by the user. The form therefore only creates placeholders based on the number of milestones but does not allow user to specify each milestone property.
Attached is a WB with the current userform and a sketch of what I would like to achieve.
Basically, I would like to have users input (a) Milestones name, (b) milestone date, (c) click an "add milestone" button. Each added milestone with date would be added to a listbox below. Users could then select an item to delete it or edit it.
Any help greatly appreciated.
Bookmarks