 |
 | 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 / Tables / April 2005Adding Drop Down list numbers
I have a table that I am trying to add the values that display in the drop down list. I want to add cell #'s C4:C9 The whole table is bookmarked as SkillsTable. Each cell that is a drop down list box is individually bookmarked C4 - C9 Cell C4 bookmark is dropdownC4 Cell C5 bookmark is dropdownC5 Cell C5 bookmark is dropdownC6 Cell C5 bookmark is dropdownC7 Cell C5 bookmark is dropdownC8 Cell C5 bookmark is dropdownC9 Can anyone help? Hi =?Utf-8?B?U0xlZmV2ZXI=?=, I don't understand the question. I follow what you have (dropdowns in these table cells), and that you want to do something with their lists, but: 1. dropdowns from the Forms or the Controls Toolbox? 2. You want to add values using VBA (a macro)? Hard-coded values, or do you need to pick them up from somewhere? > I have a table that I am trying to add the values that display in the drop > down list. [quoted text clipped - 6 lines] > Cell C5 bookmark is dropdownC8 > Cell C5 bookmark is dropdownC9 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 :-) Cindy, 1. This is the drop downs from the Forms toolbar 2. I would prefer to add the values using the formula option under Tables. But if I have to create a macro what would the macro code be? And what is a hard-coded value? Thanks! > Hi =?Utf-8?B?U0xlZmV2ZXI=?=, > [quoted text clipped - 24 lines] > This reply is posted in the Newsgroup; please post any follow question or > reply in the newsgroup and not by e-mail :-) A calculation form field can sum the values of other form fields; be sure to check "Calculate on exit" in each of the form fields contributing to the calculation.  SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. > Cindy, > 1. This is the drop downs from the Forms toolbar [quoted text clipped - 31 lines] > > This reply is posted in the Newsgroup; please post any follow question or > > reply in the newsgroup and not by e-mail :-) Hi =?Utf-8?B?U0xlZmV2ZXI=?=, > 1. This is the drop downs from the Forms toolbar > 2. I would prefer to add the values using the formula option under Tables. > But if I have to create a macro what would the macro code be? And what is a > hard-coded value? As Suzanne said, you should be able, given these circumstances, to add them in a calculation type of form field. You can't use Table/Formula to create the equation, however, you'd need to enter it yourself. For example, to multiply two dropdowns named Qty1 and Price1: = Qty1 * Price1 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.