Combobox blank when re-opening document RRS feed

  • Question

  • Hi all, apologies if I come across as having too basic an-understanding of the topic- I have self taught myself in the last 24 hours from scratch in order to create a document template for work but I can't get over this final hurdle...I have a template document with many combobox controls (around 25 of them) but each time I open the document, the comboboxes will not display any of the dropdown options until I have opened the VBA editor, selected each Private Sub in turn and run the Macro (F5). I can't ask my staff to do this every time they complete the form, so is there a way to write it so that all the combo boxes 'work' as they should as soon as the document is opened? Like an auto exec macro that will run all the private subs immediately when the template is opened for editing? If so how? the code is obviously quite lengthy but if it helps to see it let me know and ill upload it

    Many thanks in advance for your time!


    Monday, June 20, 2016 2:26 PM