Ok. I want to have a Gantt chart scheduler on the excel worksheet as it is at the moment. But I want to control it from userform. Now I have 7 listboxes and 25 buttons on the worksheet. The big listbox is populated with the total list of products. Then I want to be able to move products to other listboxes where needed. And all movements I make within userform should update the worksheet in realtime.

Don't know if you had chance to look at the attached workbook. It is fully functional. I just don't want any objects on a excel worksheet. I want to call userform with those objects on and control excel worksheet from there.