allowing for different string lengths in message box

[nigelog]

The following code gives a warning message but the different string lengths of the registration numbers is offsetting longer values

Please Login or Register  to view this content.

I've tried quite a few methods, including the above function, but cant find the solution. Anyone any ideas?? Appreciated as its annoying

[6StringJazzer]

Displaying text in column alignment is notoriously a pain. I would try creating a userform and displaying the data in a listbox with columns. The user will be able to click in it although it won't do anything. Alternatively it could be disabled but that would gray out the text.

Here is a mock-up using the little bit of information you provided:

[nigelog]

Thanks Jeff

I've spent an ordinate mount of time stubbornly trying to sort but as there are only ever 6 or so I think I'll adapt your userform and listbox

Ta

[dflak]

You may have to pad the input data. It looks like 9 spaces should do it.

Please Login or Register  to view this content.

Include this function in your module

Please Login or Register  to view this content.

[bakerman2]

I've made a small example file you can adapt to your situation.
The code searches the longest string in column B and the spacing is related to that.

Please Login or Register  to view this content.

[nigelog]

@ dflak

I got a syntax error at

Please Login or Register  to view this content.

@Bakerman2

Did the job after adding "+2 after your code, I can adapt that. Many thanks

Please Login or Register  to view this content.

[bakerman2]

Glad to help. Thanks for rep+.

PS
Probably a typo by dflak but this should work

Please Login or Register  to view this content.

[nigelog]

Yep, that worked too..

Please Login or Register  to view this content.

[xlnitwit]

Just for information, you can reduce the PadString function to this

Please Login or Register  to view this content.

[nigelog]

Perfect Don