Checkmark and Value Automatically Appear in Cell

  • Thread starter Thread starter xlsmacronewbie
  • Start date Start date
X

xlsmacronewbie

I am trying to figure out how to create a macro that when the user
clicks on the checkbox, a numeric value automatically appears in a
cell. For example, I click
Checkbox 1 and the number 8 appears in CELL A1...I click on Checkbox 2
and the number 12 automatically appears in CELL A2...so on and so
forth. I am a beginner with excel programming, so any help would be
appreciated!!! :)

Thanks, Newbie
 
This my be to simplistic for your needs...but in the "change" event of the
checkbox try the following code (or somthing similar)

If CheckBox1.Value = True Then 'checks the state of the checkbox
Range("A1").FormulaR1C1 = 8
Else
Range("A1").FormulaR1C1 = ""
End If
 
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

Beginner - Click a checkbox then calculation to be done automatically 1
Click a cell next to an item and have a checkmark appear 2
Can a checkbox be created with a logic function? 8
How can I click on a cell and enter a default value? 8
Execute a macro automatically when checkbox is clicked 3
Code to display a true or false value in the cell containing a check box 1
Excel Typed text appears in wrong cell 0
VB script 3

Back
Top