Textbox value = Combobox value

[mosiki]

Hi

I'm sure this will be simple for the majority proficient in VBA, however, as newbie to the VBA world I need a quick fix.

I have a textbox named "Team". I have a Combibox named "Combibox1".

Combibox1 list is taken from a range of cells from a worksheet.

Eg. Lets say combibox1 list is the alphabet a.....z.

If i select "c" for the value in combibox1 what code do i need so that the textbox "Team" will equal "c", and change to match the combibox1 value every time a different value is selected from the list. Is this even possible or would I be better using 2 combiboxes or some other control form combination?

Thanks

Mosiki

 

[Diablo II]

Re: Textbox value = Combibox value

try this

Private Sub ComboBox1_Change()
TextTeam = ComboBox1.Value
End Sub

 

[mosiki]

Re: Textbox value = Combibox value

no joy.

I've also tried:

Team.Value = Combobox1.Value
Team.Text = Combobox1.Value

maybe there are entries on the properties paramaeters i need to adjust for the textbox?

Mosiki

 

[james_lankford]

Re: Textbox value = Combibox value

does your combobox have a LinkedCell property?
is, so, set that property to the Team cell
then no code is required

 

[mosiki]

Re: Textbox value = Combibox value

No, maybe I should also have mentioned that these are on 2 different userforms.


The combobox is on the first userform "TeamSelect", i make a selection on the drop down menu and click ok.

The code for click ok is :

Unload TeamSelect
DataInput.Show

This then opens the userform "DataInput", where the textbox "Team" resides.

Thanks

Mosiki

 

[Diablo II]

Re: Textbox value = Combibox value

Private Sub ComboBox1_Change()
UserForm1.TextTeam = UserForm2.ComboBox1.Value
End Sub
Private Sub CommandButton1_Click()
 Unload UserForm2
UserForm1.Show
End Sub

 

[mosiki]

still no joy. Thanks for the input all the same.

 

[Diablo II]

did you change the names to mach your userforms and textboxs and combobox names?

 

[Diablo II]

if you textbox name is only team rename it TextTeam