Update Textbox1 after combox easy help for beginner!

[piditi]

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

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

 

[Doug Robbins - Word MVP]

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

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~~~~~~~~~~~~~~~...orm1.ComboBox1.Value End Sub[/QUOTE] [/QUOTE]

 

[piditi]

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

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