 |
 | 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 2005More than 25 entries in a drop-down form field
I am creating an MS Word 2002 template for my client and have just run into the 25-entry limit trying to enter the properties. I need to put more like 40 choices on the drop-down field. Is there any way to beat this limit in VBA? I'm trying to create a self-contained template that the user selects a value, and, based on what they select, the document is e-mailed to different addresses. Oh, and while I'm at it, I also had to use the SendForReview method because I couldn't find any way to set the subject and e-mail address using SendMail. Any suggestions for either problem? Thanks in advance! Create autotext for each entry. Creat a toolbar for the template. Drag the autotext into the toolbar. >I am creating an MS Word 2002 template for my client and >have just run into the 25-entry limit trying to enter the [quoted text clipped - 9 lines] > >Any suggestions for either problem? Thanks in advance! Hi Brian, The dropdown from the Forms toolbar can't handle more than 25 items. Beyond that, the solution is a userform with a list box or a combo box. Here are a couple of articles to look at: http://support.microsoft.com/?kbid=306258 http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm For the e-mail problem, see http://www.word.mvps.org/FAQs/InterDev/SendMail.htm -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Jay, Thank you for the advice - these articles were helpful and I implemented a user form that looks like a "pop-up" by using the OnEntry macro. It's a little clunky, but it's the least intrusive workaround. Do you know if a future version of Word extends this limit? Or is this just one of those "use something else" situations? I almost used a User Form for the entire thing (and inserted into bookmarks at the end), but the client objected because their users are unsophisticated and would expect to see native Word. Brian >Hi Brian, > [quoted text clipped - 13 lines] >Microsoft Word MVP FAQ: http://word.mvps.org >. Hi Brian, Good to hear you got it working. There hasn't been any change in the capabilities of Forms dropdowns since they were first introduced up through the current Word 2003. I haven't heard of any plan to revise them in a future version, although I'd be delighted to be surprised. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org >Jay, > [quoted text clipped - 31 lines] >>Microsoft Word MVP FAQ: http://word.mvps.org >>. G'day "Brian" <brian.lucas.xxx@bigfoot.com>, The best way is to categorize the entries, then have two drop down boxes. The OnEntry event of the second drop down checks the value of the first and populates choices accordingly. Steve Hudson - Word Heretic steve from wordheretic.com (Email replies require payment) Without prejudice Brian reckoned: >I am creating an MS Word 2002 template for my client and >have just run into the 25-entry limit trying to enter the [quoted text clipped - 9 lines] > >Any suggestions for either problem? Thanks in advance! Steve, Thanks for this advice - it's the path I tried to take at the start, but the values really didn't subject themselves to categorization, and my client preferred one bigger list (even if it was a pop-up) to two smaller ones. Best regards, Brian >-----Original Message----- >G'day "Brian" <brian.lucas.xxx@bigfoot.com>, [quoted text clipped - 25 lines] > >. |
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.