Update textbox based on ComboBox

[staples]

Hi there

I have a macro which updates a textbox based on the selelction in the combobox. The macro is currently set up to change the textbox on "worksheet change" which means I can only make the text box update by altering the worksheet after making the selection on the combobox.

Eg, make selection from combobox, however this makes no change to the textbox. So, I need to then double clicking into a cell then pressing enter for example which then updates the text box.

Is there a line of code I can use to make the textbox update as soon as the user makes a selection from the comobobox.

Please Login or Register  to view this content.

Thanks

[D_Rennie]

Hello.

Using controlls on the sheet should be easer using active x controls.

place the two active x controlls on the sheet and try this code.

Please Login or Register  to view this content.

cheers

[staples]

Hi there, thanks for the reply

What do you mean by active x controls/place two active x controls on the sheet?

Thanks

[staples]

hi again,

do you mean using a combo box from the "control toolbax" instead of "forms"? If so, I am not very good with these and don't even know how to add items to the dropdown list. any help would be great

thanks again

[D_Rennie]

in x 2007 on the developer ribbon cilck insert and under the heading active x insert the combobox.

then its just like using then in a userform.
using the drop button click event

Please Login or Register  to view this content.

hope this helps
cheers