| 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 |
| 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 | |||
Threaded Mode
