LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default OnChange event attached to tick box

Hi Norman
I send you an email as I have the same problem as Jowashy. I tried your code
but it didn't work. Is there any other way to solve this problem

thanks
Britney

"Norman Jones" wrote:

Hi Jowashy.

Try:

'=========
Private Sub CheckBox1_Click()
With Me
.CheckBox2.Visible = _
.CheckBox1.Value = True
End With
End Sub
'<<=========


This is event code and should be pasted
into the worksheets's code module (not a
standard module and not the workbook's
ThisWorkbook module):

Right-click the worksheet's tab |
Select 'View Code' from the menu
Paste the code
Alt-F11 to return to Excel.


---
Regards.
Norman



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
monitor a specified range ( OnChange) [email protected] Excel Programming 2 August 17th 07 01:05 PM
Populating cells based on a combobox OnChange Event [email protected] Excel Programming 1 April 25th 07 03:32 AM
Workshet onchange Mark Excel Programming 2 August 25th 04 09:12 AM
OnChange Event for a Cell Michael Kintner Excel Programming 3 January 5th 04 08:29 PM
Worksheet event for tick box David Berry[_2_] Excel Programming 1 October 6th 03 11:19 AM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"