USER FORM - help needed

**mjancic** · 03-01-2010, 04:19 AM

Hello,

I need help with my user form. Need to update some field in it but unfortunately don't know how to do it. I must tell you I'm not good in writing scripts in VBA and I haven't created this user form.

Please look at the attachment, I need following to be added in it:

1. When I pick up Sales Territory I want to have in drop down list account names ( now it is in text box named "ACCOUNT NAME:"
2. Following previous step, when I choose "ACCOUNT NAME:" I want to have all values returned into other fields of user form.
3. Add one command button to user form to create a report based on sales territory selection. For example if I select "DAL" Territory I want to have a report of all data related to this territory. In can be in another excel or it can be in PDF or another file, the point is to have a report of certain territory.
4. And the last one, I want to have user form opened when I open excel, and when click command button "EXIT/CANCEL" I want to quit excel and save changes.

I know this is a bit complicated, but I hope that somebody can help me with it.

Thanks in advance.

Cheers,
Milan

**excelxx** · 03-01-2010, 06:05 AM

Hi mjancic

I have added the new combo box for the account name based on the user selection of department.

Also added the code for the workbook open event and the closing of the workbook once the user clicks on the exit button.

**mjancic** · 03-01-2010, 06:47 AM

Hi,

Thanks for your help.

Just one more thing, there is no combo box based on "ACCOUNT NAME:", you have added cbobox on "ACCOUNT NUMBER:" if not problem to you can you add cbobox to "ACCOUNT NAME" and then this can be the trigger for searching other values

A big thanks to you.

Cheers,
Milan