ActiveX ComboBox default value select

[otrava18]

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

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 !

 

[John_w]

Try one of these:

    Worksheets("TEMPERATURA").OLEObjects("INCALZIRE").Object.Value = "SISTEM INTEGRAT VRV"
    'OR
    Worksheets("TEMPERATURA").OLEObjects("INCALZIRE").Object.ListIndex = 0  '0 = first item in list

 

[otrava18]

Thank you very much John_w. It`s working great !