$$Excel-Macros$$ Re: Hi

Please help me. On Tue, Sep 6, 2011 at 10:37 AM, Mudit Gandhi wrote: > Hi group > > I am beginner at macro so i want a pdf tutorials in which i could get all > the formulaes used in macro with examples. > > Thanks for ur help > Mudit > -- ---

Re: $$Excel-Macros$$ scrolling and blinking label caption

Dear Bheema, See attached sheet. *Private Sub UserForm_activate() marqueeText = " This is a test of the Marquee" Do For m = 1 To Len(marqueeText) UserForm1.Label1.Caption = Mid(marqueeText, m, 10) For i = 60 To 55 Step -1 'Change in accordanc

Re: $$Excel-Macros$$ Calender needed in the check box

Dear Surya, you can install date picker Control,try the link below http://danielcurran.com/instructions/how-to-install-microsoft-date-time-picker-control-60-sp4/ On Tue, Sep 6, 2011 at 8:30 AM, NOORAIN ANSARI wrote: > Dear Surya, > > Please see attached sheet... > > You can add Date & Time

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congratulations BRO u rock :-) Sent from BlackBerry® on Airtel -Original Message- From: Venkat CV Sender: excel-macros@googlegroups.com Date: Tue, 6 Sep 2011 10:43:07 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congratulations Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain wrote: > Hello Everyone, > Rajan Verma has been selected as '

Re: $$Excel-Macros$$ Re: Doesn't this mean?

Thanks From: lifescholar To: MS EXCEL AND VBA MACROS Sent: Monday, September 5, 2011 2:47 AM Subject: $$Excel-Macros$$ Re: Doesn't this mean?     If (Range("c32") <> Range("c33")) Then On Sep 5, 6:06 am, David Lanne wrote: > Sub OTX() > ' > ' OTX Macro > ' > ' >     If (c32 <> c33) Then >   

Re: $$Excel-Macros$$ Re: Doesn't this mean?

Thanks From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Monday, September 5, 2011 3:00 AM Subject: Re: $$Excel-Macros$$ Re: Doesn't this mean? Dear David,   Pls try it..   Sub Example() If Sheet1.Range("C32").Value = Sheet1.Range("C33").Value Then    Sheet1.Range("g32:g33").

Re: $$Excel-Macros$$ Doesn't this mean?

Thanks From: Daniel To: excel-macros@googlegroups.com Sent: Monday, September 5, 2011 5:39 AM Subject: RE: $$Excel-Macros$$ Doesn't this mean? You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32  is considered a variable name, not a range.   HTH   Daniel   De :excel-macros@

Re: $$Excel-Macros$$ Calender needed in the check box

Dear Surya, Please see attached sheet... You can add Date & Time Picker Box Step : *Tool Box->Right Click->additional Controls->Check Microsoft Date & Time Picker Controls* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

CountIFS is a NEW function that does not work in earlier that xl2007. So you will need a combination of countif (no S) OR Sumproduct example =sumproduct((a2:a22=2)*(b222=”b”)) From: Amit Desai (MERU) Sent: Monday, September 05, 2011 1:52 PM To: excel-macros@googlegroups.com Subject: RE: $$Exce

$$Excel-Macros$$ Calender needed in the check box

Hi team, I have a form where i have a check box where i need to update a date value in it, so what i need is a option of calender to enter the value of date in the given check box. Please help, as attached. Thanks Prasad. -- -

Re: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Hi Noorain, Thank you for this , one doubt here can we Have a faded or shaded check box instead if hiding them? Thanks Prasad. On Tue, Sep 6, 2011 at 12:07 AM, NOORAIN ANSARI wrote: > Dear Surya, > > Please see attached sheet if it help to u.. > > -- Forwarded message -- > Fro

Fwd: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Dear Surya, Please see attached sheet if it help to u.. -- Forwarded message -- From: Date: Mon, Sep 5, 2011 at 11:15 PM Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes To: excel-macros@googlegroups.com **Hi all, Can anyone help me on this?? Regards Prasad

$$Excel-Macros$$ Re: Apparent corruption with .PageSetup.Zoom

Chris, doesn't look like anything is wrong with your settings. If A3 wouldn't be a problem, try changing the paper size to A3, from A4 Sam On Sep 5, 10:24 pm, "Chris Boxall" wrote: > Apparent corruption with .PageSetup.Zoom > > I fear that I have corrupted my installation of Excel 2007 (on XP). >

Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Hi all, Can anyone help me on this?? Regards Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Date: Mon, 5 Sep 2011 17:10:47 To: Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single cas

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

Great Solution SAM On Mon, Sep 5, 2011 at 10:48 PM, GoldenLance wrote: > =SUMPRODUCT(LEN(A1)- > LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),""))) > > from > http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text > > GL > > On Sep 5, 9:09 pm, Intelligent But C

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congratulation Rajan Babu also Noorain, Venkat, Don Guillett, and other folks On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain wrote: > Hello Everyone, > Rajan Verma has been selected as 'Most Helpful Member' for the month of > August'11 > He has posted 152 posts in August 2011 and helped many peop

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congrate rajan babu... On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain wrote: > Hello Everyone, > Rajan Verma has been selected as 'Most Helpful Member' for the month of > August'11 > He has posted 152 posts in August 2011 and helped many people through his > expertise. He has been c

$$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - August'11

Rajan, you make us proud. Thanks for the excellent contribution to this forum. Your dedication and commitment to help the online community has been exemplary. Keep up the good work. Regards, Sam Mathai Chacko (GL) On Sep 5, 10:29 pm, Ayush Jain wrote: > Hello Everyone, > Rajan Verma has been sel

$$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of August'11 He has posted 152 posts in August 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition for second time consecutive

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

=SUMPRODUCT(LEN(A1)- LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),""))) from http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text GL On Sep 5, 9:09 pm, Intelligent But Crazy wrote: > Thanks Noorain, > > for your Quick Help. but actually my requirement is F

Re: $$Excel-Macros$$ scrolling and blinking label caption

thank you for replying me. But scrolling means not scroll bar. its the caption text of the label have to move from left to right of the screen. just like marquee function in HTML On Sep 5, 7:52 am, NOORAIN ANSARI wrote: > Dear Bheema, > > Please see attached sheet it it help to u.. > -- > Thank

Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Hi Noorain, Please help Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Mr Excellent Date: Mon, 5 Sep 2011 17:10:47 To: Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes Hi Noorain, This helped me a lot but there is a single case in the code,

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Dear Sridhar, Please use below link to solve ur query http://akoul.blogspot.com/search/label/Merge%20Data%20from%20multiple%20workbooks%20for%20specific%20sheets%20only http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy wrote: > > Dear Group, > > Is there any formula which can give the count of alphabets in a cell

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

Dear Pankaj, Please try itand see attached sheet.. *Function Count_text(s As Range) For i = 1 To Len(s) If VBA.Asc(Mid(s, i, 1)) > 65 And VBA.Asc(Mid(s, i, 1)) < 90 Or VBA.Asc(Mid(s, i, 1)) > 96 And VBA.Asc(Mid(s, i, 1)) < 123 Then Count_text = Count_text & VBA.Mid(s, i, 1) End If Nex

$$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Dear Experts, I would request a macro, which can copy the Sheets(two) from one Master file to other different Excel Files(12 files). I would appreciate your help in this matter. Thanks, Sridhar BL -- -- Some impor

Re: $$Excel-Macros$$ Report generation for Excel 2003

You could maybe use a macro or a simple vlookup formula From: Shankar Bheema Sent: Monday, September 05, 2011 8:13 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003 I am attaching the VBA project and a sample spreadsheet form. I want build a r

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

Post a file -Original Message- From: Andy McGooner Sent: Monday, September 05, 2011 7:56 AM To: MS EXCEL AND VBA MACROS Cc: amcni...@jaguarlandrover.com Subject: $$Excel-Macros$$ Problem extracting data from multiple columns Hi All, I have a spreadsheet that can have up to 5 data colu

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

application.enableevents=false code block application.enableevents=true -Original Message- From: John Holland Sent: Monday, September 05, 2011 3:28 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ? I am running

Re: $$Excel-Macros$$ scrolling and blinking label caption

A bit more compact. Year does NOT matter Private Sub ScrollBar1_Change() UserForm1.Label1 = Format(DateSerial(2011, ScrollBar1, 1), "mmm") End Sub From: NOORAIN ANSARI Sent: Sunday, September 04, 2011 9:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ scrolling and blinking

Re: $$Excel-Macros$$ Report generation for Excel 2003

hi, what type of report do you need to create, which is your database.. please provide description about that.. On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar wrote: > Hai all gurus. > > Good evening. I heard that excel is having Report generation option > for its database. May I have the add-i

$$Excel-Macros$$ Problem extracting data from multiple columns

Hi All, I have a spreadsheet that can have up to 5 data column entries per row asscociated to a date etc. The problem is there is multiple rows and i really want to move it all into 2 columns and keep the date associated with the data i am moving as i intend to put these in a graph. I could do th

$$Excel-Macros$$ Report generation for Excel 2003

Hai all gurus. Good evening. I heard that excel is having Report generation option for its database. May I have the add-in to build report for my database ? Hope your kind support for me. -- -- Some important link

$$Excel-Macros$$ RE: MIS executive for a Radio taxi Operator Giant

Dear All, We need MIS executive having very good knowledge of Advance Excel. Forward your CV on my official ID at the earliest. Girls are welcome too. Role: MIS Executive JD: 1) To collect/extract the data from the various parties/system, 2) To prepare daily/weekly/monthly MIS, 3) To

Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes

Hi Noorain, This helped me a lot but there is a single case in the code, how to add many cases if the select any other country and opt for other check boxes, please refer to the attachment Please help Thanks Prasad. On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI wrote: > Dear Surya, > > Please

RE: $$Excel-Macros$$ Doesn't this mean?

You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is considered a variable name, not a range. HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de David Lanne Envoyé : lundi 5 septembre 2011 07:06 À : excel-macros@googl

$$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

I am running into the problem that some VBA code is not processed in time before a next statement can be executed. For example i want to put a certain Excel graph into the Windows Clipboard and then echo it in an image control on a userform. After that comes a 2nd graph in another image control and

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear MSEXL Learner Correcting a mistake won't be treated as hurting -: I am fully agree with u but u can correct a mistake by polite way (Never create and suggest formula's based on the articles you read in internet or book, understand the concept how the functions are working and it's concept then

$$Excel-Macros$$ Fwd: mis executive, chennai, CONTRACT 2 HIRE

- Original message From:"Source One Management Services Pvt.Ltd"< farhee...@msourceone.com > Date: 5 Sep 11 12:33:34 Subject: mis executive, chennai, CONTRACT 2 HIRE To: The sender of this email is registered with Naukri.com as Source One Management Services Pvt.Ltd Dear Candidate

$$Excel-Macros$$ Re: write and read cookies through vba.

Hi Expert, still waiting for ur solution On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey wrote: > Hi Expert. > > Is there any way to write and read cookies through vba. > > Thanks in advance. > > Divaker > -- -- Som

Re: $$Excel-Macros$$ Re: Doesn't this mean?

Dear David, Pls try it.. * * *Sub Example() **If Sheet1.Range("C32").Value = Sheet1.Range("C33").Value Then Sheet1.Range("g32:g33").Select* * Application.Run "OT" Else Exit Sub* *end if* *End Sub* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*