Hi, I have some code I am trying to modify but struggling to understand how the selection and activate commands need to programmed to select the cell I just clicked on. I have a userform that inputs some text, and the code formats the cells a specific way. Right now, its set to output the results into cell D44. How do I modify this to output the results into any cell I have selected and not default to D44? It is more of a data entry into the cell I have selected. Thanks in advance!
Private Sub CommandButton1_Click()
Sheet1.Range("D44") = "={" & TextBox1.Value & "," & TextBox2.Value & "," & TextBox3.Value & "}"
Unload Me
End
End Sub
Bookmarks