Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VBA (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • scientific calulations using scattter and trendlines

    Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...
    Posted to VBA (Forum) by ecellium on Thu, Jan 7 2010
  • Sum last 10 values

    Hi all With the data below :- how can I sum the last 10 cells in the row from 2-11 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2
    Posted to Functions and Formulas (Forum) by Derek McGill on Mon, Dec 21 2009
  • Tab Renaming

    Is it possible to use a formula or VBA to automatically change the name of a tab when I copy from another tab (I'm thinking of it referencing a cell in the sheet - eg. =month(a4) ?
    Posted to Excel 2007 (Forum) by Mike on Fri, Nov 27 2009
  • Re: combo box calculations

    I work on a excel workbook that has 31 worksheet for the days of the month. I need the combo boxex I created to calculate across work sheets So if day 1 it add up cells in there specific range and specific columns. That works fine. Its when I need day 2 to look at the cell that day 1 has populated and...
    Posted to VBA (Forum) by boman on Fri, Nov 20 2009
  • Excel 2003 Excel2007 migration issue with picture.insert

    I use Excel 2003, but some of my workbooks are used by colleagues using Excel2007. One of my workbooks populates cells with photos. I start with a suitably sized grid, select a cell, insert the picture and resize it and adjust its position. The code that does this is as follows: Sub InsertPic(row, col...
    Posted to General (Forum) by PeterG on Thu, Nov 19 2009
  • combo box calculations

    I am trying develop an excel spread sheet that calculate across spreed sheets and cells. I Code: Private Sub Tradebox_GotFocus() Tradebox.AddItem "AW" Tradebox.AddItem "BM" Tradebox.AddItem "AM" Tradebox.AddItem "CF" Tradebox.AddItem "E" Tradebox.AddItem...
    Posted to VBA (Forum) by boman on Thu, Nov 19 2009
  • I am amateur in VB scripts, can anyone kindly advice how to speed up the saving process for below VBA scripts

    Global Const commonPath = "H:\Market Data\Curve Data\" Global Const commonPath1 = "H:\Market Data\FX Data\" 'Global Const bookName = "MasterCurve" Public dTime As Double Sub startSave() dTime = Now + TimeValue("00:00:30") Application.OnTime EarliestTime:=dTime...
    Posted to VBA (Forum) by esdontan on Mon, Nov 2 2009
  • Re: error code driving me mad

    Helen Seldom any need to select and activate stuff. (You could have used activesheet.paste), so you code can copy the active cell and 6 columns to the right and then paste to the Patients sheet by just using the 'Destination' parameter in the copy method, thus Sub copydata240709() ActiveSheet...
    Posted to VBA (Forum) by Nick Hodge on Fri, Jul 24 2009
  • Re: Write Excel chart into a Word document

    hmdm2009, A little Googling and you're there. The code below is modified from http://peltiertech.com/Excel/XL_PPT.html#chartwd Make sure you add a reference to the appropriate Microsoft Word Object Library before you try to run the code. Sub ExcelCopyWordPaste() Application.ThisWorkbook.Activate...
    Posted to VBA (Forum) by Mattheq on Sat, Jun 13 2009
  • Re: Displaying a Message Box on result of a formula

    Omar, You can do it using the following code (adapted from Gizmo's original reply): Private Sub Worksheet_Change( ByVal Target As Range) Dim intRows As Integer If Target.Column = 11 Then 'Error check only fires if Column 11 (K) is edited, else exit sub For intRows = 1 To 47 'Error check only...
    Posted to VBA (Forum) by Mattheq on Fri, Jun 5 2009
Page 1 of 7 (62 items) 1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.