Excel API programming
 

I have craeted a VB6 combo box and successfully make it scrollable on
worksheet.
but it only display 8 rows by default.
Is there any solution for displaying more that 8 ows in dropdown
window?
anyone good at API? I have no idea about this, any suggestions will be
qppreciated:)

Excel API programming
 

Hi Frank,

wrote:
I have craeted a VB6 combo box and successfully make it scrollable on
worksheet.
but it only display 8 rows by default.
Is there any solution for displaying more that 8 ows in dropdown
window?
anyone good at API? I have no idea about this, any suggestions will be
qppreciated:)

No need for API calls on this. The ActiveX ComboBox control has a property
named ListRows. It defaults to 8, but you can change it either at design
time (via Properties in context menu) or at run time (via VBA code). If you
set it to a higher number, you should see that many rows displayed at a
time.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Excel API programming
 

You have created a custom control ?
If so, need to expose that functionality as a property of your control and
make the changes inside your control using the HWnd of the combo box :
http://vbnet.mvps.org/code/comboapi/comboheight.htm

NickHK

wrote in message
oups.com...
I have craeted a VB6 combo box and successfully make it scrollable on
worksheet.
but it only display 8 rows by default.
Is there any solution for displaying more that 8 ows in dropdown
window?
anyone good at API? I have no idea about this, any suggestions will be
qppreciated:)