Updating a Named range Automatically
I'm assuming that the macro updates the data in the range, so at this
point it can reference the combobox - with another one of the bits of
code that looks a bit silly -
ComboBox1.RowSource = ComboBox1.RowSource
this will cause the data to refresh.
|