Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box with vertical scroll bar
Is there anyway I can add the vertical scroll bar to combo box?
The reason I am asking is because I have name range assigned to ..ListFillRange... property of the combo box but the user only see which fits on the computer screen but I want to display the vertical scrool bar so they can see and scroll the ones which doesnot fit. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box with vertical scroll bar
It should automatically appear when the list gets bigger that the 'ListRows'
property. UNLESS the 'Style' property isn't properly set. Make sure the 'Style' property is set to 'frmStyleDropDownCombo'. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VJ" wrote: Is there anyway I can add the vertical scroll bar to combo box? The reason I am asking is because I have name range assigned to .ListFillRange... property of the combo box but the user only see which fits on the computer screen but I want to display the vertical scrool bar so they can see and scroll the ones which doesnot fit. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box with vertical scroll bar
Hello Gary,
Thanks for your efforts. But it didn't work. My combo box alread has the style property set to 'frmStyleDropDownCombo'. Is this excel issue? Any trick I have to do programatically to make it dynamic big. "Gary Brown" wrote: It should automatically appear when the list gets bigger that the 'ListRows' property. UNLESS the 'Style' property isn't properly set. Make sure the 'Style' property is set to 'frmStyleDropDownCombo'. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VJ" wrote: Is there anyway I can add the vertical scroll bar to combo box? The reason I am asking is because I have name range assigned to .ListFillRange... property of the combo box but the user only see which fits on the computer screen but I want to display the vertical scrool bar so they can see and scroll the ones which doesnot fit. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box with vertical scroll bar
Hi Gary,
I recreated the combo box control from scratch. This time it seems fine. Do you know how can I set the number of rows to show instead of 10 to 20? I mean how can increase the number of rows a user can see while clicking on the combo box. I hope my question is clear. "VJ" wrote: Hello Gary, Thanks for your efforts. But it didn't work. My combo box alread has the style property set to 'frmStyleDropDownCombo'. Is this excel issue? Any trick I have to do programatically to make it dynamic big. "Gary Brown" wrote: It should automatically appear when the list gets bigger that the 'ListRows' property. UNLESS the 'Style' property isn't properly set. Make sure the 'Style' property is set to 'frmStyleDropDownCombo'. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VJ" wrote: Is there anyway I can add the vertical scroll bar to combo box? The reason I am asking is because I have name range assigned to .ListFillRange... property of the combo box but the user only see which fits on the computer screen but I want to display the vertical scrool bar so they can see and scroll the ones which doesnot fit. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box with vertical scroll bar
The 'ListRows' Property of the Combobox specifies the maximum number of rows
to display in the list. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VJ" wrote: Hi Gary, I recreated the combo box control from scratch. This time it seems fine. Do you know how can I set the number of rows to show instead of 10 to 20? I mean how can increase the number of rows a user can see while clicking on the combo box. I hope my question is clear. "VJ" wrote: Hello Gary, Thanks for your efforts. But it didn't work. My combo box alread has the style property set to 'frmStyleDropDownCombo'. Is this excel issue? Any trick I have to do programatically to make it dynamic big. "Gary Brown" wrote: It should automatically appear when the list gets bigger that the 'ListRows' property. UNLESS the 'Style' property isn't properly set. Make sure the 'Style' property is set to 'frmStyleDropDownCombo'. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VJ" wrote: Is there anyway I can add the vertical scroll bar to combo box? The reason I am asking is because I have name range assigned to .ListFillRange... property of the combo box but the user only see which fits on the computer screen but I want to display the vertical scrool bar so they can see and scroll the ones which doesnot fit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vertical scroll bar | Excel Discussion (Misc queries) | |||
vertical scroll bar scale | Excel Worksheet Functions | |||
Formatting the vertical scroll bar | Excel Discussion (Misc queries) | |||
Vertical Scroll Bar | Excel Worksheet Functions | |||
vertical scroll bar goes too far? | Excel Discussion (Misc queries) |