I have a drop down form field, and I want it to automatically down on when
tabbed into it/on focus.
You can call a macro on enter, so I was wanting to know how to auto drop down
the list, or rather, simulate the key pressing of Alt and Down arrow (as
these 2 together would normally drop down the list)
Simply put, my question is how do I code a button press or combination of
simulatious button presses?
OTWarrior - 23 Aug 2007 15:53 GMT
Or even just the code that opens the drop down box???
OTWarrior - 28 Aug 2007 09:52 GMT
Doug Robbins - Word MVP - 28 Aug 2007 10:56 GMT
Use the command
SendKeys "%{down}"
in a macro run on entry to the formfield.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
>I have a drop down form field, and I want it to automatically down on when
> tabbed into it/on focus.
[quoted text clipped - 5 lines]
> Simply put, my question is how do I code a button press or combination of
> simulatious button presses?
OTWarrior - 28 Aug 2007 11:49 GMT
>Use the command
>
>SendKeys "%{down}"
That was exactly what I was after, thank you :)