![]() |
#1
|
|||
|
|||
![]()
Hi
In the code below, why would OFFICEHEAD always be set to "JUST HEADER". Code:
With ActiveDocument.SelectContentControlsByTitle("A-OFFICE")(1) .LockContents = False .Range.Text = Split(StrDetails, "|")(0) .LockContents = False Select Case .Range.Text Case "OFFICE01" With ActiveDocument.SelectContentControlsByTitle("OFFICEHEAD")(1) .LockContents = False .Range.Text = "OFFICE01 HEADER" .LockContents = True End With Case "OFFICE02" With ActiveDocument.SelectContentControlsByTitle("OFFICEHEAD")(1) .LockContents = False .Range.Text = "OFFICE02 HEADER" .LockContents = True End With Case Else With ActiveDocument.SelectContentControlsByTitle("OFFICEHEAD")(1) .LockContents = False .Range.Text = "JUST HEADER" .LockContents = True End With End Select End With Thank you J |
Tags |
if then else;case |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
If condition related query... | LearnerExcel | Excel | 1 | 03-12-2018 01:37 AM |
![]() |
LearnerExcel | Excel | 1 | 12-19-2016 02:14 PM |
![]() |
SoonerLater | Mail Merge | 1 | 09-30-2015 05:40 PM |
![]() |
yabbah | Excel | 2 | 05-31-2012 12:38 PM |
![]() |
karti | Word | 2 | 03-15-2011 06:06 AM |