Showing selected check box titles in cell

Replace all your code with this...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can't say...need an accurate representation of your actual file...

It is very important to always upload sample files that depict your exact set-up...
I see it happen all the time...Members wasting time on code because it does not fit the users actual file setup...

In my proper sheet what I am selecting are model numbers instead of text.

If you are referring to the CheckBox Captions being numbers then one can store them in an array to recall later on...

Originally Posted by Kevchenk0

In my proper sheet what I am selecting are model numbers instead of text.

in my example I have hat, tie and shoe as different checkboxes

A.
Do you mean that the checkboxes are not text, but number ?
Example :
checkbox1 caption : 10
checkbox2 caption : 5
checkbox3 caption : 3


OR

B.
Do you mean that checkboxes are text, but that text has model number ?
Example :
caption hat in checkbox1 model number is 10
caption tie in checkbox2 model number is 5
caption shoe in checkbox3 model number is 3

Is there any way to adjust the code and make the numbers always appear in sequence of lowest 1st to highest?

Either A or B, you want the result like this :
If the user click checkbox1 and click checkbox2
then you want the display result in cell L19 is : 5, 10

another example:
the user click checkbox1 and click checkbox3
then you want the display result in cell L19 is : 3, 10

another example:
the user click checkbox2 and click checkbox3
then you want the display result in cell L19 is : 3, 5

another example:
all three checkboxes are selected
then you want the display result in cell L19 is : 3, 5, 10

Anyway, below is the code for model-A: (the CheckBox caption is not a text but a number)

Please Login or Register  to view this content.

call the test sub just before the end sub of each Private Sub CheckBox_Click()