Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone tell me what is wrong with this code. I am getting an object required error. Thanks.
Sub TestStuff() Dim MBT As String Dim fc As OLEObject Dim t As Integer If ActiveSheet.Name = "TIME AND LEAVE" Then For Each fc In OLEObjects If TypeOf fc.Object Is MSForms.Checkbox Then t = CInt(Mid$(fc.Name, 9)) With ActiveSheet For t = 2 To 30 If ActiveSheet.Range("Cell" & t).Value < "" Then ActiveSheet.OLEObjects("CheckBox" & t).Visible = False Else ActiveSheet.OLEObjects("CheckBox" & t).Visible = True End If Next End With End If Next fc End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is wrong with this code? | Excel Discussion (Misc queries) | |||
What is wrong with this code? | Excel Discussion (Misc queries) | |||
What is wrong with the code? | Excel Discussion (Misc queries) | |||
What's wrong with my code ? | Excel Worksheet Functions | |||
Is something wrong with the code | Excel Programming |