Userform with dependent combo/text boxes that then update table

[Plane Fixer]

Hi all,
I have used this forum many times and love the brilliant contributors. This is my first post as this time I have found some answers close to what I need but lack the VBA skills to adapt them exactly to my new project and have been struggling.

I have a project where I am tracking in Excel 2007 the contributions of over 50 part time contributors to a large volume of work over several months. I need them to regularly update the status on their assigned chapters but some are daunted by my large workbook that has many other functions for me to manage. So I have created a simple colourful form where they will see just three boxes and can update their % complete simply.

The first combo box must let the author select their name. Some authors are responsible for more than one chapter. I don’t want their names to appear more than once in the drop down list - it should stay as short as possible.

The second combo box should be dependent on the first so that each author only sees the chapters assigned to them.

And now the trickiest bit. The third box is a text box, dependent on the two combo boxes, and it must display the current % complete of that chapter, but then allow the author to update it from the form. The table should update automatically without the author having to see it at all.
Is this possible? I have inserted a much simplified version of my data page below. Looking forward to any and all replies,

Status.JPG

Thanks,

Plane Fixer

[Tinbendr]

but then allow the author to update it from the form. The table should update automatically without the author having to see it at all.

Not without a sample sheet, with sample data, with callouts showing expected results.