I'm a rookie at this Visual Basic stuff and am trying to create a simple
macro that when checking/unchecking a check box, it unhides/hides a range of
rows.

If I record the macro the easy way, then assign it to a checkbox, unchecking
will hide the rows as expected. But when I go into VB to give have it unhide
the rows when checking the box, I have problems. Here is the code I'm trying
to use:

Sub Macro1()
'
' Macro1 Macro
'

'

Rows("10:32").Select
If CheckBox1.Checked = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If

End Sub


The error I get in the debugger is "Object Required" and the "If
CheckBox1.Checked = False Then" is highlited.

From what I understand, when I go to Properties in the developer tab, I
should get a Properties box. But I only get a Format Control box.

Also, I'm told that when I insert a check box, I should get an option for
that check box in the dropdown in VB... I only get (General) or Worksheet.

Thanks for your help.

You have the wrong type of check box. There are 2 possible chackboxes that
you can insert. The one form the forms toolbar is the one that you have. You
want the one from the Control Toolbox. Grab one of those and all should be
well in your world...
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm a rookie at this Visual Basic stuff and am trying to create a simple
macro that when checking/unchecking a check box, it unhides/hides a range of
rows.

If I record the macro the easy way, then assign it to a checkbox, unchecking
will hide the rows as expected. But when I go into VB to give have it unhide
the rows when checking the box, I have problems. Here is the code I'm trying
to use:

Sub Macro1()
'
' Macro1 Macro
'

'

Rows("10:32").Select
If CheckBox1.Checked = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If

End Sub


The error I get in the debugger is "Object Required" and the "If
CheckBox1.Checked = False Then" is highlited.

From what I understand, when I go to Properties in the developer tab, I
should get a Properties box. But I only get a Format Control box.

Also, I'm told that when I insert a check box, I should get an option for
that check box in the dropdown in VB... I only get (General) or Worksheet.

Thanks for your help.

I'm not quite sure what you mean by the Control Toolbox. The only options I
see to get the checkbox from is Form Controls or Active X Controls. Could
you please be more specific where I can find the Control Toolbox?

Thanks for your help.

"Jim Thomlinson" wrote:

You have the wrong type of check box. There are 2 possible chackboxes that
you can insert. The one form the forms toolbar is the one that you have. You
want the one from the Control Toolbox. Grab one of those and all should be
well in your world...
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm a rookie at this Visual Basic stuff and am trying to create a simple
macro that when checking/unchecking a check box, it unhides/hides a range of
rows.

If I record the macro the easy way, then assign it to a checkbox, unchecking
will hide the rows as expected. But when I go into VB to give have it unhide
the rows when checking the box, I have problems. Here is the code I'm trying
to use:

Sub Macro1()
'
' Macro1 Macro
'

'

Rows("10:32").Select
If CheckBox1.Checked = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If

End Sub


The error I get in the debugger is "Object Required" and the "If
CheckBox1.Checked = False Then" is highlited.

From what I understand, when I go to Properties in the developer tab, I
should get a Properties box. But I only get a Format Control box.

Also, I'm told that when I insert a check box, I should get an option for
that check box in the dropdown in VB... I only get (General) or Worksheet.

Thanks for your help.

The Control Toolbox is a menu. Select Tools - Customize - Toolbars tab and
check off Control Toolbox. As a guess you already have the forms toolbar
selected.
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm not quite sure what you mean by the Control Toolbox. The only options I
see to get the checkbox from is Form Controls or Active X Controls. Could
you please be more specific where I can find the Control Toolbox?

Thanks for your help.

"Jim Thomlinson" wrote:

You have the wrong type of check box. There are 2 possible chackboxes that
you can insert. The one form the forms toolbar is the one that you have. You
want the one from the Control Toolbox. Grab one of those and all should be
well in your world...
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm a rookie at this Visual Basic stuff and am trying to create a simple
macro that when checking/unchecking a check box, it unhides/hides a range of
rows.

If I record the macro the easy way, then assign it to a checkbox, unchecking
will hide the rows as expected. But when I go into VB to give have it unhide
the rows when checking the box, I have problems. Here is the code I'm trying
to use:

Sub Macro1()
'
' Macro1 Macro
'

'

Rows("10:32").Select
If CheckBox1.Checked = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If

End Sub


The error I get in the debugger is "Object Required" and the "If
CheckBox1.Checked = False Then" is highlited.

From what I understand, when I go to Properties in the developer tab, I
should get a Properties box. But I only get a Format Control box.

Also, I'm told that when I insert a check box, I should get an option for
that check box in the dropdown in VB... I only get (General) or Worksheet.

Thanks for your help.

Jim,

I'm partially involved in this project with KThompson20. I know that he's
using Office Excel 2007. There isn't a menu option for Tools - Customize -
Toolbars tab as Office '07 has gone away from toolbars completely and are now
using the Office ribbon. Would you know where we need to go to use the
proper checkbox control in Excel '07? This would explain why he only has the
choice between a forms control checkbox or an activex control checkbox.
However; we've attempted to use both types of checkboxes and neither of them
have been working for us.

Thanks,

Jonathan

"Jim Thomlinson" wrote:

The Control Toolbox is a menu. Select Tools - Customize - Toolbars tab and
check off Control Toolbox. As a guess you already have the forms toolbar
selected.
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm not quite sure what you mean by the Control Toolbox. The only options I
see to get the checkbox from is Form Controls or Active X Controls. Could
you please be more specific where I can find the Control Toolbox?

Thanks for your help.

"Jim Thomlinson" wrote:

You have the wrong type of check box. There are 2 possible chackboxes that
you can insert. The one form the forms toolbar is the one that you have. You
want the one from the Control Toolbox. Grab one of those and all should be
well in your world...
--
HTH...

Jim Thomlinson


"kthompson20" wrote:

I'm a rookie at this Visual Basic stuff and am trying to create a simple
macro that when checking/unchecking a check box, it unhides/hides a range of
rows.

If I record the macro the easy way, then assign it to a checkbox, unchecking
will hide the rows as expected. But when I go into VB to give have it unhide
the rows when checking the box, I have problems. Here is the code I'm trying
to use:

Sub Macro1()
'
' Macro1 Macro
'

'

Rows("10:32").Select
If CheckBox1.Checked = False Then
Selection.EntireRow.Hidden = True
Else
Selection.EntireRow.Hidden = False
End If

End Sub


The error I get in the debugger is "Object Required" and the "If
CheckBox1.Checked = False Then" is highlited.

From what I understand, when I go to Properties in the developer tab, I
should get a Properties box. But I only get a Format Control box.

Also, I'm told that when I insert a check box, I should get an option for
that check box in the dropdown in VB... I only get (General) or Worksheet.

Thanks for your help.