RE: $$Excel-Macros$$ how to change language automatically

2010-11-20 Thread Daniel
Have a look here : http://msdn.microsoft.com/en-us/library/aa196237(office.11).aspx Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de ??? Envoyé : samedi 20 n

Re: $$Excel-Macros$$ Touble Adding Items to a Listbox on a userform

2010-11-20 Thread ashish koul
try this Sub a() Dim s As Worksheet For Each s In Worksheets UserForm1.ListBox2.AddItem s.Name Next s UserForm1.Show End Sub On Sat, Nov 20, 2010 at 4:10 AM, scaz wrote: > I'm having trouble adding the names of my worksheets to a listbox in a > userform I have created. > > Dim item > Dim frm A

$$Excel-Macros$$ Touble Adding Items to a Listbox on a userform

2010-11-20 Thread scaz
I'm having trouble adding the names of my worksheets to a listbox in a userform I have created. Dim item Dim frm As New BatchPrintForm For Each item In ThisWorkbook.Sheets With frm.SheetList .AddItem (item.Name) End With Next item If I put "MsgBox(item.Name)" after the line that

Re: $$Excel-Macros$$ How to attach file

2010-11-20 Thread siti Vi
Sorry for OOT.. Compose and Send your mail from your pc' GMail, not from the group web page. cmiiw On 11/19/10, Chandru wrote: > Hi, > How to attach file in this group > Thanks > > Chandra Shekar -- -- Some importa

Re: $$Excel-Macros$$ Need a MAXIF type formula

2010-11-20 Thread None
Thank you for this but this file is only an 07 file.  Unfortunately when you open the 03 application and a file created in 03 this doesn't work. Could something be wrong with my 03 application itself? From: ashish koul To: excel-macros@googlegroups.com Sent: