Home |
Search |
Today's Posts |
#1
|
|||
|
|||
populating the dropdowns in a combobox when opening the doc
Hi - I see your message to Jinny and have used the autonew/autoopen commands
in the code however it does not seem to be working when I open the document ....a copy of the code is below... Public Sub AutoNew() End Sub Public Sub AutoOpen() End Sub Private Sub ComboBox1_Change() ComboBox1.ColumnCount = 1 'Load data into ComboBox' ComboBox1.List() = Array("Select One", "Public", "Private") etc etc Is this in the right place/module? One other thing - this is for a questionnaire/survey - given the issues with macros via email is there any advice on the best way to circulate this while maintainig the integrity of the document . thanks for your help...theres no doubt i need it all!!! Regards Dan |
#2
|
|||
|
|||
sorry - i should have explained this better - the issue is I keep losing the
info in the drop downs and need to manually run the marco in the code. "DanG" wrote: Hi - I see your message to Jinny and have used the autonew/autoopen commands in the code however it does not seem to be working when I open the document ...a copy of the code is below... Public Sub AutoNew() End Sub Public Sub AutoOpen() End Sub Private Sub ComboBox1_Change() ComboBox1.ColumnCount = 1 'Load data into ComboBox' ComboBox1.List() = Array("Select One", "Public", "Private") etc etc Is this in the right place/module? One other thing - this is for a questionnaire/survey - given the issues with macros via email is there any advice on the best way to circulate this while maintainig the integrity of the document . thanks for your help...theres no doubt i need it all!!! Regards Dan |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Combobox when printing | Microsoft Word Help |