Hi All,
I am trying to write a VBA script in Excel to automate some data analysis. I am familiar with VB and VBA (not an expert but seasoned). I can't get the ImageCombo box to work properly with a multipage object.
I've narrowed the problem down to the "visibile" property of the ImageCombo box... You can not populate the ImageCombo box when it is not visible (visible set to false or on an inactive multipage page)... Additionally, if you do populate it when it is visible then make it invisible (set property to false or change multipage page) the data in the box disappears! However, it still seems to be populated as the ImageCombo1.ComboItems.Count value still equals the number of items in it.
I have looked everwhere I could find on the net to see if it's something I am doing wrong or if it is a known problem... I couldn't find anyone who described the same/similar problem.
Attached is a sheet that contains a form/code that shows what I am describing. Has anyone run into a similar problem? Anyone know of a solution? Any help would be appreciated. Thanks in advance!