$$Excel-Macros$$ Fwd: VBA help needed

2009-05-17 Thread Harmeet Singh
-- Forwarded message -- From: Nihar Turakhia Date: Mon, May 18, 2009 at 12:47 AM Subject: VBA help needed To: harmeet.hew...@gmail.com Harmeet, I've just started learning vba and stuck rightnow with something. Any help will be greatly appreciated. I receive the daily settleme

$$Excel-Macros$$ Re: E Book on Excel.

2009-05-17 Thread maulik desai
Hi enyone having Ebook for Excel VBA i want to learn VBA so if anyone having Excel VBA Ebook pls Attach it so i can help me to learn VBA Thanks Maulik On Sat, May 9, 2009 at 9:57 AM, hari kumar wrote: > Hi Prateek, > > FYI. > This book covers basics. if need more details or advanced, let me kn

$$Excel-Macros$$ Batch copy sheet data from multiple files

2009-05-17 Thread Financeguy
I would like to execute a batch routine using VBA from an Excel file, to be able to call various Excel files in a folder and copy cells from sheet name assumptions range A1:Z1000 into a new tab from where I am executing the batch.The objective is to pull data from multiple files in a folder in

$$Excel-Macros$$ Re: Function list in diffrent language

2009-05-17 Thread anderspe
Thanks this was exact what i was looking for. // Anders On 15 Maj, 21:26, Fabio Lemos wrote: > Hi, > I wish this could help many people... > > Regards. > > 2009/5/15 anderspe > > > > > In Swedish version the function have one name, > > In English it have a new name. > > > Is there a way of tel

$$Excel-Macros$$ Re: formula in macros

2009-05-17 Thread kumar
Type the belomentioned line next to total cell =SUMIF($A$1:$A$10,"Sub Total",B1:B10) -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Habeeb Mohammed Sent: Thursday, May 14, 2009 9:34 PM To: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ Re:

2009-05-17 Thread Fabio Lemos
No, but you can create a OK messagebox like you create the form... 2009/5/16 Alokeshwar Tiwary > Hi All, > > > Is there a way to change color of a message box back ground and font? > > Please see attached. I want the OK message box to be in same color as the > userform. > > > > Thanks in antici

$$Excel-Macros$$ Copy, past and move down one cell VBA/Macro

2009-05-17 Thread TAlgo
I am trying to copy and past data in a cell from another cell in my workbook. I then want to move down one cell each and every time I have pasted the data. Source Data always in Cell A1 target : I would like to copy in B1 Tomorrow when I open my spreadsheet, I would like to copy new data from

$$Excel-Macros$$ Re: how to set default userform when open workbook

2009-05-17 Thread Harmeet Singh
See attched screenshot. On Sun, May 17, 2009 at 7:49 AM, Dhartikumar Sahu wrote: > hi grroup > > can somebody help me how to set default userform when open file. whithout > click. > > > Thanks > Dhartikumar > > > > -- Thanks & Regards, Harmeet Singh --~--~-~--~~~---

$$Excel-Macros$$ Re:

2009-05-17 Thread Ryan Shuell
Can you live with a Label? On Sat, May 16, 2009 at 5:08 PM, Alokeshwar Tiwary < alokeshwar.tiw...@yahoo.com> wrote: > Hi All, > > > Is there a way to change color of a message box back ground and font? > > Please see attached. I want the OK message box to be in same color as the > userform. > >

$$Excel-Macros$$ how to set default userform when open workbook

2009-05-17 Thread Dhartikumar Sahu
hi grroup can somebody help me how to set default userform when open file. whithout click. Thanks Dhartikumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Exc

$$Excel-Macros$$ put settlement data in new cell

2009-05-17 Thread TAlgo
All, I've just started learning vba with few books but need a help: I receive the daily settlement data from external source for different commodity products in excel So I was thinking if I can write a macro which would grab that settlement data for each day and put in new row. So there will

$$Excel-Macros$$ Re: Custom function for cell color

2009-05-17 Thread Rakesh Sharma
Hi you can follow this link below. i have used a custom function for conditional formatting. http://groups.google.co.in/group/vbatalent/web/Consolidate%20Transaction%20Type.xls?hl=en Regards Rakesh On May 15, 7:07 am, zek2005 wrote: > Hi! > > I need to create a function to define a color of

$$Excel-Macros$$ Re: Changing Back and Font Color of a Message Box

2009-05-17 Thread Bhaskar Sharma
Hi, As far as I know, msgbox controls are too limited to exploit them to change their color according to your needs. However, you can use another userform smartly instead to solve your purpose. You can still have a look at (http://gregmaxey.mvps.org/Custom_MsgBox.htm), but not sure if it serves y