combobox - count if

[Lukael]

Hello,

I have Userform where I have checkboxes. So far I had VBA code to tick checkboxes If there was countIf=2...I want to change that to tick checkboxes If whole string (text) from one cell is selected, and only a string from another is selected. Example in column E :

If E3 is "MIN1", and E4 is "07:00-19:00" - checkbox ticked !... but I want string "07:00-19:00" to be selected If string begins Like "0*" !

my code so far :

Please Login or Register  to view this content.

I Have attached sample worksheet, but I don't know why isn't working, I copied from mine. Can't upload mine worksheet, It's size is over this forum regulation (1.2 Mb).