Thread: Check Box Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Check Box Help

if they are from the control toolbox toolbar

for each obj in Activesheet.OleObjects
if typeof obj.Object is MSforms.CheckBox then
obj.Object.Value = False
end if
Next

if from the forms toolbar

for each chk in Activesheet.Checkboxes
chk.Value = xloff
Next

--
Regards,
Tom Ogilvy

"Pete" wrote in message
...
Is it possible through code to uncheck "Check boxes". In
my code below I ask the User to uncheck the boxes that are
checked befor using again. But I would Like this to be
automatic. Is it Possible?

Range("Die1:Die5").Select
Selection.Copy
Range("NumSet").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Range("Die1:Die5").Select
Selection.ClearContents
Range("E6").Select
MsgBox prompt:="Make sure to Clear check boxes!."
End Sub

Thanks for any help.
Pete W