RE: Check Box Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.
.

Relevant Pages

  • Re: Row Selector Column
    ... create clientside code on one of my custom columns. ... jumps into this function each time the control is rendered. ... I am trying to do the same thing for the CheckBox column using the following ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Row Selector Column
    ... I've just modified my former CheckBox Column example and added a Header ... CheckBox in it which will control All Check and All UnCheck through ... | create clientside code on one of my custom columns. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: How to modify label.text in a dynamically generated label in VB.net
    ... hybrid control that contains a checkbox and a label. ... That frees up the tag ... CheckBox control and the value was the Label control. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: check box to formfield checkbox
    ... If there is a match, then we know that the control is a CheckBox type ... the string in ffcheck would be Check1 ... I note that you say that the "formfield checkboxes that are located in a ...
    (microsoft.public.word.vba.userforms)
  • Re: CheckBoxList
    ... DataGrid is a good one for displayed multi-column and customized data. ... as for selecting, of course, it has buildin select feature let a user to ... template databound control which can only populate data through databinding ... Is this achievable using the checkbox list? ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)