ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List Box Row Source (https://www.excelbanter.com/excel-programming/365215-list-box-row-source.html)

jhahes[_62_]

List Box Row Source
 

Can someone please help me with a code that puts

the row source of the list box to the activecell


listbox1.rowsource =


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=555016


Bob Phillips

List Box Row Source
 
listbox1.rowsource = Worksheets("Sheet1").Range("A1:A10").Address(,,,Tr ue)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jhahes" wrote in
message ...

Can someone please help me with a code that puts

the row source of the list box to the activecell


listbox1.rowsource =


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:

http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=555016





All times are GMT +1. The time now is 10:34 AM.

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