Double clicking the results in Listview to bring up another userform

[vbanew]

Hi everyone,

I am very new to VBA and definitely consider myself a beginner in regards to VBA. From these forums I have managed to create a listview to show search results for my database.

I thank everyone who has contributed in these forums. You guys/girls have made life a lot easier

I am stuck with one last thing I need to do for my project. I hope someone can help me out.

I created a listview for my search results and what I am trying to do is from my listview results I want to be able to double click a row of data (results) to bring up that specific row of data in another userform so the results can be shown in a more organized look. Results showing in textboxes. I hope I am making sense and I hope this is possible.

Thank you in advance

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[vbanew]

Thanks Roy.

Attached is my dummy workbook.

There are three userforms. One userform is to add data. One is to search using listview to show the results. The third userform (frmresult) I am hoping to show the data from the listview. The third userform looks exactly like the one to add the data.

I am able to bring the third userform by doubleclicking the results in the listview but with no actual data. That is the part where I am stuck. Any advice would be greatly appreciated.

[vbanew]

Bump Bump Bump =)

[royUK]

Personally I wouldn't use such a control as other users might not have access to it.

I would suggest that you look at a ListBox control, that's what I always use & have posted examples on the Forum

[Leith Ross]

Hello vbanew,

Here is the code for the ListView control to load the Result form..

Please Login or Register  to view this content.

[vbanew]

Thanks Leith and Roy for all the help not only in this thread but all the others I've been learning from!!

You guys are awesome

It must have been a long day at work. But how do you mark this as Solved?

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save