Like this:
![]()
Private Sub CommandButton18_Click() If InStr(1, ActiveCell, "/") Then ActiveCell.FormulaR1C1 = ActiveCell.Value & "k" Else ActiveCell.FormulaR1C1 = ActiveCell.Value & "j" End If: End Sub
Like this:
![]()
Private Sub CommandButton18_Click() If InStr(1, ActiveCell, "/") Then ActiveCell.FormulaR1C1 = ActiveCell.Value & "k" Else ActiveCell.FormulaR1C1 = ActiveCell.Value & "j" End If: End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks