View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Trouble with a ComboBox on a UserForm

I put this post in the general group and didn't get an answer; I am now
trying to find an answer in this group. Basically, I am encountering some
bizarre behavior from an Excel model. I have a ComboBox on a UserForm and it
works fine if this model is the only one open at the time I open the model.
If there is any other Excel SS open and running, before I open this
particular model with the ComboBox on the UserForm, the ComboBox will not
display any data in the drop down menu. As soon as I close any open SS, and
open the model again, the ComboBox works just fine! Ive been using Excel for
10 years or so...not exactly new to the scene but Ive never dealt with
this... What could possible cause this behavior? Why would a UserForm not be
able to load a ComboBox if other SS are open?

Regards,
Ryan--

--
RyGuy