Text Box lost its leading 0 - need help
 

The strangest thing happened ... for the longest time my macro worked
well. One textbox queries a lot number which starts with a 0.

The target field is formatted as text:

Range("Z2:Z3").NumberFormat = "@"

All of a sudden the box removes leading zeros... Cant figure out why
.... the code realting to this hasnt changed.

How can I force the box to be text and leave leadign zeros alone?

Matt

Text Box lost its leading 0 - need help
 

Problem corrected: Not sure how but I forced the leading zero in there
;)

Text Box lost its leading 0 - need help
 

In any event, you can use the text property of the range to display the
value as displayed

msgbox ActiveCell.Text

rather than

msgbox ActiveCell.Value

--
Regards,
Tom Ogilvy


"Matt" wrote in message
oups.com...
Problem corrected: Not sure how but I forced the leading zero in there
;)