When I edit or programmatically sort the data associated with the ComboBox Property LinkFillRange excel automatically executes the ComboBox action following my update or sort.
Is there a way in VBA to turn off this automatic updating while I am performing my updates or programmatically sorting? I tried turning off screen updating but that didn't work.
Thanks in advance for your help.
John
Is there a way in VBA to turn off this automatic updating while I am performing my updates or programmatically sorting? I tried turning off screen updating but that didn't work.
Thanks in advance for your help.
John