Drop-down Lists and Auto-Population

Hello,

I'm working on a Word (2007/2010) document and trying to create a table full 
of drop-down lists. I want to be able to select a value from each drop down, 
and have this selection show up later in the document. I've been plugging 
through VB trying to write this up, but I can't seem to set up a label or 
field that I can write a value to. For example, it would look something like 
this:
We've got a drop-down list at the top of the document, 3rd page and a 
label/text field on, say, page 6. User selects "Option 2" in the drop-down 
list. Instantly, the label/text field reads "Option 2".

How can I accomplish this?

Thank you very much for your time & assistance.
0
Utf
3/12/2010 4:09:01 PM
word.vba.general 1023 articles. 1 followers. Follow

1 Replies
1337 Views

Similar Articles

[PageSpeed] 50

Your identical post in the programming newsgroup has been answered.  Please 
do not post the same question separately to multiple newsgroups.

-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"muka3D" <muka3D@discussions.microsoft.com> wrote in message 
news:E2B4FEA0-A331-41F2-932C-B65158DCEBED@microsoft.com...
> Hello,
>
> I'm working on a Word (2007/2010) document and trying to create a table 
> full
> of drop-down lists. I want to be able to select a value from each drop 
> down,
> and have this selection show up later in the document. I've been plugging
> through VB trying to write this up, but I can't seem to set up a label or
> field that I can write a value to. For example, it would look something 
> like
> this:
> We've got a drop-down list at the top of the document, 3rd page and a
> label/text field on, say, page 6. User selects "Option 2" in the drop-down
> list. Instantly, the label/text field reads "Option 2".
>
> How can I accomplish this?
>
> Thank you very much for your time & assistance. 

0
Doug
3/12/2010 9:18:39 PM
Reply:

Similar Artilces:

Marketing list fails???
Hi, I could see that when use the last two options to select accouns or contacts to integrate to a list, this "advance search" fails, this does'nt find nothing.... it's possible??? thanks in advance sorry, the functionality goes right, It was my error,this two types of search it's about existing accounts inside marketing list and not includes accounts outside list. thanks "Marcos" wrote: > Hi, > > I could see that when use the last two options to select accouns or contacts > to integrate to a list, this "advance search" fails, ...

Count if criteria is part of list
Want to be able to count all value in particular range that have a value that appear in list of multiple values eg have spreadsheet all different types computers and what versions of o/s and service pack they are running eg Sheet 1 A B Windows XP Professional SP2 Dell Inc. Windows XP Professional SP2 Dell Inc. Windows 2000 Professional SP4 Compaq Windows 2000 Professional SP4 Dell Inc. Windows 2000 Professional SP4 Dell Inc. Windows 98 sr2 ...

Moderated Distribution Lists? Public Folders?
I have an Exchange 2003 Distribution List that has a bunch of email addresses. My boss has this moderated so only certain people are allowed to send to it... set in Exchange Properties. Unauthorized users that send to it get an NDR. Right now if someone needs to send to it... we have to temporarily add them to the list... they send... then we have to remove. This is time consuming and not practical. Is there any way to make this moderation process automatic. Ideally... I would want someone to send to the list... then the "list owner" would get an email to either appro...

How to create Auto Regenerating Dropboxs in data entry forms
I'm trying to create an auto generating drop box on a data entry form. That is, someone would be entering data that may pertain to more that one project. I'd like to have a drop down menu that, once a value is selected from it, an exact duplicate appears underneath, and the user can enter as many projects as are associated with that data. I'm not sure how to do this. Make your combo box an unbound control. In the After Update event of the combo, set the Default Value of the control you want to populate to the value in the combo. I am assuming the combo is on the main fo...

Auto Sort #3
I have a chart that the range is A9:AR25 with the headings being in ro 8(A8:AR8). I am trying to find out how I can have this char automatically sort the data when a new value is entered, sort first b column AR, if tied then by column AI and finally if still tied b column AO -- Message posted from http://www.ExcelForum.com record a macro of your sort and then place within a worksheet change event in the sheet module -- Don Guillett SalesAid Software donaldb@281.com "Rob04 >" <<Rob04.163lpk@excelforum-nospam.com> wrote in message news:Rob04.163lpk@excelforum-nospam.co...

Distribution List Conflict
I set up a distribution list in Outlook and gave it a name. Then I needed to remove one email address from the distribution list. Since I couldn't figure out how to remove one email address from the list, I just deleted the list and created a new list using the same name. My outlook auto-fills previously entered email addresses in the To field and now whenever it auto-fills the distribution list name, it says that distribution list is no longer valid. This is most likely happening because the distribution list I deleted had the same name as the new one I replaced it wit...

Outlook [To] List (aka Select Names) Dialog
I installed NewsHound as recommended on .... http://www.outlook-tips.net/howto/news.htm NewsHound works OK, except for one annoying problem. Whenever I use [To] for email (or any of the other post address options), the "Select Names" dialog opens with the Newsgroup List instead of Contacts List. I have to use the dropdown and manually select Contacts. Is there a way to set Contacts as default list in the "Select Names" dialog? And, yes, I've contacted NewsHound Support and still waiting answer. -- =============== Master Blaster Computer System Specialist IT ...

Two stores listed in System Configuration folder
Hello, We migrated from an Exchange 5.5 single-server installation to a Exchange 2003 single-server installation. We think we have correctly moved all data and roles to the new exchange 2003 server. We have been using the 2003 for over 6 months with no problems. Our old server is still listed under the "Servers" folder but we don't see much more evidence of the old server than that. We are ready to delete the old 5.5 server from the directory following the instructions in the MS KB articles. The physical server is no longer available. My question/concern is this: Under ...

How do I create a list in excel that contains external data?
I have spreadsheets linked to external data sources but I also need to add data to them. Whenever the data source is refreshed rows are correctly added or deleted from the columns containing external data but not from the columns containing my data. My rows end up not corresponding to the external data rows. I thought designating the entire data range as alist might help but I recieved an error that says you can't make a list that contains external data. Any one have suggestions? You could store the related data on a separate sheet. Then, on the worksheet with the external data...

Money auto-assign category to downloaded transactions
It's happened several times, but I can't quite pinpoint the trigger to it. Every now and then, when I download transactions into Money, it random assigns a category to all the transactions, and the category is the same one. For example, just earlier today, every transactions downloaded was assigned "automobile" as the category. I have tried different options under Tools - Setting - Online Sevices Setting, but I can't quite figure out how to prevent this from happening. Any idea? In microsoft.public.money, namsilat wrote: >It's happened several times, but I can&#...

Global Address List and a Shared Contact List
Thank you in advance! I continue to have communication problems with e-mail stemming from the fact that we have two locations for Our Staff in Outlook 2000(Exchange). We have one listed in what is called the "Global Address List" and another, more accurate version, in "Our Staff" listed under "Public Folders". When someone wants to write a new e-mail, the "To" in their dialogue box directs them to what is now the default "Global Address List" that contains a Staff listing that is not as up to date or accurate. I attempted to add same today...

Field Population
I am familiar with using an Access database and populating fields in Word, can you do the same thing in Excel. -- S Sharon Not really sure what you mean but is Data>Form... what you are looking for? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Sharon" <Sharon@discussions.microsoft.com> wrote in message news:85EE58F8-4BD5-4AD4-B40C-3B9792FDC8EF@microsoft.com... >I am familiar with using an Access database and populating fields in Word, > can you do the same thing in Excel. > -- >...

Problems with Auto Forward on SBS 2003
I'm try to add a distribution Group/List under "Exchange General> Delivery Options> Forward to:" on a Small Business Server 2003 When I click on the modify button next to the "Forward to:" field I can only see "other objects" and "users" under "Object Types" field. I can't see the distribution list I created... Is this because it is Small Business Surver 2003??? Any help would be appritiated! Thanks Hi, no, have you used "Exchange tasks" to set the e-mail address on the distribution list? Only "mail-enab...

how to write updated list to excel without having to close the browser first?
Hi, this code writes a single line to an excel sheet followed by a list of names coming from a table in the database. The table is chosen from a dropdownlist. This works properly. My problem is: suppose i wrote all the names of a table to excel. Then i return to the main menu of the application without closing the browser. Suppose now that the same table with the names is updated (e.g. by another user who adds some new names). If i start this code below again and then opening the new excel sheet (or first saving on my desktop), i see exactly the same names as the previous ti...

How do you create a drop-down menu within a cell in Excel?
How do you create a drop-down menu within a cell in Excel? You can use data validation. There are instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html Jimmy wrote: > How do you create a drop-down menu within a cell in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

Drop Cap
Every time I ry to drop a cap at the beginning o a nw chapter, it puts it on top of the text instead of beside it were it should be. What do I need to do to fix this Which option are you choosing when you create the drop cap? Note that in order to set drop cap options, you can right-click the border of the drop cap and then click the Drop Cap command on the context menu. -- Stefan Blom Microsoft Word MVP "Carl F" <Carl F@discussions.microsoft.com> wrote in message news:11C4D8F3-3641-4055-8B07-AD41EF35E138@microsoft.com... > Every time I ry to drop ...

Auto colour based on adjacent cell
How to set cell color automatically based on the color of another cell How does the first cell get coloured? By Conditional formatting or manually? If by conditional formatting then use he same conditin=ons to change the second cell. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "crapit" <biggercrap@yahoo.com> wrote in message news:ul4qozZFJHA.3996@TK2MSFTNGP03.phx.gbl... > How to set cell color automatically based on the color of another cell > &g...

Populate empty fields with a number
I have a a column which has 3 possibilites, 1,2 or 3. I have already populated fields with either a 1 or 2 based on another query. I wish to populate the remainder of fields which have no content with 3. I have tried to write the query as UPDATE dbase SET dbase.[field] = 3 WHERE dbase.[field] <> 1 AND <> 2. But this doesn't work, and have tried UPDATE dbase SET dbase.[field] = 3 WHERE dbase.[field] = "", and this doesn't work either. Data type mismatch occurs on last query. Any help would be great? Cheers -- Paul Wilson Paul, You might try: UPDATE dbas...

Auto fill cell addresses by not 1
Hi folks, Is there a way to auto-increment the cell address in a formula by an increment other than 1. For example by 15: =Fubar(A1,A2) =Fubar(A16,A17) =Fubar(A31,A32) : : : I have rather complex formulas that point to data on another excel sheet where the data is organize into blocks (it is generated by another program) rather than in nice sequential columns. Having to manual enter the cell addresses for 200 rows is a PITA! Cheers, Peter How about a little work? Say I want the formula in row 1 (say E1). I'd put this formula in E1: ="$$$=Fubar(a" & (...

Outlook 2003 Auto Send/Receive #2
Hi, i need help please, In my Outlook 2003 the Auto Send/Receive stopped working, to check my mails i have to manually click on send/receive so that i receive emails. I did check all the necessary options, and all are OK. and i did check to see if Work Offline is checked and its not. the Include this group in send/receive is checked, and Schedule an automatic send/receive every 10 min. is checked. I use regular POP3 mail with windows xp sp2. please if someone can help me solve this problem of mine. Thank you -- hyewiz With Outlook closed, find and delete the .srs file you will find us...

outlook 2003 and Exchange 5.5 (client drops to offline)
I have a number of workstations that are using outlook 2003 without any problem. However I have one workstation that continues to drop to offline mode and cannot send or recieve may. I uncheck the offline mode and then it goes in connected mode for about 10 minutes and then fails again. It then asks for username and password which it rejects, even using administrator. Anyone have any suggestions on how to troubleshoot this one? Thanks Scott Checked the physical connection already? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Properly back-up and ...

Exchange 2003 Public Folder NDR Loop on Auto Reply
Problem: A specific public folder is set to collect resumes of employment candidates that respond to job posted in local newspapers. Occasionally, spammers email in to the public folder with a legitimate reply domain.com but a non-existant username@domain.com. Because the server name is legit but the user isn't, the "Thank you for sending your resume." reply bounces off that server and it sends the public folder an NDR. The Public Folder interperates this as another inbound resume and resends the "Thank you", which in turn generates another NDR. This happens up t...

Import Master Category List in Outlook 2003 ?
I asked this in microsoft.public.outlook.general but did not receive a reply : Can anyone tell me how to import the Master Category List from my old installation of Outlook 2003 into my new install of the same version ? I exported everything else into a .pst file and got all my contacts etc but the Category List doesn't 't seem to be included ? Many thanks, Mike Probably a result of the import. Importing a .PST file does two things: A. You lose the following information: 1. Custom Forms 2. Custom Views 3. Connections between contacts and activities 4. Received dates on mail...

Not Auto-forwarding Spam Filtered by SpamBayes
I'm using SpamBayes on Outlook 2000 for Exchange Server. I have set an auto-forwarding rule. Currently this rule, forwards all the messages including Certain Spam and Possible Spam messages as identified by SpamBayes to another e-mail address. I would, however, like to modify this rule such that Certain Spam will not be forwarded? Is there a way? ...

Folder List
The folder list for 3 users are out of order. All of the folders are listed alphebetically except for Outlook Today - [Mailbox - User] which "all of a sudden" is placed at the end of the list...any suggestions? ...