Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
formating userform textbox value to numericPosted by Skip Bisconer on June 15, 2001 7:46 AM
I am working on an investment research data base and use a userform to enter data into the table. My problem is that the numeric information gathered goes to the data base as text and I cannot seem to figure out how to get it to stay numeric. Any ideas will be appreciated.
Re: formating userform textbox value to numericPosted by g-man on June 15, 2001 8:06 AM
Have you checked the cell formatting on the destination cell(s)? They could be formatted as 'text' instead of 'general' or 'number'.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.