ComboBox Issue: Write to WorkSheet
Hi All
I have a ComboBox on a UserForm. The TextBoxes on the form are
populated according to the ComboBox selection, using the Change event
of the ComboBox.
The user can change the values in the ComboBox, and I want these
changes to be stored on a hidden worksheet so that these repopulate the
ComboBox when needed. I thought I'd change the ComboBox's
ControlSource on the AfterUpdate event, but by this stage ListIndex has
been lost (reverted to -1).
I've tried using other events, but am getting nowhere. Any
suggestions?
Thanks in advance
Paul Martin
Melbourne, Australia
|