Hello all,
How do I use the result of i (i.e. value = 4) in below example in a change event on the same UF?
The example below gives me the following error: "application-defined or object-defined error"
Private Sub UserForm_Initialize() i = ActiveSheet.Shapes(Application.Caller).Name - 118 End Sub Private Sub TextBox1_Change() Sheets("DBS").Range("A" & i).Value = TextBox1.Value End Sub
Bookmarks