JadeCaridad
asked on
Dissecting a Field
Hi,
Can someone guide me as to what I am doing wrong. Here is the scenario. I have a combobox (in outlook) that is capturing data from 3 columns in excel. They are separated with a Tab. What I would like to do is upon selection of the name in the dropdown field the text is parsed out to their respective textboxes......
Example: John Michael 39 yrs 1/18/08
This is what I have:
TextBox3.text=Trim(Left(cb oBro.Text, Instr(cboB ro.Text, vbTab)))
TextBox53.text=Trim(Replac e(cboBro.T ext,textbo x3.text,"" ))
TextBox54.text= ??????
Textbox 3 works fine however Textbox 53 gives me the age and date when all I want is the age and can't figure out how to get only the date on Textbox54.
Any help or guidance will be so great.
thank you.
Can someone guide me as to what I am doing wrong. Here is the scenario. I have a combobox (in outlook) that is capturing data from 3 columns in excel. They are separated with a Tab. What I would like to do is upon selection of the name in the dropdown field the text is parsed out to their respective textboxes......
Example: John Michael 39 yrs 1/18/08
This is what I have:
TextBox3.text=Trim(Left(cb
TextBox53.text=Trim(Replac
TextBox54.text= ??????
Textbox 3 works fine however Textbox 53 gives me the age and date when all I want is the age and can't figure out how to get only the date on Textbox54.
Any help or guidance will be so great.
thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dude you are awesome!!!!!
thank you !!!!!!