textbox Do nothing
 

Hi, i am trying to use a textbox on a userform. I would like the code below
to do nothing if the textbox value is empty.

I can use this code
ActiveCell.Offset(0, 8) = TextBox8.Value
but I need the textbox not to perform a function if the textbox is empty.
This is because the cell that the textbox is writing to contains a Sum. I
only want this Sum over writing with the textbox value if the textbox
contains a value.
Thanks

textbox Do nothing
 

Hi,

Enclose it in an IF statement

If TextBox8.Value < "" Then
ActiveCell.Offset(0, 8) = TextBox8.Value
Else
'maybe do something else
End If

Mike

"Woodi2" wrote:

Hi, i am trying to use a textbox on a userform. I would like the code below
to do nothing if the textbox value is empty.

I can use this code
ActiveCell.Offset(0, 8) = TextBox8.Value
but I need the textbox not to perform a function if the textbox is empty.
This is because the cell that the textbox is writing to contains a Sum. I
only want this Sum over writing with the textbox value if the textbox
contains a value.
Thanks