Call a userform from a listbox selection

[seanpears99]

Hi all

I have a workbook which on the double click of a cell calls a userform and populates it from the repsective underlying data.

Is it possible to allow the user to select a record in the list box, click a button on the form to say "Expand" selection, and then call another userform with a list box populated with the granulated data from a different sheet?

Convoluted I know but can it be done?

Cheers
ean

[Andy Pope]

Yes it can be done.
You need to provide more information though if you need help on how to do it. An example workbook including what you have currently and details of the expanded view.