| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From CheckBox to Cell
Hi!
I need to put into a cell on a different sheet the information contain within a checkbox. Right now I have the information going to a TextBox, but we need to change that and put it in a cell instead. Here is part of my code: Private Sub CheckBox1_Click() If a1 = 0 Then Sheet2.TextBox1.Value = "" Sheet2.TextBox1.Value = "Can sustain a simple question and answer exchange" a1 = 1 Else Sheet2.TextBox1.Value = "" Sheet2.TextBox1.Value = "Not Applicable" a1 = 0 End If End Sub Thanks in advance for your help. It is greatly appreciated. Cheers René |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
From CheckBox to Cell
Change Textbox1 with a range reference such as Range("B9")
-- Regards, Tom Ogilvy "René" wrote in message ... Hi! I need to put into a cell on a different sheet the information contain within a checkbox. Right now I have the information going to a TextBox, but we need to change that and put it in a cell instead. Here is part of my code: Private Sub CheckBox1_Click() If a1 = 0 Then Sheet2.TextBox1.Value = "" Sheet2.TextBox1.Value = "Can sustain a simple question and answer exchange" a1 = 1 Else Sheet2.TextBox1.Value = "" Sheet2.TextBox1.Value = "Not Applicable" a1 = 0 End If End Sub Thanks in advance for your help. It is greatly appreciated. Cheers René |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| how do i change the value of a cell with a checkbox | Excel Worksheet Functions | |||
| CheckBox in a cell? | Excel Worksheet Functions | |||
| Compare checkbox with cell value | Excel Programming | |||
Linear Mode
