Solved: Dropdown Formfield

[petedw]

Guys,
Other than using SendKeys, how do i make a Dropdown formfield drop down its list on entry??
It's doing my head in!

Thanks
Pete

[fumei]

As far as I know, formfields do not have a method for dropping down. A Combobox, on the other hand, DOES.

This includes comboboxes on UserForms, as well as ActiveX comboboxes IN a document. You would use the GetFocus event to fire:

Combobox1.Dropdown

[MOS MASTER]

Hi Pete,

Nopes it's not possible and I've showed you the method with SendKey's the last time: http://www.vbaexpress.com/forum/show...field+dropdown

This is the only method I know of to do this:[Vba]
Sub DropDownList()
SendKeys "%{DOWN}", True
End Sub
'Entry macro[/vba]

So I think there's nothing more to do then use that.

[petedw]

Thanks for the advice guys

[MOS MASTER]

Where always there for you buddy!