ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listview in Excel 97 vba. (https://www.excelbanter.com/excel-programming/286633-listview-excel-97-vba.html)

jaxrpc

Listview in Excel 97 vba.
 
Hi , how do i draw a Listview onto the userForm of Excel 97 vba?
I can drag and draw a commandbutton but can't find a way for listview.


thanks


---
Message posted from http://www.ExcelForum.com/


Rob van Gelder[_4_]

Listview in Excel 97 vba.
 
First make sure that you have the ListView control available.
From VB IDE, Tools menu, Additional Controls: Microsoft ListView Control.

Rob


"jaxrpc" wrote in message
...
Hi , how do i draw a Listview onto the userForm of Excel 97 vba?
I can drag and draw a commandbutton but can't find a way for listview.


thanks


---
Message posted from http://www.ExcelForum.com/




jaxrpc[_2_]

Listview in Excel 97 vba.
 
hmmm.. what about i have the control on the comp that i am developing my
vba and i transfer the excel workbook to another computer running
windows 95 with office 97 without the vb ide, will i be able to run
it?

thanks plenty


---
Message posted from http://www.ExcelForum.com/


Tom Ogilvy

Listview in Excel 97 vba.
 
Not unless you install it on that computer or that computer already has it.
Many controls are listed in the list of controls, but you don't necessarily
have a legal right to use them in your application and distribute them. The
list of controls really only lists what is installed on your computer. The
listview control isn't distributed with the standard and professional
versions of office and I don't know what is required to distribute it. For
sure, if you own VB (the application), then you should be able to use and
distribute this control.

--
Regards,
Tom Ogilvy





jaxrpc wrote in message
...
hmmm.. what about i have the control on the comp that i am developing my
vba and i transfer the excel workbook to another computer running
windows 95 with office 97 without the vb ide, will i be able to run
it?

thanks plenty


---
Message posted from http://www.ExcelForum.com/





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

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