Chose a Value in a dropdown List using VBA

[tharindudk]

Hi,

Is there a way to select a particular Value from a dropdown list using VB?

Thankyou

[Leith Ross]

Hello tharindudk,

Yes, you can. The code depends on the type of drop down you have.

Is it a Forms or ActiveX control?
Is it linked to a list?

[mehmetcik]

I assume your dropdown list is on your sheet.

If so I normally write my prefferred value or text to the cell.

If my list if names of fruit in cell E2 then

range("E2").value = "Apple"

If it is a combobox in a userform then

userform1.index = 5

[tharindudk]

Hi, I am using Data->Data Validation for my drop dow box. When I do

range("E2").value = "Apple"

Excel stop working and i have to clost it.

[mehmetcik]

I tried it before I posted and it worked ok here.

Check to see if you have spaces or periods in the validation box or in the text you use to set it.