Quirk selects invisible ComboBox when clicking nearby visible Command Button

[AnthK]

Hi everyone.
I have an issue that I have been trying to figure out and it seems to be a bug in excel maybe?

So I have a userform which displays a heap of data from a Table that is located on a worksheet.
The user selects a record through a series of ComboBoxes.
Once chosen - those ComboBoxes are made invisible and the data is displayed (other controls become visible)
The data includes command buttons which will allow the user to click to select a new related record.
The command button essentially reloads the data in the ComboBoxes while they are invisible to display the new record.
The only issue is that when the new record is displayed - the invisible ComboBox that was located on top of the command button will be displayed with its selected value.
I then need to click somewhere on the userform to get it to disappear.

So I assume that there is something going on here due to the Z-order given that the controls occupy the same space on the form but I would have thought that being invisible - the control shouldn't be able to be displayed?

If anyone has any previous experience with this or thoughts I would love to hear!

Thanks,

Anthony

 

[AnthK]

Sorry I should clarify - when I say that the invisible ComboBox is displayed - it only displays the currently selected item from the listbox component. The textbox component and all other entries of the listbox are not visible - just the element that has (for example) ComboBox1.Selected(4) = True.
I have forced the visible property = true then false but all that happens is it displays the rest of the ComboBox then hides it again - still with the selected value!

 

[Micron]

I've never seen this behaviour. If it's only with one combo, try increasing the list width property (it may be 0 at present) or leave it at 0 and increase the control width. I think the z order shouldn't matter if controls in the stack are invisible. You could also try setting the focus to some other control or perhaps try userform.Repaint