Show Cell Values in User Form- VBA

[bamaisgreat]

I have a workbook with 26 worksheets that could have data in a certain range of cells. What I'm hoping to have is a subroutine in a user form that will look at each sheet in a range of cells V5:Y39 and show a list with no blank rows in a user form. I will have a Button on each sheet that will call the user form.

I also need it to show which sheet and row the data is on.

Any suggestions?

Thanks as always.

 

[bamaisgreat]

I messed it up and took Activate out of the user form code. Works Great. Thanks for your help.

 

[My Aswer Is This]

I messed it up and took Activate out of the user form code. Works Great. Thanks for your help.

Glad you have it working now with Modeless.

 

[bamaisgreat]

Dante, I have a new scenario and was wondering if we could do away with the user form and I will have a button on the temp sheet to update it. Could we modify the code above to just go to temp sheet?