Posted to microsoft.public.excel.programming

MarkVan

external usenet poster

Posts: 1

Formatting Textbox

I have a listbox and a few text boxes. When I click on the listbox it fills
in the appropriate fields in the text boxes. I am trying to format the
textbox. One of the fields is a phone number and the other is a date.

I have tried this

format(txtPhone.text, '999-999-9999')
txtDateofBirth.txt

Nothing works. Please advise if this is possible using VBA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formatting a textbox	Ed	Excel Discussion (Misc queries)	1	February 24th 08 09:15 PM
textbox formatting	jnf40	Excel Discussion (Misc queries)	1	August 3rd 06 08:12 PM
TextBox Formatting	ToddG[_2_]	Excel Programming	5	April 7th 04 09:29 PM
Textbox formatting	James Auty	Excel Programming	1	February 4th 04 06:34 PM
Textbox formatting	Todd Huttenstine[_3_]	Excel Programming	5	January 25th 04 12:25 AM

All times are GMT +1. The time now is 09:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us