Hi everyone.
First time user.
I am wanting to write code so, if I double click any data contained in the List box in coloum A, it will populate that text data into cell E3. If cell E3 already has data, then paste it to cell E4 and so on.
Thanks
Hi everyone.
First time user.
I am wanting to write code so, if I double click any data contained in the List box in coloum A, it will populate that text data into cell E3. If cell E3 already has data, then paste it to cell E4 and so on.
Thanks
Try this for now and you will get a better code from experts.
Regards,
tt3
Hi tt3.
Great work. almost there. Is there a way to double click the chosen code from the list box? - I wanted the full menu of codes visable and not having to use drop down box.
Thanks
Hello Shaneg1,
The ListBox you are using is a Forms type which does not support the Double-Click event. I have added an ActiveX ListBox in it's place. The following code is run whenever the the user Double-Clicks a selection in the ListBox.
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith. It works as you said. Q - how do I get the data into the list index?
Hello Shaneg1,
The property ListFillRangesets the range of data to be displayed in the list box.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks