Hi nice video bytheway, could you tell me, how if when i click each option the colour of the background should changes too... Let say if i choose text red, the bankground will be changes to red colour too.. Appreciated it for your help
Try this Private Sub ComboBox1_Change() If ComboBox1.Value = "RED" Then ComboBox1.BackColor = RGB(255, 0, 0) End If If ComboBox1.Value = "yello" Then ComboBox1.BackColor = RGB(255, 255, 0) End If If ComboBox1.Value = "green" Then ComboBox1.BackColor = RGB(0, 255, 0) End If End Sub Private Sub ComboBox1_GotFocus() If ComboBox1.ListCount = 0 Then ComboBox1.AddItem "RED" ComboBox1.AddItem "yellow" ComboBox1.AddItem "green" End If End Sub
I strongly dislike videos with no audio... but you did a GREAT JOB! You turned my dislike to a like... Thanks a million...
Hi Renuka. i would like to know how to code if i had to link my slides as per the options choosen fron the drop down menu. can you help please
how to make the dropdown work in edit mode
I was wondering how could i create multiple indepedent dropdown list in ppt?
Awesome
how drop list is linked with excel cell drop down list
Hi nice video bytheway, could you tell me, how if when i click each option the colour of the background should changes too...
Let say if i choose text red, the bankground will be changes to red colour too..
Appreciated it for your help
Try this
Private Sub ComboBox1_Change()
If ComboBox1.Value = "RED" Then
ComboBox1.BackColor = RGB(255, 0, 0)
End If
If ComboBox1.Value = "yello" Then
ComboBox1.BackColor = RGB(255, 255, 0)
End If
If ComboBox1.Value = "green" Then
ComboBox1.BackColor = RGB(0, 255, 0)
End If
End Sub
Private Sub ComboBox1_GotFocus()
If ComboBox1.ListCount = 0 Then
ComboBox1.AddItem "RED"
ComboBox1.AddItem "yellow"
ComboBox1.AddItem "green"
End If
End Sub
Hello. Thank you for tutorial. How to do the same think but with images à place of text? Tank you
quebuen amigo