I have a userform with a bunch of symbols on command buttons. These symbols use a specific font and lowercase letters.
I need to select the command button with the symbol I need to use and using a mouse click on a cell place the lowercase letter and format the cell with the font.
I actually have it working using a prompt, but its extremely clunky and the technicians using the workbook don't like it.... Neither do I!
Can this function be done differently? See my code below:
Private Sub cb_CHAMFER_Click()
Dim rng As Range
Set rng = Application.InputBox(prompt:="Select Destination", Type:=8)
ActiveCell.Font.Name = "GDT"
ActiveCell.Value = "w"
End Sub