$$Excel-Macros$$ Re: request

You should download and install Office 2007 Compatibility Pack. It is free. Here is the link to download : http://www.microsoft.com/downloads/details.aspx?FamilyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466displaylang=en After installing this, you will be able to open file produced in office 2007.

$$Excel-Macros$$ Re: Fwd: Help required

Thank you very much Harmeet! Just curious to know whether we can done it through VBA coding? because i suppose to apply this formula in all the checklists its around 50 workbooks. Any ways thanks for your swift response! Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh

$$Excel-Macros$$ request

Dear Group, 1 reuested to u pls if u r reverting some one's query then pls save ur attachment in XLS not XLSX, i thing there are some Learner like me who havent excel 2007, if file in XLSX format then we are unable to open Regards Harish Upadhyay

$$Excel-Macros$$ Insert ListBox into Cell

Hi Group; I'm new to MS EXCEL AND VBA MACROS. I want to know how to insert a ListBox into a Cell. I need it to be visible ony when this Cell is selected. Thanks, Walid --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Insert ListBox into Cell

Hi Walid, Go to Data - Validation in the option button click as List -- Mention the names you need and close. All the action will be applied on the selection of cell. Cheers Surya On Thu, May 7, 2009 at 12:39 PM, Mr Walid Zahran walid...@gmail.com wrote: Hi Group; I'm new to MS EXCEL AND

$$Excel-Macros$$ Re: Insert ListBox into Cell

Hi Walid, you can use Data-Validation to do that. Check Help on Validation On Thu, May 7, 2009 at 9:09 AM, Mr Walid Zahran walid...@gmail.com wrote: Hi Group; I'm new to MS EXCEL AND VBA MACROS. I want to know how to insert a ListBox into a Cell. I need it to be visible ony when this

$$Excel-Macros$$ Re: Cell reference

Yes..it works! Thanks On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos flnle...@gmail.com wrote: You will need to use the indirect formula, which converts an addres to a reference =indirect(b1 c1) Regards! Fabio L. Lemos cel.: 8122-1206 Em 06/05/2009, às 11:34, Yu vincent2...@gmail.com

$$Excel-Macros$$ general discussion on DDE OLE ActiveX in VBA project

Hi guys, While I browse the Tools--References in VBA , I notice that there are lots of references, basically classified into 4 groups: Type Libraries(*.olb, *.tlb, *.dll) Executable Files (*.exe, *.dll) ActiveX Controls (*.ocx) All Files (*.*) I can see currently my VBA

$$Excel-Macros$$ Re: general discussion on DDE OLE ActiveX in VBA project

Hi, 1. Microsoft Forms 2.0 Object lib. provides the MSForms2.0 Controls. Just a few. To know more about each of the referenced components, in VBE press F2 to bring up the object browser. In the first combo-box (upper-left - All Libraries), select the appropriate one, and you will know what

$$Excel-Macros$$ Average's

This is fairly simple question just dont know how to approach it I have 52 columns of data i need to work out the average highest number and the average lowest number Any idea's --~--~-~--~~~---~--~~

$$Excel-Macros$$ A tricky scenario that may need a function or VBA.

I am a self employed Excel trainer that teaches basic, intermediate and advanced Excel to various groups. I can handle most questions, but I was stumped in the class today. Here is the scenario. Given a set of numbers in a range, and a separate cell with an individual number in it, is there a

$$Excel-Macros$$ Conditional format macro

help I need some code that will format a cell to have a red background and format two cells to the left and and one to the right if it has a date less than the date in a named cell. any ideas --~--~-~--~~~---~--~~

$$Excel-Macros$$ Run a macro on Enter?

I've got an Excel spreadsheet that I'm going to use a wedge program with to capture data from an instrument and parse it into the sheet. I would like to make it happen without having to use a mouse to click a button. A hot key combo or a form would work but it would be really sweet if I could

$$Excel-Macros$$ Re: Average's

Hi Sabby, Could you explain , how many of the highest numbers and lowest numbers you want to consider to calculate the averages. Regards, Andy On Fri, May 8, 2009 at 12:30 AM, Sabbycat dancoo...@googlemail.com wrote: This is fairly simple question just dont know how to approach it I have

$$Excel-Macros$$ Re: Run a macro on Enter?

The following code may be of help: open excel open visual basic editor double click sheet1 (or any other sheet) under microsoft excel objects Add the following code Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Range(C:C), Target) Is Nothing Then 'do

$$Excel-Macros$$ Re: Average's

If you meant the maximum and minimum numbers you can use max() and min() functions. On Thu, May 7, 2009 at 10:30 PM, Sabbycat dancoo...@googlemail.com wrote: This is fairly simple question just dont know how to approach it I have 52 columns of data i need to work out the average highest