troubleshooting Question

Protecting a Cell, from input but allow radio button commend to populate the field with the user id and timestamp

Avatar of Carolynne Donohue
Carolynne Donohue asked on
SalesMicrosoft ExcelMicrosoft Office
2 Comments1 Solution127 ViewsLast Modified:
I want to protect a cell from editing but allow the cell to be populated with a radio command button that populates the cell with the user id and timestamp.  a pop up message appears when the cell has been populated (in my case approving the form).  I can certainly lock the cell but then the radio button doesn't work,  what do I need to add on the front end of marco below?

Sub Product()

  UserName = Environ("username")
    ActiveCell.FormulaR1C1 = UserName
    ActiveCell.FormulaR1C1 = " " & Now

    x = UCase(Range("$i$5").Value)
    y = UCase(Range("$i$3").Value)
    If x = y Then

    MsgBox "ERROR - APROVER ID ERROR" & vbNewLine & vbNewLine & "Product Approver ID must be different then Sales Approver ID"

    ActiveCell = vbNullString
    ActiveCell = vbNullString
    Exit Sub
    End If

    MsgBox "Approved"
End Sub
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros