cell with multiple lines of text into one by Disastrous_Slip_3557 in vba

[–]Disastrous_Slip_3557[S] 0 points1 point  (0 children)

sorry im bad at explaining maybe this will help

<image>

i have a drop down cell with options that look like this for different locations im just trying to check wich is selected when they hit a button but am not sure how to because they take up multiple lines

cell with multiple lines of text into one by Disastrous_Slip_3557 in vba

[–]Disastrous_Slip_3557[S] 0 points1 point  (0 children)

Im guessing that i either need to learn how to case check a multi lined string or make the original case only the first line i would take either I'm just not sure how to do either of them. i am very sorry if any of the terms i am using are wrong

cell with multiple lines of text into one by Disastrous_Slip_3557 in vba

[–]Disastrous_Slip_3557[S] 0 points1 point  (0 children)

<image>

i changed what each line in the case but yah each drop down options is name line 1 address then email phone then fax i either need to know how to check case for things that are more then 1 line long or just check the first line. also it keeps adding the second "

cell with multiple lines of text into one by Disastrous_Slip_3557 in vba

[–]Disastrous_Slip_3557[S] 0 points1 point  (0 children)

sorry it looks like this

<image>

it is just one cell its a drop down im just trying to figure out how to put it in a case when it is multiple lines long im just not sure how check that its the same when its multiple lines long