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! :banghead:

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, :D

Nopes it's not possible and I've showed you the method with SendKey's the last time: http://www.vbaexpress.com/forum/showthread.php?t=2978&highlight=formfield+dropdown

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

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

[petedw]

Thanks for the advice guys :thumb

[MOS MASTER]

Where always there for you buddy! :yes