Multiple selections from a listbox

[yzer19]

I need to tweak a piece of code. The code works awesome but I need the output of the users selection to be pasted in a specific cell range (ie Book3 cells A15-A30. Thanks

Please Login or Register  to view this content.

[rylo]

Hi

you don't say if this button is already in Book3, so I'll assume that it is, and you are on the relevant output sheet.

Please Login or Register  to view this content.

This will start the output in A15 of the current sheet.

If your setup is different, can you give more details of where things are, and where you want the output to go (workbook names, sheet names etc)


rylo

[yzer19]

Thanks that worked great. I did change the code a little as the sheet was different for the output.

Please Login or Register  to view this content.

[yzer19]

I need to tweak the code a little more. The output currently paste into cell 37 and fills downwards. I want to make sure the user doesn't select more data than the space I have allocated allows on the spreadsheet. In this example once the user hits row 106 I would like the code to return an error message that they have selected t0o many accounts. Once the ok button is hit on the error message they would return to the selection box to try again. Hope this can be done, somehow.
Thanks
Rob

Please Login or Register  to view this content.

[rylo]

Hi

Try doing something like

Please Login or Register  to view this content.

I didn't test it, but I'm hoping it should kick you out of the for loop and send you back to the selection box.

rylo

[yzer19]

I tried the code but got some weird results. The selection box never appeared but I did get the message "Too many entries". Also it appears to have started to paste the accounts in cell A1 and not A37. Any ideas

[rylo]

Hi

I dummied something up and ran this manually. Seemed to work.

Please Login or Register  to view this content.

I knew I should have done some testing....


rylo

[yzer19]

Thanks again, that worked like a charm.