Fieldcode IF
in [Word VBA]
|
From: Kjell Blomseth on 25 Mar 2010 03:06 Hello I am creating a schema where I want to autofill some information. In one line I have created a dropdown-list. Word has given the the list the bookmark-name List1. In the next line I have tried to create an "IF-question": { IF { List1 } = "Value x" "Textstring ..." } I had expected Word to fill in "Textstring ..." in the line, if I chose "Value x" from the drop-down-list. (Values in the drop-down-list will be company names, and values in the next lines will be their address. Any smarter solutions than IF-question?)
From: Graham Mayor on 25 Mar 2010 05:24 You may find http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm useful. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "Kjell Blomseth" <KjellBlomseth(a)discussions.microsoft.com> wrote in message news:4E3540DF-1FB3-43F9-8D55-F6B2B85DD1EF(a)microsoft.com... > Hello > I am creating a schema where I want to autofill some information. > > In one line I have created a dropdown-list. Word has given the the list > the > bookmark-name List1. > In the next line I have tried to create an "IF-question": > { IF { List1 } = "Value x" "Textstring ..." } > > I had expected Word to fill in "Textstring ..." in the line, if I chose > "Value x" from the drop-down-list. > > (Values in the drop-down-list will be company names, and values in the > next > lines will be their address. Any smarter solutions than IF-question?)
From: Peter Jamieson on 25 Mar 2010 06:24 If you're using on "online form" (with form fields in the document etc.), you will need to do at least the following: a. in the properties of the dropdown, check Calculate on Exit b. have a second form field c. after you have selected the value in the dropdown, exit the field. If you just have a protected form with two fields, that means (more or less) either clicking in another form field, or tabbing out of the dropdown field. (If you have unprotected sections in the document, clicking in the unprotected section may also "exit the field". However, then there is a problem, which is that if you click in the protected section after the last form field, Word will put the insertion point in the unprotected section without "exiting the field", and then nothing much will work until you go reselect the dropdown field and "exit the field" as in point (c).) Peter Jamieson http://tips.pjmsn.me.uk On 25/03/2010 07:06, Kjell Blomseth wrote: > Hello > I am creating a schema where I want to autofill some information. > > In one line I have created a dropdown-list. Word has given the the list the > bookmark-name List1. > In the next line I have tried to create an "IF-question": > { IF { List1 } = "Value x" "Textstring ..." } > > I had expected Word to fill in "Textstring ..." in the line, if I chose > "Value x" from the drop-down-list. > > (Values in the drop-down-list will be company names, and values in the next > lines will be their address. Any smarter solutions than IF-question?)
From: Kjell Blomseth on 25 Mar 2010 10:11 Hi You solved my problem, thx a lot! Kjell "Peter Jamieson" wrote: > If you're using on "online form" (with form fields in the document > etc.), you will need to do at least the following: > a. in the properties of the dropdown, check Calculate on Exit > b. have a second form field > c. after you have selected the value in the dropdown, exit the field. > If you just have a protected form with two fields, that means (more or > less) either clicking in another form field, or tabbing out of the > dropdown field. > > (If you have unprotected sections in the document, clicking in the > unprotected section may also "exit the field". However, then there is a > problem, which is that if you click in the protected section after the > last form field, Word will put the insertion point in the unprotected > section without "exiting the field", and then nothing much will work > until you go reselect the dropdown field and "exit the field" as in > point (c).) > > Peter Jamieson > > http://tips.pjmsn.me.uk > > On 25/03/2010 07:06, Kjell Blomseth wrote: > > Hello > > I am creating a schema where I want to autofill some information. > > > > In one line I have created a dropdown-list. Word has given the the list the > > bookmark-name List1. > > In the next line I have tried to create an "IF-question": > > { IF { List1 } = "Value x" "Textstring ..." } > > > > I had expected Word to fill in "Textstring ..." in the line, if I chose > > "Value x" from the drop-down-list. > > > > (Values in the drop-down-list will be company names, and values in the next > > lines will be their address. Any smarter solutions than IF-question?) > . >
From: Kjell Blomseth on 25 Mar 2010 10:12 Thx, I guess I can find a lot of useful information on your pages! Kjell "Graham Mayor" wrote: > You may find http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm useful. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > "Kjell Blomseth" <KjellBlomseth(a)discussions.microsoft.com> wrote in message > news:4E3540DF-1FB3-43F9-8D55-F6B2B85DD1EF(a)microsoft.com... > > Hello > > I am creating a schema where I want to autofill some information. > > > > In one line I have created a dropdown-list. Word has given the the list > > the > > bookmark-name List1. > > In the next line I have tried to create an "IF-question": > > { IF { List1 } = "Value x" "Textstring ..." } > > > > I had expected Word to fill in "Textstring ..." in the line, if I chose > > "Value x" from the drop-down-list. > > > > (Values in the drop-down-list will be company names, and values in the > > next > > lines will be their address. Any smarter solutions than IF-question?) > > > . >
|
Pages: 1 Prev: Insert value in cells and combined them Next: Task Pane and Word 2003 Template |