Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
User enters their data on the form then clicks ok.
A sub executes, and initially I use trim on some of the textboxes eg: With FrmDataEntry UsrName = Trim(.TbUsrName) which doesn't work...and tried UsrName = Trim(.TbUsrName.Value) which doesn't work either. However, this statement which is executed from a different form's click event does work: If Trim(Userform1.TextBox1) = "" Then Education please! Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trim and Substitute not working | Excel Worksheet Functions | |||
Excel 2002 : Why =TRIM() formula not working ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Why =Trim () formula not working ? | Excel Discussion (Misc queries) | |||
Excel trim not working | Excel Discussion (Misc queries) | |||
VBA Trim and Application.worksheetfunction.Trim | Excel Programming |