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
|