Hi again,
I've got a "Clients" sheet, where I have client data. Sometimes I just need to printout the phone numbers, or just the addresses etc.
So I made this user form where I have check boxes to choose.
For example :
If the check box 1 is selected, the range to print will be : Range("A8:A100")
If the check box 2 is selected, the range to print will be : Range("K8:K100")
if the check box 1 is selected with check box 2 , then ranges will be Range("A8:A100, K8:K100)
and so on
I wrote this so far :
But I can not figure out how to deal with the IF conditions.
If checkbox1.value = true then..... what ?
thank you in advance!
Bookmarks