 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / April 2006combo box and userform
Do I have to use a user form for a combo box? I have a document that has text boxes and a few combo boxes and an update button that will load the information into an Access database. My issue is that I have populated these boxes by using run form but then it is blank when I open it up again. I have tried to using userform_initialize but I don't quite understand the process as the form pops up first thing when I open the document and the combo boxes are lower in the document so it is confusing to have it open first thing. This is the coding that I have: Private Sub Education_Change() Education.List = Array("High School", "AA/AS", "BA/BS", "Master's", "Doctorate") End Sub Help would be greatful, thanks. You can put your code in a AutoNew and AutoOpen macro. Hi =?Utf-8?B?amRlcnJpZw==?=, I'm not really sure I understand everything, here, but... Yes, some ActiveX controls (from the Control Toolbox) do reset when the document is closed (so you notice it when you open it the next time). This means you have to run some initialization code. In Word, you can use the Document_Open event in the ThisDocument module. Or you can include an AutoOpen macro in any module. If you're working with a template, and new documents are being created from the template, then you need the Document_New event or a AutoNew macro. > Do I have to use a user form for a combo box? I have a document that has > text boxes and a few combo boxes and an update button that will load the [quoted text clipped - 3 lines] > as the form pops up first thing when I open the document and the combo boxes > are lower in the document so it is confusing to have it open first thing. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.