Checkbox problem

dragavs

New Member
Joined
Jun 23, 2014
Messages
9
my problem is checkboxes didnt tick,
Code:
'checkbox for slipsheets    Dim checkboxes As CheckBox    If Range("EU5").Value = "PALETIZED" Then        checkboxes("Check Box 36").Value = xlOn        Else        checkboxes("Check Box 36").Value = xlOff    End If    If Range("EU5").Value = "LOOSE-LOADED" Then        checkboxes("Check Box 71").Value = xlOn        Else        checkboxes("Check Box 71").Value = xlOff    End If    If Range("EU5").Value = "UNITIZED" Then        checkboxes("Check Box 72").Value = xlOn        Else        checkboxes("Check Box 72").Value = xlOff    End If    If Range("EU5").Value = "PLASTIC SLIPSHEETS" Then        checkboxes("Check Box 73").Value = xlOn        checkboxes("Check Box 37").Value = xlOn        Else        checkboxes("Check Box 73").Value = xlOff        checkboxes("Check Box 37").Value = xlOff    End If    If Range("EU5").Value = "FIBER SLIPSHEETS" Then        checkboxes("Check Box 73").Value = xlOn        checkboxes("Check Box 37").Value = xlOn        Else        checkboxes("Check Box 73").Value = xlOff        checkboxes("Check Box 37").Value = xlOff    End If        'next    Range("eu6").Select    Application.CutCopyMode = False    Selection.Copy    Range("eu5").Select    activesheet.Paste    Range("eu6").Select    Selection.Delete Shift:=xlUp
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
cant edit the post, my code is like this'checkbox for slipsheets Dim checkboxes As CheckBox If Range("EU5").Value = "PALETIZED" Then checkboxes("Check Box 36").Value = xlOn Else checkboxes("Check Box 36").Value = xlOff End If If Range("EU5").Value = "LOOSE-LOADED" Then checkboxes("Check Box 71").Value = xlOn Else checkboxes("Check Box 71").Value = xlOff End If If Range("EU5").Value = "UNITIZED" Then checkboxes("Check Box 72").Value = xlOn Else checkboxes("Check Box 72").Value = xlOff End If If Range("EU5").Value = "PLASTIC SLIPSHEETS" Then checkboxes("Check Box 73").Value = xlOn checkboxes("Check Box 37").Value = xlOn Else checkboxes("Check Box 73").Value = xlOff checkboxes("Check Box 37").Value = xlOff End If If Range("EU5").Value = "FIBER SLIPSHEETS" Then checkboxes("Check Box 73").Value = xlOn checkboxes("Check Box 37").Value = xlOn Else checkboxes("Check Box 73").Value = xlOff checkboxes("Check Box 37").Value = xlOff End If 'next Range("eu6").Select Application.CutCopyMode = False Selection.Copy Range("eu5").Select activesheet.Paste Range("eu6").Select Selection.Delete Shift:=xlUp
 
Upvote 0

Forum statistics

Threads
1,215,056
Messages
6,122,907
Members
449,096
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top