Userforms Values to Workbook Cells
How do I do this?
Ive tried this code in the worksheet and the userform bu is doesn't work
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheet("DDE Sheet").Range("I2").Value = frmOptions.TextBox1.Value
Worksheet("DDE Sheet").Range("K2").Value = frmOptions.TextBox2.Value
End Sub
Am I just being thick!
|