View Single Post
 
Old 03-25-2022, 02:34 AM
philip.anthony philip.anthony is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2022
Location: Malaysia
Posts: 6
philip.anthony is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
You've already got code in your document that changes the content in the dropdowns. Please explain more clearly what it is that you want to happen.
Hi Andrew,

Thanks for your reponse. The doc only with multiple dependent dd. What I what is upon selecting the multiple item for instant level 1 & level 3, I want some text to be displayed. in another plain text CC. My bad not the coding below is not good syntax. Its just an example to show what i want. No sure how to achieve this.

eg.

Select Case CCtrl.Tag
Case "Level 1" && Level 3
Set cc1 = CCtrl.Range.Document.SelectContentControlsByTag("L ogs")(1)
Select Case CCtrl.Range.Text
Case "Fire" && "100"
cc1.Range.Text = "whatever text you want for abc"
Case "Earth" && "600"
cc1.Range.Text = "whatever text you want for def"
Case "Air" && "1200"
cc1.Range.Text = "whatever text you want for ghi"
Case Else
cc1.Range.Text = vbNullString
End Select
Reply With Quote