Slect left and right part of text

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

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
 
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
 
Back
Top