Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

formating userform textbox value to numeric

Posted 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 numeric

Posted by g-man on June 15, 2001 8:06 AM

Skip,

Have you checked the cell formatting on the destination cell(s)? They could be formatted as 'text' instead of 'general' or 'number'.

G-man

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.