Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Applying a change based on a CheckBox
Currently I use the following code to populate a cell on my worksheet from a
TextBox on a DialogBox: Private Sub CommandButton1_Click() Dim rng Set rng = Cells(ActiveCell.Row, 1) rng(1, 1).Value = TextBox3.Text End Sub Also on that DialogBox is a CheckBox. What I would like to have happen is, if the CheckBox is selected (checked) then an X would be placed in cell 3 of the current row "rng(1, 3)". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Applying a change based on a CheckBox
Patrick,
Before the End Sub line: If Checkbox1.Value = True then rng(1,3).value = "X" Henry "Patrick Simonds" wrote in message ... Currently I use the following code to populate a cell on my worksheet from a TextBox on a DialogBox: Private Sub CommandButton1_Click() Dim rng Set rng = Cells(ActiveCell.Row, 1) rng(1, 1).Value = TextBox3.Text End Sub Also on that DialogBox is a CheckBox. What I would like to have happen is, if the CheckBox is selected (checked) then an X would be placed in cell 3 of the current row "rng(1, 3)". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying change to selected cells | Excel Worksheet Functions | |||
When applying a theme to an Excel workbook and it will not change | Excel Worksheet Functions | |||
Conditional Formatting - Applying Format Based Custom Functions | Excel Discussion (Misc queries) | |||
Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
Applying a currency rate that doesn't change when source updated | Excel Worksheet Functions |