A form combobox with list style as options.

[Sagar Gurao]

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]

You can access the properties window by right clicking the combobox while in
design mode. If your combobox is on the worksheet, go to
View>ToolBars>Control 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 View>Property 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.