On Nov 27, 2006, at 3:37 PM, Tom Benson wrote:
Um Seth,
Make yourself an extends method that extends the listbox and does
this for you, or I can send you one.
Um Tom,
I have for quite a while and pasted code that does it right into the
email. Did you really not read that far into the em
U.. really should have read your email before sending mine in
hey... I just copied and pasted the solution out of my Extends Library.
Mine uses variant parameters though... ha!
Cheers,
Tom
On 28/11/2006, at 10:37 AM, Tom Benson wrote:
Um Seth,
Make yourself an extends method that exte
Um Seth,
Make yourself an extends method that extends the listbox and does
this for you, or I can send you one.
Sub AddLine Extends list as Listbox, ParamArray cells as variant
dim v as variant
dim currColumn as integer
list.addrow ""
for each v in cells
list.cell(list.lastind
Seth Willits
> It's out of the question to make an AddRow method that accepts a
> variable number of arguments or an array? It's like 10 lines of code!
> Actually, not "like," it is.
>
> Here let me help you out. This one's on the house, since I know it's
> pretty difficult to do:
>
>
> Sub AddRow(