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

Combo Box

Joeman187

Member
Hi Chandoo People,


I am still having a problem in my combo box. I have a list of names in column b and would like the prefix to those names as Mr. Mrs. and Ms. in column a. I used Active for the combo box so i can check the properties easier. To my problem it is only linked to one cell, the linked cell. How can I get the combo items to be linked to the other rows? Joe from Michigan. P.S. One last time then I will do it in data validation as a list. Thanks for your help as always.
 
@ Joeman


Hi


firstly i would like to remain about the Forum 4 Green Sticky key rules

please don't post the same question twice and twice already you post the same question in the given link please check


http://chandoo.org/forums/topic/combo-boxes-2


about your question


you want to add the combo box just follow the instructions below


1. Insert the Combo Box


2. Right Click on the Combo Box


3. Select Format Control


4. Select the input the Range and give your Mr/Mrs & Ms Range


5. Finally Select Ok


Hope it will solve otherwise try upload a sample work book


Thanks


SP
 
Back
Top