Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox from 1st worksheet to textbox to other multiple sheets | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming |