<div>
This will help:<br />
Private Sub CheckBox1_Click()<br />
&nbsp; &nbsp;Columns(1).Value = &quot;Abracadabra&quot;<br />
&nbsp; &nbsp;Application.ActiveCell.Sel<wbr />ect<br />
&nbsp; &nbsp;Columns(1).Hidden = True<br />
End Sub<br />
<br />
You must set the focus to the excel sheet back from<br />
the checkbox ..<br />

</div>


This will help:
Private Sub CheckBox1_Click()
   Columns(1).Value = "Abracadabra"
   Application.ActiveCell.Select
   Columns(1).Hidden = True
End Sub

You must set the focus to the excel sheet back from
the checkbox ..


<div>
You must reset the focus from the ActiveX &nbsp;Checkbox<br />
to the Excel Worksheet object. <br />
<br />
This is probably an old excel bug ...<br />
<br />
(This error irritates me really long)<br />
WoK
</div>


You must reset the focus from the ActiveX  Checkbox
to the Excel Worksheet object.

This is probably an old excel bug ...

(This error irritates me really long)
WoK

<div>
Thank you VERY much for your quick and comprehensive answer.<br />
Have a great day!<br />
Vladimir Nejedly
</div>


Thank you VERY much for your quick and comprehensive answer.
Have a great day!
Vladimir Nejedly

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have got a problem with use of Range.Hidden property:<br />
I put the ActiveX CheckBox on my sheet and assigned following procedure:<br />
<br />
Private Sub CheckBox1_Click()<br />
&nbsp; &nbsp; Columns(10).Value = &quot;Abracadabra&quot;<br />
&nbsp; &nbsp; Columns(10).Hidden = True &nbsp; &nbsp;<br />
End Sub<br />
<br />
The first line is OK (All fields in the Column No.10 are filled with &quot;Abracadabra&quot;) whereas the second one fail (Error 1004).<br />
<br />
Note that if I put these two lines for instance in Worksheet_Change event, everything is OK.<br />
<br />
Regards,<br />
Vladimir
</div>
</div>


Hello,
I have got a problem with use of Range.Hidden property:
I put the ActiveX CheckBox on my sheet and assigned following procedure:

Private Sub CheckBox1_Click()
    Columns(10).Value = "Abracadabra"
    Columns(10).Hidden = True    
End Sub

The first line is OK (All fields in the Column No.10 are filled with "Abracadabra") whereas the second one fail (Error 1004).

Note that if I put these two lines for instance in Worksheet_Change event, everything is OK.

Regards,
Vladimir

Excel - Range.Hidden property

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.