CODEWITHSUNDEEP
vbaexcel
Neeraj Singh Chouhan
Neeraj Singh Chouhan

Reputation: 676

Run-time error: '438': Object doesn't support this property or method

My Client is getting this error but it is running fine on my machine. He is getting error on this line..

ActiveSheet.ComboBox1.Value = "Select Department Category Group"

can you please tell me what is porblem??

Upvotes: 0

Views: 1002

Answers (1)

R.Katnaan
R.Katnaan

Reputation: 2526

Actually, It is a drop down type. So, You cannot set value. You should add item as follow:

Sheets("sheetname").Shapes("comboname").ControlFormat.AddItem ("Select Department Category Group")

Upvotes: 0

Related Questions