VBA Checkbox code complement

[Challebjoern]

Hey guys.

I got this code which works perfect. When I type in a specific word it automaticly checks the checkbox with that name. But I would want to add a thing to this code, if the box that is autochecked is ticked, I want the code to check another code named the same thing.

Like if Zon 1 is checked, also check words ending with Zon 1. etc ~

For ex. see picture.

Zon.jpg

Please Login or Register  to view this content.

[cytop]

Ignore - board lurgies.

[cytop]

You could try a simplistic change first:

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Obviously, I have no idea of the data you're working with and there is a chance it will check something you do not want checked - if that happens, the only solution is to process specific checkboxes rather than all...

[Challebjoern]

Tried to change that but didn't do anything different. I'll post my file so you can check.

TEST.xlsm

You could try a simplistic change first:

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Obviously, I have no idea of the data you're working with and there is a chance it will check something you do not want checked - if that happens, the only solution is to process specific checkboxes rather than all...

[cytop]

The problem with answering questions on forums - a lot of assumptions are made.

In your original thread, you did not mention all the other checkboxes, so I assumed there were none - the code, as written, is useless for what you want to do as it will blank all non matching checkboxes.

Not the end of the world as the basic code can be re-written, but you need to explain the logic of what gets checked (meaning a CheckBox getting 'selected'), where and when; which checkboxes this should apply to and any other information you might think relevant.

You know the logic, no one else does so you need to explain clearly.

[Challebjoern]

My bad Cytop. Guess I gotta be more clear to what I need help with. I'll be more specific in the future. Since I'm so "new" to all this VBA and stuff it all seem so simple to you experienced guys

The problem with answering questions on forums - a lot of assumptions are made.

In your original thread, you did not mention all the other checkboxes, so I assumed there were none - the code, as written, is useless for what you want to do as it will blank all non matching checkboxes.

Not the end of the world as the basic code can be re-written, but you need to explain the logic of what gets checked (meaning a CheckBox getting 'selected'), where and when; which checkboxes this should apply to and any other information you might think relevant.

You know the logic, no one else does so you need to explain clearly.

[cytop]

Can we assume you only want this to work for Checkboxes in Cols B & F that contain Zon1 - 8 in the cation?

[Challebjoern]

That is correct, what this does is that when I type in a "TOWN - Cell: I19" in the cell next to "Ort - Cell:H19" it takes information from the list in sheet 3. and from the Zone cell it determine what zone it is to the checkbox. And as you wrote they work abit together, Cols B & F, just different prices (there are temporary prices in there for now). I could have changed the true/false settings to if Cols B is True so will Cols F will be, but I still want to be able to choose either of them seperatly by manually clicking the boxes.

Can we assume you only want this to work for Checkboxes in Cols B & F that contain Zon1 - 8 in the cation?

[cytop]

Try this then.

Please Login or Register  to view this content.

But I can't help feeling that Option Buttons (Which only allow 1 selection in a group) would have been a better choice for this.

[Challebjoern]

That worked like a charm Cytop! Thanks alot.

According to option button. Do you mean that I should replace the checkboxes with option buttons instead? I'm gladly taking tips how to improve and get better in excel, so if they work differently I'll gladly exchange them to option buttons.

Try this then.

Please Login or Register  to view this content.

But I can't help feeling that Option Buttons (Which only allow 1 selection in a group) would have been a better choice for this.

[cytop]

Some of them, Probably.

Option buttons will only allow 1 option in a group to be selected - on your worksheet, I'd assume you can only have 1 selection for Zon 1 - 8 so option buttons would be the logical choice there - but that means changes to that code .

Probably best to just keep it in mind for the next time - it'd be a pain to replace the checkboxes now.