$$Excel-Macros$$ Is there any way to increase the size of an image in a excel cell when onmouseover?

2009-07-11 Thread sHiVa
Hi, I have pasted an image in excel cell. I want to view that image bigger when onmouseover activity. Is there any possibility? If there is a solution please share with me. Thanks in advance. Regards Siva --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Urgent Help Required

2009-07-11 Thread vinod rao
Hello, Plz let me know below query. On Thu, Jul 2, 2009 at 2:26 PM, vinod rao wrote: > Hello, > > Can i know how was radio icon created linked to year 1,2 3.? > > Thanks in advance. > Vinod > > On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote: > >> Dear Dilip, >> >> Thanks a lot. Its working

$$Excel-Macros$$ Need month wise count of the items from the table.

2009-07-11 Thread kunal
Hi, There is a table in which there are 3 main columns i.e. Priority, Status and Date Identified. I need to populate a table of total items taking value of Priority with month identified. Please help Regards, Kunal Rout --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Web image to Excel

2009-07-11 Thread Daniel
Hi. Have a look at the attached file. I’m using FALSE hyperlinks in column A (just enter the address, blue font and underlined). Click on one cell. Here is the code : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Or Target.Column > 1 Then Exit Sub Application

$$Excel-Macros$$ Web image to Excel

2009-07-11 Thread Satheesh H.N
Hi friends, How to view web images automatically in excel through hyperlink. Regards, Satheesh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tuto

$$Excel-Macros$$ Re: activate and deactivate hyperlink

2009-07-11 Thread Daniel
Hello, Use : =IF(A1=8,HYPERLINK(A1,"A1"),"") Hope this helps. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de pavithra murthy Envoyé : samedi 11 juillet 2009 12:37 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Mac

$$Excel-Macros$$ dynamic lookups

2009-07-11 Thread Carl Ross
I have attached a workbook if anyone should dare try to figure this oout for meI would appreciate it. This is a little complicated but here it goes. I work for the Dept. of Transportation in WV. I use a program named ArcMap. It is a really complicated mapping program. It uses excel spreadshee

$$Excel-Macros$$ activate and deactivate hyperlink

2009-07-11 Thread pavithra murthy
hello friend , i have a requirement where : if i have value 8 in cell A1 : then we assume the hyperlink is present in D1 should be activated .Any other value other than 8 is there means hyperlink should be deactivated ,. Please could anyone help . --~--~-~--~~~---~--

$$Excel-Macros$$ Re: stuck in function

2009-07-11 Thread Daniel
Not sure it's what you want : Public Function C_D(X As Integer, T As Integer) As Variant C_D = Exp(-((X - T) / Sqr(10#)) ^ 2 / 2) / Sqr(20# * _ Application.WorksheetFunction.Pi()) End Function Regards. Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-

$$Excel-Macros$$ Please help me to solve the problm

2009-07-11 Thread shijomon joseph
Dear Friends, I am looking for the use of “vlookup” function for getting the below criteria · To find the description & details from the database if I enter the Iem code on the working sheet. · Also cross check the location, because same item code has different description accord

$$Excel-Macros$$ Re: stuck in function

2009-07-11 Thread Vivek Agrawal
hi given below is the correct expression. when you are assigning an expression to the function return value, you don't pass arguments. Public Function C_D(X As Integer, T As Integer) As Variant C_D = Exp(-((X - T) / Sqr(10#)) ^ 2 / 2) / Sqr(20# * Application.WorksheetFunction.Pi()) End Functi

$$Excel-Macros$$ Re: stuck in function

2009-07-11 Thread vivek agrawal
hi given below is the correct expression. when you are assigning an expression to the function return value, you don't pass arguments. *Public Function C_D(X As Integer, T As Integer) As Variant* * * *C_D = Exp(-((X - T) / Sqr(10#)) ^ 2 / 2) / Sqr(20# * Application.WorksheetFunction.Pi())* * * *

$$Excel-Macros$$ Re: Need Macros for Track Changes

2009-07-11 Thread Pooja Sharma
Hi Ashish, Thanks! for the reply. But in this case, anyone can stop the Track Changes. This won't woks as a hidden kind of thing for others. Regards Pooja On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan wrote: > > Hello Pooja > > To track changes on a new work sheet kindly follow the steps given

$$Excel-Macros$$ Re: about VBA in MS project

2009-07-11 Thread Lynn
any help? On Jul 2, 11:54 pm, Lynn wrote: > how can this be done in MS project? > > On Jul 1, 8:09 pm, Dilip Pandey wrote: > > > > > Hi, > > > Check the attached file.  Overdue tasks/ projects will be highlighted > > automatically. > > > Thanks, > > -- > > DILIP KUMAR PANDEY > >   MBA-HR,B COM(

$$Excel-Macros$$ Re: need a function or a formula which will search a table and get max value from the table.

2009-07-11 Thread kunal
Hi Daniel and Pal, Thank for clearing the concept.. Kunal --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins down

$$Excel-Macros$$ Re: Urgent!!!!!!!!!!

2009-07-11 Thread Sunny Agarwal
On Sat, Jul 11, 2009 at 1:10 AM, Sunny Agarwal wrote: > Hi, > Select the entire row again( except text eg; Date is written as text & > this may be conflicting) go to Format--Cells--Customs select the date format > you want.Its done.Even if this doesnt works than simply delete the entire > date ro

$$Excel-Macros$$ Re: Help with Combo Box and Display

2009-07-11 Thread Ashish Pradhan
Hi Vivek and Anil Thanks a lot for your help. This is exactly what I needed. Thanks once again.. -- Ashish "Of what use is freedom if it does not include the freedom to make mistakes" -- Mahatma Gandhi On Fri, Jul 10, 2009 at 6:13 PM, vivek agrawal wrote: > Hi ashish > attached is the e

$$Excel-Macros$$ Re: Urgent!!!!!!!!!!

2009-07-11 Thread Sunny Agarwal
Hi, Select the entire row again( except text eg; Date is written as text & this may be conflicting) go to Format--Cells--Customs select the date format you want.Its done.Even if this doesnt works than simply delete the entire date row & insert a new row. On Fri, Jul 10, 2009 at 5:23 PM, sachinp

$$Excel-Macros$$ Re: Help with Combo Box and Display

2009-07-11 Thread Sunny Agarwal
Hi, U just need to select the entire ROW OF COMPANY by pressing on C,D,E OR F ( the row in which Company is)only, and apply filter.your answer is solved.So,u will b able to filter only according to your choice. On Fri, Jul 10, 2009 at 6:13 PM, vivek agrawal wrote: > Hi ashish > attached is the

$$Excel-Macros$$ stuck in function

2009-07-11 Thread larry
Any idea why the code gets stuck in this function? I debug using step into and it just starts looping. Public Function C_D(X As Integer, T As Integer) As Variant C_D(X, T) = Exp(-((X - T) / Sqr(10#)) ^ 2 / 2) / Sqr(20# * Application.WorksheetFunction.Pi()) End Function --~--~-~--~~-

$$Excel-Macros$$ Re: Worksheet_calculate Question

2009-07-11 Thread TAlgo
was able to figure it ouyt myself On Jul 10, 9:02 am, TAlgo wrote: > Hello, > > I've a quick question on an event Private Sub Worksheet_Calculate(). > > I got Private Sub Worksheet_Calculate() running on Sheet1 which does > few calculations and calls a macro. > > Is it possible I can create

$$Excel-Macros$$ Help with Combo Box and Display

2009-07-11 Thread Nagendra Modupalli
Hi Team, Can you please help below template for Combo box.Thanks in advance. I need month wise first and Location wise -- Thanks&Regards Nagendra.M "LIFE IS TO LIVEE"... --~--~-~--~~~---~--~~ -