Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Combobox Not Working In Excel Workbook Shared Mode

  1. #1
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12

    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

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Can you post a sample shared workbook that replicates the error you are facing?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    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
    Attached Files Attached Files

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Where's the combobox? Which sheet? Is it a data validation list? Or an actual combobox?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    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

  6. #6
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    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
    Attached Files Attached Files
    Last edited by peter renton; 05-24-2013 at 04:45 PM. Reason: ADDED SHARED WORKBOOK

  7. #7
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    I have tried attaching another opy of the sheet as the last one didnt have a working combo box for some reason?
    Attached Files Attached Files

  8. #8
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    13
    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 ???

  9. #9
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    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

  10. #10
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    Hi Bakerman

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

    Regards

    Peter

Similar Threads

  1. Changing Slideshow viewing mode to kiosk using vba
    By Times in forum Powerpoint Help
    Replies: 1
    Last Post: 05-10-2013, 12:37 AM
  2. Automate Date Changes Within Excel Workbook
    By Danno2cu in forum Excel Help
    Replies: 9
    Last Post: 02-18-2013, 11:39 PM
  3. Combobox VBA update value worksheet
    By Tony in forum Excel Help
    Replies: 4
    Last Post: 10-28-2012, 12:28 AM
  4. VBA Code Works Only in debug Mode.
    By princ_wns in forum Excel Help
    Replies: 2
    Last Post: 06-17-2012, 06:14 AM
  5. Timer to close excel workbook
    By leopaulc in forum Excel Help
    Replies: 5
    Last Post: 10-24-2011, 12:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •