• 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

J

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
 
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
 
You must log in or register to reply here.
Back
Top