Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox issue
I have a userform with 30 textboxes to allow the user to enter data.
This data is then copied to a worksheet. During usage they may need to leave some or all textboxes blank. This has the result of empty text strings "" being copied to my worksheet. This screws up some isblank and countif functions. Is there a way to set the empty textbox to "blank" ? Failing that what is the easiest way to find and delete empty text strings in a row? Find doesn't find them. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |