I asked this over in news:microsoft.public.excel.programming and haven't seen a nibble on it yet, but maybe there's an excel guru lurking here? The title of this post is:
Confused Code: Wrong Visible Property Selection
----------------------
Maybe I'm not reading or coding this right, but anyway:

Got two ComboBox's named SortByStar and RotateByWhat

In the properties of each box, I've selected whether I want the ComboBox Visible:

SortByStar.Visible = True
RotateByWhat.Visible = False

Upon exiting design mode, the opposite happens, SortByStar becomes False, and RotateByWhat becomes True. Ok, what's going on. Hmm, I know, I'll set code into my startup to set the states of each ComboBox, (which also contains code to load the values for the box's). So:

SortByStar.AddItem "SP"
SortByStar.AddItem "SMK"
SortByStar.Visible = True
RotateByWhat.AddItem "HD"
RotateByWhat.AddItem "SAO"
RotateByWhat.Visible = False

And I'll be dipped in paint if the Box's FLICKER! and the opposite happens, SortByStar remains FALSE and RotateByWhat remains TRUE!

I'm very confused.


------------------
turbopoweredbylynx http://lynx.browser.org/