Update Textbox1 after combox easy help for beginner!

I want only that after I choose in the Combobox1 one value in the
textbox1 appear automatically this value!
I know it s a stupid question...I'm starting know to work with WBA and
so I' reading a lot!

Sub MACRO22()
UserForm1.Show
UserForm1.ComboBox1.RowSource =
ThisWorkbook.Worksheets("Foglio1").Range("A1:A3").Address(External:=True)
End Sub

Private Sub ComboBox1_AfterUpdate()
UserForm1.TextBox1.Text = UserForm1.ComboBox1.Value
End Sub

Greg
Thu Feb 21 22:44:44 PST 2008

At the risk of the the courtesy cop issuing another citation, I have to ask
... Are you posting a question or just gibberish?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~



piditi wrote:
> I want only that after I choose in the Combobox1 one value in the
> textbox1 appear automatically this value!
> I know it s a stupid question...I'm starting know to work with WBA and
> so I' reading a lot!
>
> Sub MACRO22()
> UserForm1.Show
> UserForm1.ComboBox1.RowSource =
> ThisWorkbook.Worksheets("Foglio1").Range("A1:A3").Address(External:=True)
> End Sub
>
> Private Sub ComboBox1_AfterUpdate()
> UserForm1.TextBox1.Text = UserForm1.ComboBox1.Value
> End Sub

Doug
Fri Feb 22 01:15:57 PST 2008

Also seems to be working with Excel, so wrong newsgroup.

--
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

"Greg Maxey" <gmaxey@mvps.oSCARrOMEOgOLF> wrote in message
news:uePkl5RdIHA.5448@TK2MSFTNGP03.phx.gbl...
> At the risk of the the courtesy cop issuing another citation, I have to
> ask ... Are you posting a question or just gibberish?
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Greg Maxey - Word MVP
>
> My web site http://gregmaxey.mvps.org
> Word MVP web site http://word.mvps.org
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> piditi wrote:
>> I want only that after I choose in the Combobox1 one value in the
>> textbox1 appear automatically this value!
>> I know it s a stupid question...I'm starting know to work with WBA and
>> so I' reading a lot!
>>
>> Sub MACRO22()
>> UserForm1.Show
>> UserForm1.ComboBox1.RowSource =
>> ThisWorkbook.Worksheets("Foglio1").Range("A1:A3").Address(External:=True)
>> End Sub
>>
>> Private Sub ComboBox1_AfterUpdate()
>> UserForm1.TextBox1.Text = UserForm1.ComboBox1.Value
>> End Sub
>
>

piditi
Fri Feb 22 06:29:51 PST 2008

On 21 Feb, 23:50, piditi <pid...@gmail.com> wrote:
> I want only that after I choose in the Combobox1 one value in the
> textbox1 appear automatically this value!
> I know it s a stupid question...I'm starting know to work with WBA and
> so I' reading a lot!
>
> Sub MACRO22()
> =A0 =A0 UserForm1.Show
> =A0 =A0 UserForm1.ComboBox1.RowSource =3D
> ThisWorkbook.Worksheets("Foglio1").Range("A1:A3").Address(External:=3DTrue=
)
> End Sub
>
> Private Sub ComboBox1_AfterUpdate()
> =A0 =A0UserForm1.TextBox1.Text =3D UserForm1.ComboBox1.Value
> End Sub

Ops sorry!!!
Thanks!I confuse the group!