If condition not working.

macropod · #1 06-15-2019, 01:25 AM

So how is the displayed name, which is equivalent to .Range.Text, any different from Split(StrDetails, "|")(0)? Where does StrDetails come from?

jhansrod · #2 06-15-2019, 01:43 AM

The dropdown list for the ContentControl has the following :

Code:

Display Name   Value
OFFICE01       OFFICENAME1|Address 1L1;Address 1L2;Address 1L3
OFFICE02       OFFICENAME2|Address 2L1;Address 2L2;Address 2L3

The DropDownList will have the relevant office code whilst Split(StrDetails, "|")(0) will have the full name.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If condition related query...	LearnerExcel	Excel	1	03-12-2018 01:37 AM
How to use if condition to for this ...	LearnerExcel	Excel	1	12-19-2016 02:14 PM
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
Condition formating for date?	yabbah	Excel	2	05-31-2012 12:38 PM
check with condition	karti	Word	2	03-15-2011 06:06 AM