Combobox Not Working In Excel Workbook Shared Mode

[peter renton]

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

[Excel Fox]

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

[peter renton]

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

[Excel Fox]

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

[peter renton]

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

[peter renton]

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

[peter renton]

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

[bakerman]

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 ???

[peter renton]

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

[peter renton]

Hi Bakerman

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

Regards

Peter

[bakerman]

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)

[peter renton]

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

[bakerman]

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

[peter renton]

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

[bakerman]

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

[peter renton]

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