Search:

Type: Posts; User: AlphaFrog; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.50 seconds.

  1. Replies
    3
    Views
    106

    Re: arrays and totalling an element

    Dim datalistarray() As String

    You declared datalistarray as a String-type.


    total = total + datalistarray(a, 3)

    When you use String + String, it concatenates strings. Not sums them.

    Try...
  2. Replies
    7
    Views
    119

    Re: Help with Copy Method (Macro)

    Did you try my code... unchanged?
  3. Replies
    17
    Views
    463

    Re: Question On Conditional Ranking

    Yes it should work with decimals.
  4. Replies
    7
    Views
    119

    Re: Help with Copy Method (Macro)

    The code I suggested works.

    You nested your IF statements, and you didn't use proper indentation so it's not obvious you nested the IF statements.

    This is your unchanged code with proper...
  5. Replies
    7
    Views
    119

    Re: Help with Copy Method (Macro)

    Sub Update_Sheets()

    If MsgBox("Do you wish to Update 'Members'", vbYesNo + vbQuestion, "") = vbYes Then
    ...
  6. Replies
    6
    Views
    131

    Re: find case in a certain cell

    Case LCase(Sheet4.Range("A2").Value): Clr = 45
  7. Replies
    6
    Views
    131

    Re: find case in a certain cell

    Case LCase(Range("A2").Value): Clr = 45
  8. Re: Working out an average in days, months years

    Your Length Of Absence (LOA) formula returns a text result. If you want to use those results in further calculations and formulas, you'll need numeric results. Perhaps it would be easier to just...
  9. Replies
    6
    Views
    131

    Re: find case in a certain cell

    I don't understand what that means.
  10. Replies
    12
    Views
    290

    Re: Open Directory for user to choose a file

    Dim wkb2 As Workbook, strFileName As String, FileFilter As String

    ChDir ThisWorkbook.Path

    FileFilter = "Excel 2003 (*.xls),*.xls," & _
    "Excel 2007 >...
  11. Re: Why the row selected is displayed in negative value : Range ().value = Target.row

    The code loops through each cell selected. With the first cell in the loop, it puts something like (1). Excel evaluates that entry to just its' numeric negative (like a currency value).

    Just...
  12. Replies
    12
    Views
    290

    Re: Open Directory for user to choose a file

    Set wkb2 = Workbooks.Open(strFileName, False, False)

    When the workbook is opened, the variable wkb2 is set to it. Just reference wkb2. It is the opened workbook regardless of the file name.

    ...
  13. Replies
    12
    Views
    290

    Re: Open Directory for user to choose a file

    Dim wkb2 As Workbook
    Dim strFileName As String
    Dim FileFilter As String

    ChDir ThisWorkbook.Path

    FileFilter = "Excel 2003 (*.xls),*.xls," & _
    "Excel...
  14. Replies
    12
    Views
    290

    Re: Open Directory for user to choose a file

    ChDir ThisWorkbook.Path

    FileFilter = "Excel 2003 (*.xls),*.xls," & _
    "Excel 2007 > (*.xlsx),*.xlsx," & _
    "All Excel Files (*.xl*),*.xl*," & _
    "All Files (*.*),*.*"

    GetFileName =...
  15. Re: Passing Text Box value to another Text Box

    Use something like this...


    txtAmount.Value = Format(MySum, "#,##0")
  16. Replies
    12
    Views
    290

    Re: Open Directory for user to choose a file

    Is "Element List (whatever the user had named the file).xlxs" in the same folder as the workbook that has the macro code?

    If yes...


    ChDir ThisWorkbook.Path

    FileFilter = "Excel 2003...
  17. Re: Passing Text Box value to another Text Box

    I don't know what that format is. It doesn't work for my version of Excel.

    Try something like this. I can't test it. You may have to adjust it.


    Private Sub txtDiscount_Change()
    ...
  18. Re: Passing Text Box value to another Text Box

    Private Sub txtDiscount_Change()
    Me.txtTotal = Me.txtAmount - Me.txtDiscount
    Me.txtPaid.Text = Me.txtTotal
    Me.txtRest = Me.txtTotal - Me.txtPaid
    End Sub


    Private Sub...
  19. Replies
    4
    Views
    179

    Re: Crazy Date Formatting????

    Select the 4 columns
    Replace (Ctrl+H) the / with a / to convert the dates en masse
    Format them to suit
  20. Re: User Form data entry as date and number!!!

    Try this...


    ws.Cells(nr, 1) = CDate(Me.TextBox1) 'Date


    ws.Cells(nr, 4) = CCur(Me.TextBox4) 'Amount
  21. Re: How to read approx 200 excel file in a single excel sheet one by one.

    RDBMerge is a user friendly way to Merge Data from Multiple Excel Workbooks,
    csv and xml files into a Summary Workbook.

    RDBMerge, Excel Merge Add-in
  22. Replies
    4
    Views
    179

    Re: Crazy Date Formatting????

    When you imported the data, the dates were seen by Excel as text and not serial dates. A simple way to coerce the text-dates into serial dates is to select the date column and simply do a Replace...
  23. Re: How do I get a label in a scatter plot instead of "Series 1 Point"?

    Hide columns H:I
    Make an Scatter chart with data range G6:K98 and data series in Rows
  24. Re: How do I get a label in a scatter plot instead of "Series 1 Point"?

    It works for me. How is your chart data layed out.

    I put the series names in A2:A5
    The X-axis values in B1:M1
    And the Y-Axis values in B2:M5
    A1 is blank

    Used A1:M6 as the source data (series...
  25. Re: When Excel macro can't capture steps I carried out

    I usually just do a web search for something like Excel VBA Insert Picture in Comment

    This was the 2nd link in the search results. It's a step-by-step guide.
    VBA Code To Insert An Image Into A...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4