Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Don Sims   on Aug 15 In MS Office Category.

  
Question Answered By: Marshall Bryant   on Aug 15

The buttons  and boxes  are directly on the sheet. I don't know the
difference between active x control and form tools. But I think that
they are form tools. They do output values to cells. If you want I
can send you an example of what I am talking about.

I have copied below an example of some of the code behind couple of
the buttons and check  boxes

Private Sub OptionButton3_Click()
Range("R2").Value = 1
End Sub

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
ActiveSheet.Range("ab42").Value = 1

Else
ActiveSheet.Range("ab42").Value = 0
End If
End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Excel Macros Or get search suggestion and latest updates.


Tagged: