How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?

[Ayugma]

I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as many parts as they want. All the parts have part numbers in another worksheet.

For example, if three are selected, I want a combobox to list the part numbers of those three parts. I'm not sure how to implement this in VBA and some guidance would be greatly appreciated. Thanks!

 

[Ayugma]

Thank you! I checked the code, and made sure everything was correct, and I get this error:
Run-time error '1004':

Application-defined or object-defined error

I'm not really sure what that means or what I should be fixing.

Additionally, you also asked me to modify searchString = CheckBox1.Caption. What should I modify with what?

 

[Ayugma]

Furthermore, I looked at the Range and saw that you included B39-B45. However I'm not sure if that scans column A for the Capstions, so I did Range("A38:B45"). If I keep B39-B45 like you have done, it'll tell me that the string is not found.

 

[Ayugma]

Edit: double messages sent, sorry

 

[My Aswer Is This]

Thank you! I checked the code, and made sure everything was correct, and I get this error:
Run-time error '1004':

Application-defined or object-defined error

I'm not really sure what that means or what I should be fixing.

Additionally, you also asked me to modify searchString = CheckBox1.Caption. What should I modify with what?

Well you have I believe 5 checkboxes.

Furthermore, I looked at the Range and saw that you included B39-B45. However I'm not sure if that scans column A for the Capstions, so I did Range("A38:B45"). If I keep B39-B45 like you have done, it'll tell me that the string is not found.

Well I believe you have 5 checkboxes.

So you will have checkbox1 and checkbox2 and so on.

So the script will be looking for Checkbox1. caption and checkbox2 caption so on the other scripts change CheckBox1 Caption to CheckBox2 Caption and so on.

If you do not understand just use the scripts I provide and it will work on the First two check boxes.

And my script is written correctly for the range B45 and on
The script then looks to column A for the part name

 

[My Aswer Is This]

Furthermore, I looked at the Range and saw that you included B39-B45. However I'm not sure if that scans column A for the Capstions, so I did Range("A38:B45"). If I keep B39-B45 like you have done, it'll tell me that the string is not found.

The way I wrote it is correct.

 

[Ayugma]

Okay, I changed it back to what you originally had and it gave me this issue:

When the checkbox one is available in my original sheet:

So I'm not sure what's causing the issue.

Edit: Could it be because I am using ActiveX instead of UserForm?

 

[My Aswer Is This]

You told me the Textbox will have a Part number you want to search for in sheet named:
"Table of Part Numbers" Range("B39:B45")
and then add the Part name found in column A same row to the combobox

from your image it appears you have partname as Chekbox1 caption

 

[My Aswer Is This]

From your image you are showing part names in the checkboxes not part numbers.

 

[Ayugma]

Sorry yes, I don't think I explained it correctly. My bad.

I shouldve had images from the start. How I have it is what I would like.

 

[My Aswer Is This]

I went back and read your original post again and after seeing your image I did the script incorrectly.
I thought we were searching for part numbers.
I will Rewrite script