If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Referencing a User Form using an If statement field code
Word 2007
I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
#2
|
|||
|
|||
Referencing a User Form using an If statement field code
The way I would do this would be to have the term Vendor or Vendors appear
as a result of the value assigned to a document variable and use a { DOCVARIABLE } in the document where ever the term is to appear. -- 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 "Brenda A. Reid" wrote in message ... Word 2007 I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
#3
|
|||
|
|||
Referencing a User Form using an If statement field code
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 "Brenda A. Reid" wrote in message ... Word 2007 I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
Thread Tools | |
Display Modes | |
|
|