Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

Update Textbox1 after combox easy help for beginner! Opzioni

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Textbox1.Value Question	PaulW	Excel Programming	2	December 5th 07 01:01 PM
Easy way to Hide & Show Rows and update associated macros	Eggtavius	Excel Discussion (Misc queries)	0	March 28th 07 03:05 AM
Easy way to Hide & Show Rows and update associated macros	Farhad	Excel Discussion (Misc queries)	0	March 28th 07 01:21 AM
TextBox1 to Label4	damorrison	Excel Discussion (Misc queries)	5	March 12th 06 04:05 PM
Is there an easy way to make Excel update Access, and vice versa?	Alen David	Excel Programming	7	March 3rd 06 09:26 PM

All times are GMT +1. The time now is 10:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us