• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent List cell clearance

Janine

New Member
Hi, I'm really struggling with a dependent list. There is a drop down box on one worksheet and another worksheet has a list that is dependent on the selection of the 1st drop down.

I need it to clear itself each time the1st drop down is changed.

Please help me !

Many thanks

Janine
 
Hi Janine ,

I think help is possible only if you upload your workbook , with the dropdown and the dependent list.

Also , you need to confirm whether VBA is acceptable , in case what you want done is not possible without VBA.

Narayan
 
OK.

Please find attached. The first list is on the first tab, business unit, the second is on the second tab, vendor / technology
 

Attachments

  • PS Quoting Tool Upload.xlsm
    135.1 KB · Views: 0
Hi ,

Your sheets have been protected , so I really do not know information about each of the elements.

Secondly , I keep getting an error :

Cannot create TextBox26 ...

This is an error because of ActiveX problems , and it would be nice if you could first eliminate this error , unprotect the tabs and then upload the file.

Otherwise , I hope someone else steps in to help.

Narayan
 
this better?
 

Attachments

  • PS Quoting Tool Upload.xlsm
    135.1 KB · Views: 0
  • PS Quoting Tool Upload.xlsm
    135.1 KB · Views: 0
Back
Top