ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A form combobox with list style as options. (https://www.excelbanter.com/excel-programming/420977-form-combobox-list-style-options.html)

Sagar Gurao

A form combobox with list style as options.
 
I have an activeX combobox with its list style property as
'frmListStyleOption' which I need to convert into form combobox control. Is
there any way by which we can get the effect of 'frmListStyleOption' property
in form combobox?

I appreciate your immediate response.

Thanks,
Sagar.

JLGWhiz

A form combobox with list style as options.
 
You can access the properties window by right clicking the combobox while in
design mode. If your combobox is on the worksheet, go to
ViewToolBarsControl Toolbox then click the icon in the upper left corner of
the tool box. It is in design mode when the icon is highlighted.

If the combobox is on a UserForm then open the VBE Alt + F11. Select the
UserForm from the Project window by double clicking it. If the properties
window does not automatically appear at the lower left of the screen, then
click ViewProperty Window.

Once you have the property window open, find List Style in the properties
list and click on the right hand side of that entry for a drop down option.
Select either fmListStylePlain or fmListStyleOption.

"Sagar Gurao" wrote:

I have an activeX combobox with its list style property as
'frmListStyleOption' which I need to convert into form combobox control. Is
there any way by which we can get the effect of 'frmListStyleOption' property
in form combobox?

I appreciate your immediate response.

Thanks,
Sagar.



All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com