PDA

View Full Version : [SOLVED] VBA CODE TO INSERT CHECKMARK ON ANOTHER SHEET



DeanP
11-25-2018, 07:57 AM
I have a macro that is run when a command button is clicked in another sheet (INPUT).
I want a checkmark to be placed in cell G7 of the INPUTS worksheet, and that worksheet to become the active sheet once the macro on the datasheet has run.
I don't want to have to do anything in the target sheet (ie double clicking).
I have researched but cannot find anything referring to placing a checkmark in a single cell.

So far I have:

Sheets("INPUTS").Select
Range("G7").Select

Any help would be appreciated.

Paul_Hossler
11-25-2018, 09:34 AM
Welcome to the forum

Read the FAQs from the link in my sig, esp the part about multi-posting and CODE tags


Something like this should get you started



Option Explicit

Sub Button1_Click()

With Worksheets("INPUTS").Range("G7")
.Font.Name = "Wingdings"
.Font.Size = "14"
.Font.Bold = True
.HorizontalAlignment = xlHAlignCenter
.Value = Chr(252)
.Parent.Select
End With

End Sub

DeanP
11-25-2018, 10:32 AM
Thank you Paul, exactly what I wanted.