• 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.

Validation List Combined Columns

Z

zer0flag

New Member
Hi all,

I found a sheet with validation list which I never see before.
The sheet is protected, so I couldn't see the formula, code, etc.

Can you tell me how to make the validation list like this?SelectList.gif

Thanks in advance.
 
Hi Zeroflag,
I have attached a file for you its a sample base on how to do it, What you need to to do is go in Developers Tab, Select a combo box from ActiveX Control. Once you place Combo Box in desired cell in my case it was A1, but i spread the Combo Box till Cell C1 or D1 to give it extra view (I am not good with formatting), Once placed than right click on combo box and select properties, Set ColumnCount to 3, Set link Cell to A1 and set list fill range to J1:L4, now on developers tab click on design mode to disable it. From this point you should be able to view your options, Cell B1 and C1 can be based on formulas like if, now copy and paste the combo box to your desired list with a macro. I encourage you to look for formatting tools but this should lead you into direction what you are after. Data Validation is only for single column remember!, I hope this helps!
 

Attachments

  • Chandoo.xlsx
    13.6 KB · Views: 8
Hello sir,
Your explanation is clear and simple to applied. I was thought the ALL THREE columns was coded by macro to show the result, but your trick it can be done by simple lookup formulae. Thanks a lot. :)

#Problem_Solved
 
You must log in or register to reply here.
Back
Top