Hello,
I have a ComboBox in ActiveX and i want to select a value with VBA, that is inside the list of CB. I`m noob and and i can`t find a solution, I have used
It doesn`t work for me. My CB is named "INCALZIRE" and i have 3 values inside (SISTEM INTEGRAT VRV is one of these three,this is the value that i want to set when i click to a shape)
It doesn`t work for me. My CB is named "INCALZIRE" and i have 3 values inside (SISTEM INTEGRAT VRV is one of these three,this is the value that i want to set when i click to a shape)
Can you give me an advise?
Thank you !
I have a ComboBox in ActiveX and i want to select a value with VBA, that is inside the list of CB. I`m noob and and i can`t find a solution, I have used
VBA Code:
Sub Gata_Functii()
Worksheets("TEMPERATURA").ComboBox("INCALZIRE").Value = "SISTEM INTEGRAT VRV"
'OR'
Worksheets("TEMPERATURA").ComboBox("INCALZIRE").ListIndex = -1
End Sub
It doesn`t work for me. My CB is named "INCALZIRE" and i have 3 values inside (SISTEM INTEGRAT VRV is one of these three,this is the value that i want to set when i click to a shape)
It doesn`t work for me. My CB is named "INCALZIRE" and i have 3 values inside (SISTEM INTEGRAT VRV is one of these three,this is the value that i want to set when i click to a shape)
Can you give me an advise?
Thank you !