From CheckBox to Cell

  • Thread starter Thread starter =?iso-8859-1?B?UmVu6Q==?=
  • Start date Start date
?

=?iso-8859-1?B?UmVu6Q==?=

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é
 
Change Textbox1 with a range reference such as Range("B9")

--
Regards,
Tom Ogilvy

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é
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy filtered data to sheet 2 1
TextBox Change/Exit problem 3
How to add days in date by macro 4
Arbitrary data to Textboxes in UserForm 4
Pasted text will not spell check 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Activate Sheet switching 3
Can I Have Beter Code For Search Than This 1

Back
Top