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é |
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é |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com