#1
|
|||
|
|||
Combobox blank when re-opening document
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! Rob |
#2
|
||||
|
||||
Cross-posted (and answered) at: https://social.technet.microsoft.com...ent?forum=word
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
combobox, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Crash after power failure. Doc is now blank and appears to auto-generate as a new doc on opening | Jbobjones | Word | 0 | 04-28-2015 09:37 PM |
Macro for opening a blank Word document from My Templates (Mac) | yinswenti | Word VBA | 6 | 02-08-2015 08:10 AM |
Opening PPT without a blank slide | Welshie82 | PowerPoint | 4 | 09-30-2013 03:28 PM |
When opening powerpoing a new blank slide opens | bythelake | PowerPoint | 0 | 04-01-2013 11:04 AM |
All my word documents are opening as blank. | Omni1 | Word | 1 | 07-14-2011 04:23 PM |