Combobox Not Working In Excel Workbook Shared Mode

When you doubleclick in a cell in Range("G3:G25") a userform apears with a combobox.
Selecting a value in the CB will put this value in the active cell.
The CB is filled by making use of a Dynamic NamedRange (check the formula in the NamedRange section)

Thanks for taking the time to look at this.

Is there a way to have the full list show at once on double click like the unshared attachment i put up ?
it just makes it easier to select,


peter

Then this approach might be more to your liking.
DoubleClick in Range("G3:G25") and a Listbox appears with full list in view.

Thank you bakerman

This works a great and looks good to
Thank you for your time and effort

Is there an easy way to remove my code and add yours into the
Large workbook I have already created or do I need to start again?

Once again thank you for you help

If you have a similar UF in your Large workbook you can just delete it and then just drag the one from this example workbook into your main workbook.
Make shure that you also copy the BeforeDoubleClick-eventmacro from the example workbook sheetmodule(worksheet test type) to your main workbook

Hi Bakerman

I have copied all the code etc into my main workbook and works a treat;) thank you very much for your
help with this.

EDIT: Removed new query to start a new thread with a relevant thread title