Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Control vs. Active X Controls
I'm using Excel 2007 and want to put a check box above a range of cells that
I want to assign two macros, one for checked, one for unchecked. I struggled for hours to get it working until I discovered I was using a Form Control Check Box, not an Active X Control Check Box. Using an Active X check box (Developer ribbon, controls, insert active x check box) and the following code I can made it work: Private Sub CheckBox1_Click() If CheckBox1.Value = False Then Hide_Loan_Details Else Show_Loan_Details End If End Sub However I do prefer the Form Control Check box as it looks better, can be filled with colours, etc. I've tried the following code and cannot make it work: Private Sub LoanDetailCheckbox_Change() If LoanDetailCheckbox.Value = xlOn Then Show_Loan_Details Else Hide_Loan_Details End If End Sub Is it possible to use the Form Control Check box in my worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active X Controls Tabbing from Form Field 2 Form Field | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
View Control of Form Controls | Excel Programming | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming |