ComboBox or DrowDown Selection to ActiveCell
Posted by Al on December 26, 2001 2:10 PM
I am using the follwing simple VBA
Private Sub ComboBox1_Change()
ActiveCell.Value = ComboBox1.Value
and lets assume my ComboBox list includes
the problem i cant solve follows:
Say Im in A1 (active cell) and select "Orange" from the ComboBox or DropDown list, works fine so far. Next I go to A2 (new active cell) if I want this activecell
to be "Orange" again, first I have to select another item from the ComboBox list (either Pear or Apple) and come back to select "Orange" otherwise it wont work...probably a focus problem...Can anyone help me with this ??
this mailing list excellent !