On a userform, a combobox with choices 1 through 10. I have the control
source set to sheet1!A10, but in the field A10, nothing happens until I leave
the focus from the combobox. So I have to click on some other control, or
close the form. I need my chooice from the combobox to take affect
immiedately, because it affects others controls on the form. Can this be
done?