View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin Paul Martin is offline
external usenet poster
 
Posts: 114
Default 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