Format of data entered on UserForm

[Mike]

Hi,
If I use a UserForm to capture numbers, they are formatted
as text when I insert them to the worksheet. How can I get
numbers to show up as numbers and not text if they are
entered on the worksheet by a UserForm?

Thanks,

Mike

 

[Cindy Meister -WordMVP-]

Hi Mike,

If I use a UserForm to capture numbers, they are formatted
as text when I insert them to the worksheet. How can I get
numbers to show up as numbers and not text if they are
entered on the worksheet by a UserForm?

Have you tried converting them to a numeric value? roughly
ActiveCell.Value = Val(txtNumber.Text)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail