Slect left and right part of text

Hi All,

I have the following format text in a ComboBox of a UserForm.

1:1, 1:2..... 2:1, 2:2... and upt 110:200.

How i can select the left part before ":" and right part after ":" ?

since the number of charecters in the combobox is not the same (1:1
gives 3 while 110:200 gives 7) .

My objective is to select a file from my directory wher files are named
001001 through 110200, so that if cobobox value is 1:1 then i have to
select file 001001 and if combobox value is 110:200 then file 110200.

Thanks

Dim v As Variant
v = Split(Cells(1, "A"), ":")

v(0) contains LH value, v(1) contains RH value

"Soniya" wrote:

> Hi All,
>
> I have the following format text in a ComboBox of a UserForm.
>
> 1:1, 1:2..... 2:1, 2:2... and upt 110:200.
>
> How i can select the left part before ":" and right part after ":" ?
>
> since the number of charecters in the combobox is not the same (1:1
> gives 3 while 110:200 gives 7) .
>
> My objective is to select a file from my directory wher files are named
> 001001 through 110200, so that if cobobox value is 1:1 then i have to
> select file 001001 and if combobox value is 110:200 then file 110200.
>
> Thanks
>
>

I am not much with combo box but if the entries are in cells the following
will be relevant and you can modify

if the entry is in a cell because of colon( the format will be
automatially time. if you introduce a single apostrophe (') first (i.e '1:1)
it wil be text unlesss the cell is already formatted as text.

in that case to get left of colon, use this formula

=LEFT(E12,SEARCH(":",E12)-1)

to get the numbers to the rights of colon use this formula

=MID(E12,SEARCH(":",E12)+1,LEN(E12)-SEARCH(":",E12))

E12 is the cell where the entry is.
modify to suit you

"Soniya" <[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I have the following format text in a ComboBox of a UserForm.
>
> 1:1, 1:2..... 2:1, 2:2... and upt 110:200.
>
> How i can select the left part before ":" and right part after ":" ?
>
> since the number of charecters in the combobox is not the same (1:1
> gives 3 while 110:200 gives 7) .
>
> My objective is to select a file from my directory wher files are named
> 001001 through 110200, so that if cobobox value is 1:1 then i have to
> select file 001001 and if combobox value is 110:200 then file 110200.
>
> Thanks
>