Extract Portions of text box Information and insert into another textbox

I need to assign the value of a text box "txtheading" from information from another field named "Remarks" the value needs all text up to the first semicolon example:

Dim header as string
header= remarks.first line up to semicolon
txtheading=header

Open in new window



Or
txtheading.value= header= remarks.first line up to semicolon

whichever works better...

The information should appear exactly as it appears up to the semicolon including spaces and case
mickeyshelley1Asked:
Who is Participating?
 
mbizupCommented:
Dim header as string
header= Split("" & Remarks, ";")(0)
txtheading=header

Open in new window

0
 
mickeyshelley1Author Commented:
Trying it
0
 
mickeyshelley1Author Commented:
Thanks AGAIN : mbizup that works great!!! and thanks for responding so quickly
0
 
mbizupCommented:
Glad to help :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.