Checkbox problems 2

Hello everyone!

Please, help me with my Checkbox.

I can't change the column width by checkbox.

Code

Please Login or Register  to view this content.

It doesn't show any error and doesn't change the width

Also I tryed the alternative way. I bound CheckBox with the cell (Range("B4")) and added macros for Worksheet_Change.

Please Login or Register  to view this content.

But it doesn't react to this changes

Originally Posted by Norie

Did you try using the linked cell in the Click event?

Sorry, i don't really know how to do that. Like this?

Please Login or Register  to view this content.

Originally Posted by Norie

Use the code you have in the Change event to check B4.

I think it doesn't perceive this as a change. Becouse it's automatic changes.

P.S. I' a vba beginner, so I don't really underrtand much

Yes. Meyybe the reason is that I've got excel on russian lang and procedures have names on russian too


This construstion doesn't work:

Please Login or Register  to view this content.

What is the parent object name of "checkbox"

I don't think that's the problem, VBA is usually (always?) in American English.

This is what I'm suggesting.

Please Login or Register  to view this content.

If that doesn't work can you attach the workbook?

Working perfectly. Thanks a lot!

Yes, I believed that VBA always in english.. But I tryed so meny configurations today so I started to mistrust. When I Record macros it's always on russian lang