Only Allow 1 Combo Box To Be Fill

[calvinle]

Hi,

I wonder if there is any way to only allow 1 combo box to be fill?
I have 5 combo box,:
cmbRef, cmbName, cmbId, cmbProfession, cmbSalary and a command button as object in worksheet.

By pressing the command button, if only 1 combo box is filled, it will messagebox "Good". If more than 1 is filled, it will messsage box "Only 1 allowed".

Thanks.

[jaslake]

Hi calvinle

Perhaps something like this (untested)

Please Login or Register  to view this content.

[calvinle]

This code works on Userform, but my combo box are not on userform. They are on the Worksheet itself.

Thanks.

[jaslake]

Hi calvinle

This code works on Userform, but my combo box are not on userform. They are on the Worksheet itself.

Well...please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and, if appropriate, an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

[calvinle]

Hi,

Thanks for helping.

THere you go:

Single ComboBox.xlsm

[jaslake]

Hi calvinle

I've admired Chandoo's work. Attach yours...

[calvinle]

Hi,

I am using their just to test out the code. That is why I left their name for their credit. Their sample file uses mysql to build the database which i don't need as I want to learn the way to solve my question of this topic. Also, as for Chandoo, they allow us to use their sample and mod it to fit our requirement as long we give them their credit, in which I did.
I am using theirs as for learning purpose only.

Let me know if you really need mine as I will need to remove all secure content on it.

Thanks.

[nilem]

maybe so

Please Login or Register  to view this content.

[calvinle]

Hi,
It's not working..

Thanks.

[jaslake]

Hi calvinle

I'm not criticizing you for using Chandoo. The Workbook you attached, I would guess, is not of the same structure as your Workbook. That's why I asked for this

attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

[calvinle]

Hi,

Here is the structure of my work: I remove all the data from it.

Database.xlsm


Thank you.

[jaslake]

Hi calvinle

You have 8 Combo Boxes in the Worksheet. Only two are named like this

cmbRef, cmbName, cmbId, cmbProfession, cmbSalary

ComboBoxes.jpg

And of course, other than the fact that the Combo Boxes are miss-identified, we can't test because there's no Data in the Workbook. So, what is it you'd like us to do?

[calvinle]

The cmb was an exemple. Since you asked me to provide the real example, then the cbo is te real name.
My request for only allow 1 cbo to have value by clicking on the button is for validation.
That code will stand at first of the cmdSearchData, then if that pass, it will continu with my Searching Code.

[jaslake]

Hi calvinle

Try this Code for the Search Button

Please Login or Register  to view this content.

[calvinle]

Greatly appreciated! Thank you very much!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.