Double Click Listbox question

**frostii** · 02-17-2015, 05:50 PM

Hi everybody,

Was wondering if anybody could help with the following code. Firstly, yes, I am very new to vb coding!

I have a listbox with an OK and Cancel button. I wanted the user to be able to double click their choice, as well as single click and then OK.

I'm not sure where to put the code. Any help would be appreciated.

Here is the code:

Please Login or Register  to view this content.

Thx in advance!

**LJMetzger** · 02-17-2015, 06:34 PM

Hi frostii,

You were very very close.

You can do it either of two ways. Both are acceptable. It depends on which you prefer.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Lewis

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**frostii** · 02-17-2015, 07:44 PM

Originally Posted by LJMetzger

Hi frostii,

You were very very close.

You can do it either of two ways. Both are acceptable. It depends on which you prefer.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Lewis

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thank you so much! I knew I was close.

Also, I fixed the original post as per forum rules. Sorry, it was my first post!

Thx again.

How do I change this post to 'SOLVED'?

**LJMetzger** · 02-17-2015, 09:15 PM

I'm glad it worked out. Thanks for adding the CODE TAGS to the original post and welcome to ExcelForum.

Select Thread Tools from the menu link above to mark the thread as SOLVED.

Lewis