You may want to open the Excel worksheet as a standard ADO recordset: see the sample below... a snippet from a large class module we often use here...
Giorgio Vidali
Director of Software Development
Automated Business Designs, Inc.
Public Function RecordsetGet(FromExcelFileName As String...
Following is a simple module that allows you to resize the drop down portion of a combobox. If I understood correctly... this is what you were looking for...
Call the sub "ComboSetDropdownWidth" in your Form_Load ev
ent, and pass the width (in pixels) that you require...
Hope this...
Well, seems to me that what you need is the very good PrettyCode.Print Add-In available here:
http://www.vbcity.com/page.asp?p=home
It is free, works like a charm, it is often updated. Have been using for a while and cannot do without it anymore.
Giorgio
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.