Get the total number of Space from the left(pls help)

[PinoyDev]

Hello guys and Good day!

I just want a little help on how to get the total number of space from the left until the word starts and display the total space in msgbox..

Example:

combo1.AddItem = "                        Bank       "

In this example the total number of space from the left is 30.

Thank you for your reply..Thank you.!

God bless!

[WaltP]

Look up the mid function and put it in a loop.

[PinoyDev]

thank you for the reply...but what is the function to detect the space when i used the mid function?

[PinoyDev]

Look up the mid function and put it in a loop.

thank you for the reply...but what is the function to detect the space when i used the mid function?

[debasisdas]

(length of the string including space ) - (lenth of the string after LTRIM) = number of spaces in the start of the string.

Len("Visual Basic") - Len(ltrim("Visual Basic"))

[WaltP]

Look up the mid function and put it in a loop.

thank you for the reply...but what is the function to detect the space when i used the mid function?

If you look up the function, I'm sure you can figure it out.

[PinoyDev]

thank you guys..

this formula works without looping...

dim total space as integer

totalspace = Len("Visual Basic") - Len(ltrim("Visual Basic"))

msgbox totalspace

One last clarification...Can i additem on a combo box that will start at position 11 or the total space value without looping?

This means that when i add new item, it will automatically add 11 space or base upon the totalspace variable value from the left..

Please add the code above if its possible..

thank you once again to all of you guys..

God bless

[PinoyDev]

final solution..

dim total space as integer
 
totalspace = Len("Visual Basic") - Len(ltrim("Visual Basic"))
 
msgbox totalspace

now to add item depending on totalspace var.here it is..

combo1.additem Space$(totalspace) & "Hello"

thank you guys