$$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

$$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

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 sweetgrld...@gmail.com 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

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 sal72...@gmail.com 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

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 https://mailtrack.io/trace/link/a8085d1844ea014de74fde5fec93a1ef72f995f4?url=https%3A%2F%2Fmail.google.com%2Fmail%2Fu%2F0%2F%23settings%2Ffwdandpopsignature=349318ba2e1728fd in Gmail and save changes, the option

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 sal72...@gmail.com: 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).

$$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, SAVE

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 iain.nata...@gmail.com 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

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 v...@vabs.in: Hi can you share sample data with userform for more clarity?? On Mon, Mar 9, 2015 at 4:26 PM, Sal Sal

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 anindya20042...@gmail.com 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

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 iain.nata...@gmail.com wrote: Hi. If anyone can assist. I have a map of the world in individual shapes per country,

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 gauravdev1...@gmail.com wrote: Hi, I tried working on

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 v...@vabs.in ha scritto: Hi You can use Range.Interior.ColorIndex property.. e.g.

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

$$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 @

$$Excel-Macros$$ Re: PLS SOLVE

2015-03-09 Thread michael vinoth
Hi David, Please find the attached macro file. Regards, MV 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 @

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

Fwd: $$Excel-Macros$$ PLS SOLVE

2015-03-09 Thread Pramod Singh
Hi David. .. PFA Pramod -- Forwarded message -- From: Pramod Singh pramod...@gmail.com Date: 9 Mar 2015 11:33 Subject: Fwd: $$Excel-Macros$$ PLS SOLVE To: Pramod Singh pramod.si...@analec.com Cc: Pramod -- Forwarded message -- From: sush.dav...@gmail.com Date: 9

Re: $$Excel-Macros$$ PLS SOLVE

2015-03-09 Thread Vaibhav Joshi
Check this: http://www.exceltrick.com/how_to/sum-cells-based-on-background-color/ cheers!! On Mon, Mar 9, 2015 at 10:05 AM, sush.dav...@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

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 eugene.bern...@gmail.com 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

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 sal72...@gmail.com wrote: Bug* but Il 07/mar/2015 17:09 Sal Sal sal72...@gmail.com ha scritto: Simply, colorize a cell background in Row 2 Column 5.

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