Re: listbox.addrow easily support multiple column input (WE ALREADY HAD A SOLUTION)

2006-11-27 Thread Seth Willits
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

Re: listbox.addrow easily support multiple column input (blushes)

2006-11-27 Thread Tom Benson
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

Re: listbox.addrow easily support multiple column input (SOLUTION)

2006-11-27 Thread Tom Benson
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

RE: listbox.addrow easily support multiple column input

2006-11-27 Thread Carlos M
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(