IF not empty Then Else

[hanif]

Hi All,

I have a userform with text boxes which copies the values to specific cells in worksheet. I want it to update only cells that values inserted into relative text boxes i.e. if the text box is not empty then copy the value into the cell else do nothing. I have used the following code but it is not working. any idea where am i doing wrong or any alternative solutions?

   If Not IsEmpty(TEXTBOX.Value) Then
        Sheets("WORKSHEET").Range("CELL").ClearContents
        Sheets("WORKSHEET").Range("CELL").Value = TEXTBOX.Value
        Else
    End If

Thanks