populating the dropdowns in a combobox when opening the doc

[Guest]

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

 

[Guest]

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.