Update Textbox1 after combox easy help for beginner!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

piditi - 22 Feb 2008 05:50 GMT

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

Reply to this Message

Greg Maxey - 22 Feb 2008 06:44 GMT

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

Signature

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

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

> I want only that after I choose in the Combobox1 one value in the
> textbox1 appear automatically this value!
[quoted text clipped - 10 lines]
> UserForm1.TextBox1.Text = UserForm1.ComboBox1.Value
> End Sub

Reply to this Message

Doug Robbins - Word MVP - 22 Feb 2008 09:15 GMT

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

Signature

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?
[quoted text clipped - 13 lines]
>> UserForm1.TextBox1.Text = UserForm1.ComboBox1.Value
>> End Sub

Reply to this Message

piditi - 22 Feb 2008 14:29 GMT

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

Reply to this Message