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

ComboBox to pick values

rrocker1405

rrocker1405

Member
Hi,


Probably this would be very simple but I'm not sure how to populate this one. There are two combobox in a sheet. The first combobox has a dropdown of named cells and the second combobox should list those named cells based on the user input in the first combobox. Not sure how to do this.

I used to do with indirect formula using data validation but the list is growing so typing the first 3 characters in the combobox will help. Any suggestions?


Thanks in advance
 
Hi rrocker1405,


Did you happen to find these below links?


http://www.contextures.com/xlDataVal02.html

http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/


Kaushik
 
Hi, rrocker1405!

Maybe this helps too:

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list

Just advise if any issue.

Regards!
 
Dear Kaushik and SirJB7,


Thank you for the links. What I'm trying to do is a little different. Since the list data is huge I want to give an option to users to type first characters to choose from the list and for this I want to use Combo Box. I was successful using a named range which I had filled in listfillrange (properties of Combo Box).


But I want to make it more easier for the users by providing an option to choose from ID or From name. for this instance, I have two combo box in the sheet.


combo Box # 1. user indicates if selection is based on id or name. (this can be using validation also if not through combo box)


combo box # 2. If the user selects ID, the user should be able to see the list of ID's and when typed the first characters the user should be able to click and select the id. The same should also be applicable to Names.


Thanks in advance.

Wish you a good day!

Regards.
 
Hi ,


When there are only two options , such as selection being based on either the ID or the Name , the correct choice would be an option button , also called a radio button.


By default one can be selected , and whenever the user selects the other option , the earlier selected option is automatically deselected.


Narayan
 
Dear Narayan,


Thank you for the suggestion of radio button for the first option of the user to select. however, my question is actually for the second one where the listfillrange option should pick the named range of cells information which isnt populating.


Thanks in advance.

Regards.
 
Hi ,


Is it possible for you to upload your file ?


It is too much trouble to create the objects , and the data , and then write and test the code !


If you have at least a part of this done , it would make it easier for others to focus on solving your problem.


Narayan
 
Dear Narayan,


This is the test file as requested.


https://www.dropbox.com/s/bfqrgkulmbhs4un/Combo%20Box.xlsx


Please keep me posted if you were able to open the file from the above link, else let me know if there is any other way i can share the file.


Regards.
 
Hi ,


Thanks. I have downloaded your file ; give me some time to work on it. In case I am able to resolve your problem , I'll upload the file to SpeedyShare ( http://speedy.sh ). I hope this is OK with you.


Narayan
 
hey dear rrocker1405


Now will you check this following link please i think this is really very useful for you


http://www.2shared.com/document/t5kv-5jF/Combo_Box.html


Regards

CA Mahaveer Somani
 
@mahaveer


Hi


i did little bit change to your file that is you just forget about one line that is ID column


so i change that


@rrocker


Please download the below file


https://dl.dropbox.com/u/75654703/Combo%20Box.xls


Thanks


SP
 
hi SgmPatnaik


i know you are right but i did not forget about ID. Actually i think that mr rrocker1405 have no need for ID no. coz there is no ID no in their first combobox hence i did not work for id no.


by the way thanks dude.

Regards

CA Mahaveer Somani
 
@Mahaveer


Hi


yes you are correct Mr rrocker forget to add the ID IN the item range that's why it's not coming in the first combo and its displays only name and Cat.,


Thanks


SP
 
yes dear sgmpathnaik i know about it i already check it therefore i did not add it.....by the way thanks to guide us..


Regards

CA Mahaveer Somani
 
You must log in or register to reply here.
Back
Top