Do a search, display results in a userform with the ability to copy selected data.

Hello

I was looking for a way to search through database and display the results in userform and managed to find this particular thread.

http://www.excelforum.com/excel-prog...-userform.html

The samples provided were absolutely wonderfull and fit the criterias I was looking for.

There is however one more item I would like to be able to do and that is to be able to select a specific cell within the listbox of the userform to have the ability to copy it and paste it somewhere else.

Is this possible? Does it require changes to the macro or can i simply change something within the listbox configuration properties.

Originally Posted by Leith Ross

Hello blkmagik,

In the thread you are referring to, I replaced the ListBox with a ListView control for the poster. I assume you mean the ListView control and not the ListBox. It is possible to select (click) on a single row item and take some action. It would be helpful if you can post the workbook.

Hi Leith

Thank you for responding back, i do appreciate you taking the time to help me with this.


I am providing you with a sample of the workbook. I made a slight change to the original macro to suit my needs.
The change was on this particular line

Set Wks = Sheets(2) 'SET TO LOOK IN WORKSHEET 2

I wanted the macro to query Sheet2 as opposed to Sheet1


So you mentioned replaceing the listBox with a ListView? Do i need to make changes to the properties or wil it
the row item be selectable by default?

Also i was wondering what the correct syntax would be if i wanted the macro to query a specific workbook on the local
drive. E.g C:\Database.xls.

I intend to have two workbooks, 1 that I would have the command button to query and paste the located data into
and another workbook that holds the entire database.

..bump.....