Macro to Display String on Checkbox Select

Question

I have a checkbox on sheet1 (there are about 7 sheets total). If the checkbox is selected (true), I want it to say "Approved" in cell M9. If the checkbox is not selected (false), I want it to say "Denied" in the textbox.

Do I need to create a macro for that?

If I want it to display the same text in cell M5 of sheet2, how would I put it all together?

Fionnuala · Accepted Answer · 2010-06-09 22:02:08Z

2

You can link the status of a checkbox to a cell (right-click, format control, cell link on the control tab), this means you can then refer to that cell in any other sheet or cell.

answered Jun 9, 2010 at 22:02

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Daniel Over a year ago

Thanks, but I have no clue what type of code I would need for that. Any suggestions?

Fionnuala Over a year ago

There is no code, just formulas: =If(a9, "a9 is true","Denied") Where are you having problems?

Daniel Over a year ago

Don't you mean, =If checkbox1.value = true, "Denied" Would that work?

Fionnuala Over a year ago

No, I do not mean checkbox1.value. And, no, it would not work. You need to link the checkbox to a cell, as described. You say you wish to put text in a cell based on a checkbox on sheet1. Why do you now wish to use code? Please update your question to show your new requirements.

Daniel Over a year ago

The easiest way is fine. How do I link the checkbox to a cell?

|

krusaint · Accepted Answer · 2010-06-10 13:34:52Z

1

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Range("M9").Value = "Approved"
Else
Range("M9").Value = "Denied"
Sheets("Sheet2").Range("M5").Value = "Denied"
End If
End Sub

answered Jun 10, 2010 at 13:34

krusaint

1114 bronze badges

2 Comments

Fionnuala Over a year ago

Are you not thinking if a user form? The above code would need to be added to the checkbox on sheet1, surely it is easier to skip the code and simply link a cell?

Daniel Over a year ago

This works great. Linking a cell would eliminate code, which would be a plus, but I don't know how to do it.

Collectives™ on Stack Overflow

Macro to Display String on Checkbox Select

2 Answers 2

11 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related