Listbox alternative where there is no drop down

[ipbr21054]

On a userform is there say a Listbox where you dont click the drop down or maybe a setting you can change so the results are just shown ?
Example like attched image

 

[DanteAmor]

When activate the userform:

Private Sub UserForm_Activate()
  ComboBox1.DropDown
End Sub

When you mouse over the combobox

Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
  ComboBox1.DropDown
End Sub

Or you can put the data in the listbox and it will always be visible

 

[ipbr21054]

Is there a way to keep the ComboBox open.
I mean i have added the code as shown,

Private Sub UserForm_Activate()
  ComboBox1.DropDown
End Sub

But when i click in a Textbox it closes,i understand it opens when form is activated.
I generally select the Textboxes first then towards the end make a selction from ComboBox

Thanks

 

[DanteAmor]

But when i click in a Textbox it closes,i understand it opens when form is activated.
I generally select the Textboxes first then towards the end make a selction from ComboBox

Put this instruction back also in the change event

ComboBox1.DropDown

Or like I said, to always make them visible, use a list box.

 

[ipbr21054]

I used the same box so i didnt have to change lots of code.

If you mean like this its does the same thing & close when i click in a Textbox.

Private Sub UserForm_Change()
NameForDateEntryBox.DropDown
End Sub

 

[DanteAmor]

Then like I said, to always make them visible, use a list box.

 

[ipbr21054]

I will look into it as I can get names into listbox but looking to see how to populate it with date & item purchased as shown in first post.

 

[DanteAmor]

I don't understand you.

Simply make your listbox larger so that all the items can be seen

 

[ipbr21054]

When I tried it wasn’t the up & down issue but left & right
Will look tomorrow

 

[DanteAmor]

So that the data is always visible, use a Listbox instead of a combobox.
Make the litbox taller and longer