G
Guest
Hi;
Appreciate if someone could help me with the following:
An user form with the list box selection list will be prompted when I click
on the "Bank" field. The bank selection list differs when I select different
country. However, there are some countries that do not have the bank
associated with it, and I want the user to key in the bank name manually.
Please advice whether there is a way for the word to prompt out a list box
when I select the country called "Malaysia", "Singapore" and "UK", and prompt
out a text box for the user key in their bank name manually when I select a
country called " Taiwan", "China" and etc.
Or else, if I add in another text box into the user form, can the bank field
being configured to capture the text box info when the user key in the bank
detail into the text box?
Below is the code that is currently in place when I click on the "OK" button
now:
Private Sub OK_Click()
ActiveDocument.FormFields("BankName").Result = Me.BankName.Text
ActiveDocument.Bookmarks("BankName").Range.Fields(1).Result.Select
Unload Me
End Sub
Note: BankName is the name given to the list box, while BankName1 is the
name given to the text box. Is there a way to configure the form to either
capture the BankName or BankName1 info into the Bank field?
Appreciate if someone could help me with the following:
An user form with the list box selection list will be prompted when I click
on the "Bank" field. The bank selection list differs when I select different
country. However, there are some countries that do not have the bank
associated with it, and I want the user to key in the bank name manually.
Please advice whether there is a way for the word to prompt out a list box
when I select the country called "Malaysia", "Singapore" and "UK", and prompt
out a text box for the user key in their bank name manually when I select a
country called " Taiwan", "China" and etc.
Or else, if I add in another text box into the user form, can the bank field
being configured to capture the text box info when the user key in the bank
detail into the text box?
Below is the code that is currently in place when I click on the "OK" button
now:
Private Sub OK_Click()
ActiveDocument.FormFields("BankName").Result = Me.BankName.Text
ActiveDocument.Bookmarks("BankName").Range.Fields(1).Result.Select
Unload Me
End Sub
Note: BankName is the name given to the list box, while BankName1 is the
name given to the text box. Is there a way to configure the form to either
capture the BankName or BankName1 info into the Bank field?