Userform - checkbox

[Lukael]

Hello,

I have userfom and I need to tick checkboxes If two cell values in range have string values. I have monthly work schedule for shifts, and checkboxes must be ticked If job is entered.

So, If in E3 is "OP1", and in E4 is "06:18:00", than I want in Userform to be ticked "OP1- daily shift" checkbox.

Problem is that I have this for each days in month, in a range from row 3 to 318, for both cells (E3 and E4) in step 4. Right now I'm struggling with Select case statements, but nothing works

Have tried also to select cells and then perform If statements, but still nothing. Did I even select cells correct ? something like this :

Please Login or Register  to view this content.

I have attached Userform, you'll see what I have and what do I need to be changed. Previous checkboxes can be deleted, don't need them anymore. Thanks for any help !!!

Regards

[Sc0tt1e]

Try something like

If sheets("Januar 2013).range("E4").value = "OP1" and activecell.offset(0, 1).value = "06:18:00") then
Userform1.checkbox1 = true

[Lukael]

I'm sorry, that' not what I need. Please check attached worksheet, you'll see that I need to tick for each month in each day, and in range of rows 3:318 for two cell together (E3 & E4, E7 & E8 etc.. - and that's for column E only).

Your code would work, but I would need to write like three pages of code...

[6StringJazzer]

Question has been reposted to Commercial Services. This thread is now closed.