Cascading user form combo boxes?

Hi all.
I have a workbook that I'm using fpr courses booking, it has a combo boxes so that I can select manager name, area and delegate name and click command button which puts all information onto the list. Its ok but I would like to use the userform instead of spread sheet to capture data.
I tried to copy the code from worksheet to userform but somethig is causing an error. I would appreciate your help in this matter.
Thank you in advance.

Originally Posted by AndyLitch

Attachment 296138

Step 1
Instead of calling an event macro in the workbook_open sub - you run the macro by triggering the event.

Please Login or Register  to view this content.

Hi Andy
Thanks for your help however I wanted it on the userform rather than on the worksheet, yst data will be saved on a worksheet but it would be captured by userform. it works great on worksheet but it would be even better if I could have it on userform.
There's a userform in workbook that I would like to use.
Thank you again
Dan

Originally Posted by AndyLitch

Dan try this in the code module for sheet1

Please Login or Register  to view this content.

Hi Andy
I am getting the following error in my userform code:
error 1.jpg
Cheers for your help I really appreciate it :-)