View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Woodi2 Woodi2 is offline
external usenet poster
 
Posts: 61
Default 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