in
All Tags » VBA » macro (RSS)

Browse by Tags

  • Disable CheckBox on UserForm in Excel depending on selections

    Hi Experts! I have a Userform in Excel (2007) with several check-boxes on it. For example, there are 2 categories, each with 5 check-boxes under it. The user needs to check one from checkbox 1-5 (category 1) and one from checkbox 6-10. Upon selection from any of the checkboxes 1-5, say number 2, then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Go to Prescedents of Cell summing another sheet - quite possibly impossible

    hi all, i'm finding a particular task very hard to accomplish in Excel VBA. I have a formula in range K6 in a sheet called "Aggregate". the formula resembles "=sum(sheet1!K6, sheet2!K6, sheet3!K6) As the sheet that i'm working on is an aggregate view, i need to achieve the following...
    Posted to Visual Interdev (Forum) by microsoft on 05-22-2010

  • change colour of character within cell (excel 2003) via VBA Macro

    Hi, I have a bunch of words within column A. i need to make specific letters a certian colour. i need to find within the words, the letter "n", within the column and colour all n's .ColorIndex = 1 i need to find within the words, the letter "l", within the column and colour all...
    Posted to Excel (Forum) by microsoft on 05-20-2010

  • Unhide Specific rows in worksheet

    Hi, I have a spreadsheet with a number of hidden ranges. The spreadsheet has a sum formula at the bottom of the sheet, however, sometimes i need to see what rows the data is being picked up from. the formula in cell I1059 looks like this : =SUM(I451,I599,I731,I741,I747,I759,I727,I792,I12,I86,I98,I134...
    Posted to Microsoft Office (Forum) by microsoft on 05-20-2010

  • Excel DateDif and  VBA DateDiff

    I am using DateDIff in VBA to find diff b/w two dates in Years DateDiff("YYYY", Date1, Date2) But for Below dates, i get a diff of 5 Years using DateDiff in VBA, and a diff of 4 Years using DateDif in Excel Formula !! Date1: 10/07/2008 (DD/MM/YYYY) Date2: 12/06/2013 (DD/MM/YYYY) What one is...
    Posted to Excel (Forum) by microsoft on 05-17-2010

  • Microsoft Project 2007 VBA Macro

    We have an issue with some custom Developed VBA Project inside Microsoft Project. When the macro is executed, the following is displayed: --------------------------- Microsoft Forms --------------------------- This application is about to initialize ActiveX controls that might be unsafe. If you trust...
    Posted to Microsoft Project (Forum) by microsoft on 05-15-2010

  • Excel 1-2 digit to 4 digit date macro

    I have a spreadsheet exported from another program and the date column is outputted as 1 or 2 digit depending on year (e.g 1999 = 99 or 2007= 7). I have modified a simple formula to correct the date but I would rather have it as a macro that as non-technical people will be using this. Formula is: =IF...
    Posted to Visual Interdev (Forum) by microsoft on 05-04-2010

  • Search and retrieve data from Pivot Table using VBA

    Hello, I would like to search a pivot table and retrieve information from the table using a VBA macro. The attached file shows the layout of the pivot table. As an example, I'd like to search the date column for 1/31/2009 then retrieve the Bicycle value in column B = 1,632. Thanks, Ron
    Posted to Visual Interdev (Forum) by microsoft on 04-26-2010

  • Create Excel Macro (VBA) to select item from ListBox & assign to variable.

    I am somewhat embarassed to be asking this question because it seems so simple, but here it goes. I am attempting to ad more enhancements to an Excel 2000 spreadsheet I have been using for several years to keep track of my monthly budget. Upon execution, I want the VBA macro to display a list of values...
    Posted to Miscellaneous (Forum) by microsoft on 04-24-2010

  • Overwriting Cells Contents With VBA Macro-Driven SQL Query

    Hello, I am querying an MSSQL Database dynamically through a VBA macro, but when I return my results it inserts them into the spreadsheet rather than overwriting the existing cells. Could someone show me how to reference the correct cells and overwrite them instead of inserting them? The macro in question...
    Posted to Excel (Forum) by microsoft on 04-11-2010
Page 1 of 10 (98 items) 1 2 3 4 5 Next > ... Last »