ExcelBanter - form combobox auto expand

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - form combobox auto expand (https://www.excelbanter.com/excel-programming/438849-form-combobox-auto-expand.html)

Avi

form combobox auto expand

hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.

Jeff

form combobox auto expand

Private Sub ComboBox1_Enter()
Me.ComboBox1.DropDown
End Sub

"Avi" wrote:

hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.
.

Avi

form combobox auto expand

Thanks Jeff.

On Jan 26, 3:54*pm, Jeff wrote:
Private Sub ComboBox1_Enter()
* *Me.ComboBox1.DropDown
End Sub

"Avi" wrote:
hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.
.- Hide quoted text -

- Show quoted text -

All times are GMT +1. The time now is 11:13 PM.