Hi everyone

I posted a few days ago because i had been asked to set up a workbook to allow users to select multiple items from a drop down list which i managed to get working and posted the code / marked my thread as solved.

However, in getting this to work it has caused a problem with a floating command button i use on most workbooks as a MENU. Basically the cmd button moves near the active cell so even if the user in deep in a worksheet the menu button is there and they don't have to scroll to the top. Now i have the multiple drop down list selection this no longer works properly.

I have attached an example workbook with 2 sheets, the first has the code allowing users to select multiple items form drop down lists and the second shows how the floating command button should work.

Can anyone help tweak the code so the command button floats properly on the same page as the multiple drop down list page?

thanks

MykalMultiple Selection Drop down lists.xlsm