Posted to microsoft.public.excel.programming

kirkm[_8_] kirkm[_8_] is offline

external usenet poster

Posts: 166

TextAlign in List Box

I'm answering my own question!

Just in case anyone's interested... or has an improvement.

Set TextAlign to 3. This fixes the numbers

For left alignment this works for me -

Function fixedlength(theString)
fixedlength = Left(theString & String$(10, 9), 10 + Len(theString))
End Function

ActiveWorkbook.Worksheets("Sheet1"t).Range("A1").V alue =
LTrim(fixedlength("12345"))

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
Use VBA to reset data validation (=list) value to first value in that list (list is a named range)	ker_01	Excel Programming	7	October 27th 08 03:13 PM
Compare List A to List B, Return List B Items Not in List A	zwestbrook	Excel Programming	4	September 18th 08 10:32 PM
Userform TextBox TextAlign Problem-Bug?	Jason Moser	Excel Programming	0	July 10th 06 01:25 PM
TextAlign in Combo Boxes	Barry Jive	Excel Discussion (Misc queries)	2	June 25th 05 04:52 PM
Listbox textalign	R4gtl	Excel Programming	1	January 26th 05 08:32 PM

All times are GMT +1. The time now is 01:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us