FW: $$Excel-Macros$$ date in range

2011-09-04 Thread SAJID MEMON
dear danial, as per your code its not working, please give me suggesstion as per my attachement file. sajid memon From: dcolarde...@free.fr To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ date in range Date: Sat, 3 Sep 2011 19:39:41 +0200 Paste the below

Re: $$Excel-Macros$$ How to load data into Combo box in user form

2011-09-04 Thread bé trần văn
Welcome rajanverma1...@gmail.com, have two ways to set upa List in the Combobox. 01 ways: in the window Propeties Section RowSource you enterthe address of the data you want included in CoboBox. For example, G3: G20 (type a list from G 3 to cell G20) is the listthat appears when you click on

$$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread sandhya jain
Hi All, please help me to remove 0 or null value in pie chart. file enclosed -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread ashish koul
check the link http://www.andypope.info/charts/piezeros.htm On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote: Hi All, please help me to remove 0 or null value in pie chart. file enclosed --

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-09-04 Thread ChilExcel
I have solved my problem Thank www.contextures.com everything I need in a PivotTable without using macros www.contextures.com excellent!! thanks 2011/8/26 ChilExcel chilexcel...@gmail.com in the example I use: 1 advanced filter 2 Pivot table 3 and formula for count unique

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

2011-09-04 Thread Mahesh parab
Hi Prabhu just change Kill sPath sFname Thanks On Sun, Sep 4, 2011 at 9:41 AM, Prabhu prabhugate...@gmail.com wrote: Hi Mahesh, Plz find the same sheet i using for run this macro. Still a getting the same runtime error. Regards, Prabhu --

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

2011-09-04 Thread Mr Excellent
Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be updated should be enabled and the other list box should be disabled and vice versa as well, please help. Thanks, Prasad. --

Re: $$Excel-Macros$$ pie chart -how to remove in chart

2011-09-04 Thread Deepak Pal Singh
Its better to not to use pie chart when you have many data points... FYI... On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote: Hi All, please help me to remove 0 or null value in pie chart. file enclosed --

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-09-04 Thread satvik . ks
Hi guru, Plz help me how to convert number in to a text. Regards, Satvik Sent from BlackBerry® on Airtel -Original Message- From: ChilExcel chilexcel...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 4 Sep 2011 12:36:39 To: excel-macros@googlegroups.com Reply-To:

$$Excel-Macros$$ replacement for query expression Right ([F2],3) ????

2011-09-04 Thread ScubaDude_ITmanager
Okay, its and Access question but may be used in both. Right ([F2], 3) is used in about 40 queries during importing custom data from different sources. Access now errors because there is a comma in it (works in access prior to version 2007 but not 2007 or 2010). Do you know of any replacement

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

2011-09-04 Thread Bheema Shankar
hai to all, I need to scroll and blink label caption on the userform. I am using Excel 2003. Pls guide me how to do this ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

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

2011-09-04 Thread XLS S
Userforms have 6 properties that relate directly to ScrollBars. Set the .ScrollBars property to 2 Now, set the .ScrollTop to 0 (So it will appear always at the top of the form) and finally, you must change the .ScrollBarHeight to something... for example, If the UserForm height is 100, try

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-09-04 Thread XLS S
Hey Satvik, please find the below link http://www.ozgrid.com/VBA/conversion-functions.htm On Mon, Sep 5, 2011 at 9:28 AM, satvik...@gmail.com wrote: ** Hi guru, Plz help me how to convert number in to a text. Regards, Satvik Sent from BlackBerry® on Airtel

Re: $$Excel-Macros$$ replacement for query expression Right ([F2],3) ????

2011-09-04 Thread XLS S
Hey Manager Sir, Use proper syntax. like right([tablename.columnsname,num_char] left([tablename.columnsname,num_char] On Mon, Sep 5, 2011 at 4:03 AM, ScubaDude_ITmanager blackjeepfinanc...@gmail.com wrote: Okay, its and Access question but may be used in both. Right ([F2], 3) is used in

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

2011-09-04 Thread NOORAIN ANSARI
Dear Bheema, Please see attached sheet it it help to u.. -- Thanks regards, Noorain Ansari http://Excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Sep 5, 2011 at 7:29 AM, Bheema Shankar

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

2011-09-04 Thread NOORAIN ANSARI
Dear Surya, Please see attached sheet if it help.. On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent suryaprasad...@gmail.comwrote: Hi Group, Need a small help, i have a combo box in the form and when i click on particular name INDIA one of the list box which says Indian currency to be

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

2011-09-04 Thread Ms-Exl-Learner .
Hi Mr. Shrinivas, Correcting a mistake won't be treated as hurting and if you feel like that then it's your way of thought and I don't want to comment about it. Real experts never like to see wrong answers getting delivered to the questioners and that was I did. If I am providing a wrong

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

2011-09-04 Thread David Lanne
Sub OTX() ' ' OTX Macro ' '     If (c32 c33) Then     End If     If (c32 = c33) Then     Range(g32:g33).Select     Application.Run OT     End If     End Sub   Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs OT. Right now it runs OT whether c32/c33