Re: Pass ListBox Values into TextBox1 Field
- From: "Doug Robbins - Word MVP" <dkr@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 Jun 2008 18:53:56 +1000
Using
ActiveDocument.FormFields("TextBox1").Result = ListBox1.Value
will set the .Result of the TextBox1 formfield to the value of the item that
is in the BoundColumn of the currently selected item in the ListBox1
--
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
"joesmithf1" <joesmithf1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9D4C66D0-9010-4D25-8398-DC42127DE244@xxxxxxxxxxxxxxxx
Ok...I have a MS Words form. I created a textbox in this form.
The other thing that I have is a "UserForm" with a listbox.
When an user select any one value from this listbox, I want that value to
populate the "textbox".
Here are my codes(in UserForm):
Private Sub CommandButton1_Click()
ActiveDocument.FormFields("TextBox1").Result = Me.ListBox1.Text
Unload Me
End Sub
WHen I run this, I get an '5941' error message. Please advise what I am
doing wrong.
Thank you.
Joe
.
- Prev by Date: Re: Track Changes VBA Granular information needed
- Next by Date: Re: Track Changes VBA Granular information needed
- Previous by thread: Autotext - set the 'Look In' drop down to a specific template
- Next by thread: Re: Using VBA to create a formula
- Index(es):
Loading