| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using checkbox to calculate another cell
I have the following code in a macro for a checkbox and it gives a error of
object required any suggestions? Private Sub CheckBox19_Click() If CheckBox19.Value = True Then Range("I24").Select ActiveCell.FormulaR1C1 = "=0.07*R[-1]C" Else: Range("I24").Select Selection.Value = 0 End If End Sub -- John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using checkbox to calculate another cell
Assue you use control Check box with cell link of "J7", try
Sub CheckBox19_Click() If Range("j7").Value = True Then Range("I24").Select ActiveCell.FormulaR1C1 = "=0.07*R[-1]C" Else Range("I24").Select Selection.Value = 0 End If End Sub George |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using checkbox to calculate another cell
I can try but what is j7 I had tried the control box
-- John "George" wrote: Assue you use control Check box with cell link of "J7", try Sub CheckBox19_Click() If Range("j7").Value = True Then Range("I24").Select ActiveCell.FormulaR1C1 = "=0.07*R[-1]C" Else Range("I24").Select Selection.Value = 0 End If End Sub George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ASSIGN VALUE TO CHECKBOX AND CALCULATE AVERAGE? | New Users to Excel | |||
| I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. | Excel Discussion (Misc queries) | |||
| link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
| can I use checkbox thus I could calculate the value in a sheet | Excel Programming | |||
| checkbox on form reset from checkbox on sheet | Excel Programming | |||
Linear Mode
