Combobox Not Working In Excel Workbook Shared Mode

Hi

Is there a way to allow combo box to work in shared mode in excel 2010?
i have a sheet that works fine until i try to share the book then it stops

Regards

Peter

Can you post a sample shared workbook that replicates the error you are facing?

Hi i have attached a sample file this is not shared and the combo box works in column g
is you share the book this stops working , is there a way to work around it ?


Peter

Where's the combobox? Which sheet? Is it a data validation list? Or an actual combobox?

Hi

the combo box is in the middle sheet in column g (double click and it comes up) it picks the list up from the data sheet,
there is also a validation list on the same column looking up the same list (i did this first and just have not removed it)
when its shared the double click list wont work but the validation list still does.

Peter

Hi

Dont know if you had time to look at this?
Is there a way to allow the combobox list showingall the names in row a in the data sheet, when i share
the workbook?
There is a validation list that will still work but i have to scroll down the list, it looks and works much better if i can see all items in the list.What ever is selected then auto fills the correct hours/costs etc

I have created the full workbook before i came across the shared problem so i would be gratful for any help in solving this problem

i have added a shared version which shows that if you now double click column g no list appears

PETER

I have tried attaching another opy of the sheet as the last one didnt have a working combo box for some reason?

I can't find a validationlist or a combobox in Column G, the only thing i can find is a Userform WITH a combobox which after a few adjustments works fine for me.
One word of advice though, either use the List-method to fill the CB or use a dynamic NamedRange instead of refferring to an entire column.
Also in your sheetmodule there is a lot of code mentioning an object called TempCombo ???

Hi Thanks for taking a look

Could you tweak the code to the best format for me so i can see what you mean?
I have been adding bits of code to try to make things work so there may be things that dont
need to be there.
This is my first attempt to try to use excel like this so any help would be appreciated.



Peter

Hi Bakerman

What adjustments did you do to make it work???

Regards

Peter

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