Hi Rob:

I just took the OP's word for what was happening (Chr(9) was producing a
placeholder character rather than a tab), but of course you are correct. So
quite possibly the OP is indeed talking about a drawing object textbox on a
worksheet.

I didn't bother to test it because I still can't conceive of a good reason
to use a tab character within a textbox, but as I said earlier, I probably
have a limited imagination <g.

Regards,

Vasant.


"Rob Bovey" wrote in message
...
Hi Vasant, Bob,

As far as I know, there's no problem putting tab characters into an
MSForms TextBox. I'm assuming that the OP is talking about a TextBox
drawing
object on a worksheet?

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Hi Bob:

I was confused because a TextBox is a control in which one (generally)
manually enters data. What would be the purpose of having a preformatted
tab
chatracter in there? But maybe I've just lived a sheltered life ... ;-)

Regards,

Vasant.




"Bob Phillips" wrote in message
...
Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
Hello

Is there a way to insert a string with enclosed tab characters
into
a
textbox?
I tried with chr(9) but i don't get a tab only a placeholder for
an
unprintable character.

Thanks