I thought this was going to be easy !
i have a 2 column combo, in the 2nd column i join two strings e.g name and
six digit customer number.
As the names vary in length (number of characters), the customer numbers do
not line up vertically.
Hence i add spaces to the name to make all the names the same length. But i
soon realised that this does not work
as one character is not equal to one space.

is there a fix for this. I cannot use 3 coulmn combo and cannot put customer
number in column 1 and name in column two.

If n$<25 then
NumSpaces%= (25 - Len(N$))
N$ = N$ & String(NumSpaces%, " ")

Is there a formula or another solution to this?

Thank

Sunil

hi
confused. why can't you have 3 column combo box??

regards
FSt1

"sunilpatel" wrote:

I thought this was going to be easy !
i have a 2 column combo, in the 2nd column i join two strings e.g name and
six digit customer number.
As the names vary in length (number of characters), the customer numbers do
not line up vertically.
Hence i add spaces to the name to make all the names the same length. But i
soon realised that this does not work
as one character is not equal to one space.

is there a fix for this. I cannot use 3 coulmn combo and cannot put customer
number in column 1 and name in column two.

If n$<25 then
NumSpaces%= (25 - Len(N$))
N$ = N$ & String(NumSpaces%, " ")

Is there a formula or another solution to this?

Thank

Sunil

Don't use spaces... use Tab characters instead. VB has a constant defined
for the named vbTab... just concatenate one or more (depending on how
different the length of your names can be) of them between your names and
your numbers. As an example, something like this...

MyArray(1, 1) = Name1 & vbTab & vbTab & Number1

--
Rick (MVP - Excel)


"sunilpatel" wrote in message
...
I thought this was going to be easy !
i have a 2 column combo, in the 2nd column i join two strings e.g name and
six digit customer number.
As the names vary in length (number of characters), the customer numbers
do not line up vertically.
Hence i add spaces to the name to make all the names the same length. But
i soon realised that this does not work
as one character is not equal to one space.

is there a fix for this. I cannot use 3 coulmn combo and cannot put
customer number in column 1 and name in column two.

If n$<25 then
NumSpaces%= (25 - Len(N$))
N$ = N$ & String(NumSpaces%, " ")

Is there a formula or another solution to this?

Thank

Sunil

what you are doing will work fine if you use a text font such as "Courier
New"

"sunilpatel" wrote in message
...
I thought this was going to be easy !
i have a 2 column combo, in the 2nd column i join two strings e.g name and
six digit customer number.
As the names vary in length (number of characters), the customer numbers
do not line up vertically.
Hence i add spaces to the name to make all the names the same length. But
i soon realised that this does not work
as one character is not equal to one space.

is there a fix for this. I cannot use 3 coulmn combo and cannot put
customer number in column 1 and name in column two.

If n$<25 then
NumSpaces%= (25 - Len(N$))
N$ = N$ & String(NumSpaces%, " ")

Is there a formula or another solution to this?

Thank

Sunil

You need to check your system date. Unless you are located in Micronesia
somewhere, it appears to be a day ahead.


"sunilpatel" wrote in message
...
Thanks for you help, but not having desired effect, What am i doing wrong.
See code below

N$ = Sheets("CLIENTS".Range("B" & row%)
NoOfTabs% = 22 - Len(N$) ' where
desired total text length is 22
N$ = N$ & String(NoOfTabs%, vbTab)
ActiveCombo.LIST(row%, 1) = N$ ' added into combo
directly

Hope this is clear

"Rick Rothstein" wrote in message
...
Don't use spaces... use Tab characters instead. VB has a constant defined
for the named vbTab... just concatenate one or more (depending on how
different the length of your names can be) of them between your names and
your numbers. As an example, something like this...

MyArray(1, 1) = Name1 & vbTab & vbTab & Number1

--
Rick (MVP - Excel)


"sunilpatel" wrote in message
...
I thought this was going to be easy !
i have a 2 column combo, in the 2nd column i join two strings e.g name
and six digit customer number.
As the names vary in length (number of characters), the customer numbers
do not line up vertically.
Hence i add spaces to the name to make all the names the same length.
But i soon realised that this does not work
as one character is not equal to one space.

is there a fix for this. I cannot use 3 coulmn combo and cannot put
customer number in column 1 and name in column two.

If n$<25 then
NumSpaces%= (25 - Len(N$))
N$ = N$ & String(NumSpaces%, " ")

Is there a formula or another solution to this?

Thank

Sunil