$$Excel-Macros$$ Re: PLS SOLVE

2015-03-09 Thread sush . david1
please group solve my query On Monday, March 9, 2015 at 10:05:03 AM UTC+5:30, sush@gmail.com wrote: > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FO

Re: $$Excel-Macros$$ Shape Colors (VBA)

2015-03-09 Thread Anand Kumar
http://www.tushar-mehta.com/publish_train/xl_vba_cases/0301-dashboard-conditional_shape_colors.htm On this link you can find a detailed tutorial on conditional coloring. Hope this helps... -- Warm regards, Anand Kumar On Mon, Mar 9, 2015 at 8:31 PM, Swapnil Palande wrote: > Hi Smith, >

Re: $$Excel-Macros$$ Shape Colors (VBA)

2015-03-09 Thread Swapnil Palande
Hi Smith, PFA excel. Press Ctrl + q to run macro. Hope this will solve your problem. Thanks and regards, Swapnil Suresh Palande. On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith wrote: > Hi. If anyone can assist. > > I have a map of the world in individual shapes per country, each named. > I have

Re: $$Excel-Macros$$ Shape Colors (VBA)

2015-03-09 Thread michael vinoth
Hi Smith, Can you send the model of excel file for more clarity. Regards, MV On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith wrote: > Hi. If anyone can assist. > > I have a map of the world in individual shapes per country, each named. > I have a sales spreadsheet which, through Pivot Tables, conve

$$Excel-Macros$$ Re: Excel VBA Example

2015-03-09 Thread michael vinoth
Nice.. Nikanth Raval... On Tuesday, March 3, 2015 at 8:03:45 AM UTC+5:30, Nilkanth Raval wrote: > Hi Friends, > > Find attached some examples of VBA Macro > > *Thanks,* > *Nilkanth Raval* > *+91 900 428 0 428* > *+91 808 000 1620* > *Think Before You Print.Consider ENVIRONMENT.* > *“SAVE TREES,

$$Excel-Macros$$ Shape Colors (VBA)

2015-03-09 Thread Iain Smith
Hi. If anyone can assist. I have a map of the world in individual shapes per country, each named. I have a sales spreadsheet which, through Pivot Tables, converts the sales into percentages. Using this, conditional formatting colors the cells according to percentage. This will change on a regular

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
for experiment i have tested : http://www.vbnet.ru/forum/show.aspx?id=211608 but without success... 2015-03-09 13:31 GMT+01:00 Sal Sal : > I need to colorize with vbblue, the background of cell Item 3 of column > DUE, not the color font of cell (i know the way to do it). > > > 2015-03-09 12:27 GM

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
I need to colorize with vbblue, the background of cell Item 3 of column DUE, not the color font of cell (i know the way to do it). 2015-03-09 12:27 GMT+01:00 Vaibhav Joshi : > Hi > > can you share sample data with userform for more clarity?? > > On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal wrote: >

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-09 Thread Ashish Bhalara
Thanks Mr.Vaibhav to reply. I realize that when I enable Forwarding and POP/IMAP in Gmail and save changes, the option bu

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Vaibhav Joshi
Hi can you share sample data with userform for more clarity?? On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal wrote: > Tks, i know to colorite the cell in sheet, but my prob is to colorize > background of cell in listview! > For example in row 3 col 6 of listview item. > Il 09/mar/2015 11:23 "Vaibhav J

Re: $$Excel-Macros$$ Update the Data from Different Sheet one below the another

2015-03-09 Thread Vaibhav Joshi
Hi Refer this: https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx On Mon, Mar 9, 2015 at 4:36 PM, divya karkera wrote: > Dear Experts, > > I am held up with the small problem facing with my excel project. > > I need to update the Data from different sheets on to one of the sh

Re: $$Excel-Macros$$ Re: Excel Macro to send email.. on specific dates of the month

2015-03-09 Thread Vaibhav Joshi
Ok, from where you are fetching Line1, Line2 etc..? On Sun, Mar 8, 2015 at 5:10 AM, AndyB wrote: > Hi Vabz > > Nope, grateful if you can help me. > > On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote: >> >> Hi everyone, >> >> Hope you're well. Looking for some help with an email macro. >> >> S

$$Excel-Macros$$ Update the Data from Different Sheet one below the another

2015-03-09 Thread divya karkera
Dear Experts, I am held up with the small problem facing with my excel project. I need to update the Data from different sheets on to one of the sheets which should get updated ,with the data getting updated one below the another as and when updated by the other sheets. Visual Basic or Macro any

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Sal Sal
Tks, i know to colorite the cell in sheet, but my prob is to colorize background of cell in listview! For example in row 3 col 6 of listview item. Il 09/mar/2015 11:23 "Vaibhav Joshi" ha scritto: > Hi > > You can use Range.Interior.ColorIndex property.. > > e.g. Range("A1").Interior.ColorIndex =

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

2015-03-09 Thread Anil Gawli
Dear Gaurav, Thisworkbook and activeworkbook is same when comes to work but the difference is thisworkbook will work where the code is written and activeworkbook will work with active file On Mon, Mar 9, 2015 at 3:51 PM, Gaurav Devrani wrote: > Hi, > > I tried working on that.. while I was test

Re: $$Excel-Macros$$ colorize backgound of a cell of listview in userform

2015-03-09 Thread Vaibhav Joshi
Hi You can use Range.Interior.ColorIndex property.. e.g. Range("A1").Interior.ColorIndex = 5 On Sun, Mar 8, 2015 at 11:21 AM, Sal Sal wrote: > Bug* but > Il 07/mar/2015 17:09 "Sal Sal" ha scritto: > > Simply, colorize a cell background in Row 2 Column 5. >> Naturally the cell is in un a us

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

2015-03-09 Thread Gaurav Devrani
Hi, I tried working on that.. while I was testing that , nothing such happend as you said that your other workbook started hidding sheets. Just wanted to See if you are using activeworkbook instead of thisworkbook. Let me know, if this is not the issue. I will see what i can do for that. And also

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-09 Thread Vaibhav Joshi
Use above code in conjunction with auto-filter code. On Sun, Mar 8, 2015 at 4:22 PM, Eugene Bernard wrote: > > Dear Vaibhav, > > When I hit the button, I am getting the below error. > > [image: Inline image 1] > Regards > Eugene > > > On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi wrote: > >> Ch

$$Excel-Macros$$ Re: PLS SOLVE

2015-03-09 Thread sush . david1
i can't understand how to solve this On Monday, March 9, 2015 at 10:05:03 AM UTC+5:30, sush@gmail.com wrote: > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discuss

Re: $$Excel-Macros$$ Mail from excel using gmail

2015-03-09 Thread Vaibhav Joshi
Hi The script which you gave is using CDO for that you need to have SMTP services running on your machine through which you are running macro...check whether smtp servies is running or not? for setting gmail on outlook, first goto Forwarding and POP/IMAP