list box question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tracy - 29 Mar 2005 22:49 GMT

I would like to be able to double-click an item in a listbox to proceed.
Currently, I have to click the item and click OK in order to proceed. What
is the command or property that I am missing?

Reply to this Message

Cindy M -WordMVP- - 30 Mar 2005 11:07 GMT

Hi =?Utf-8?B?VHJhY3k=?=,

> I would like to be able to double-click an item in a listbox to proceed.
> Currently, I have to click the item and click OK in order to proceed. What
> is the command or property that I am missing?

In the code sheet for the UserForm, select the dropdown box from the list at
the top left, then the DoubleClick event from the list at the top right. The
VB Editor should create a skeleton procedure from the event.

In that procedure, call the same code procedure that the clicking the OK
button executes.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message