Search:

Type: Posts; User: pike

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: [RESOLVED] Import UTF-8 from CSV to Excel and specify Worksheet

    or

    Sub test()
    Dim strlFilePathName As String, dbRow As Long, dbCol As Long, dbArray
    strlFilePathName = "L:\15\186507.CSV"
    With Workbooks.Open(Filename:=strlFilePathName)
    ...
  2. Thread: Delete row by vba

    by pike
    Replies
    15
    Views
    4,691

    Re: Delete row by vba

    http://www.excelfox.com/forum/showthread.php/2359-Delete-row-by-vba
  3. Thread: Delete row by vba

    by pike
    Replies
    15
    Views
    4,691

    Re: Delete row by vba

    the same assignment ?

    http://www.vbaexpress.com/forum/showthread.php?65786-Copy-paste
  4. Thread: Delete row by vba

    by pike
    Replies
    15
    Views
    4,691

    Re: Delete row by vba

    Is this a cross post or the same assignment ?
    https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1222571-delete-row-by-vba...
  5. Thread: Delete row by vba

    by pike
    Replies
    15
    Views
    4,691

    Re: Delete row by vba

    Is this a cross post or the same assignment ?
    https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1222571-delete-row-by-vba
  6. Re: [RESOLVED] Vlookup for when there are two criterias

    No worries,, thanks for posting
  7. Re: [RESOLVED] Vlookup for when there are two criterias

    Hi,
    or
    =INDEX(Report!$D$2:$D$82,MATCH(1,INDEX((Report!A$2:A$82=B5)*(Report!$C$2:$C$82=A5),0),0))
    few different ways
  8. Re: Vlookup for when there are two criterias

    Hello,
    In cell C5=LOOKUP(2,1/(Report!A$2:A$82=B5)/(Report!$C$2:$C$82=A5),Report!$D$2:$D$82)
  9. Re: combobox that finds record based on order number typed

    try,,,
    Private IsArrow As Boolean
    Private Sub ComboBox1_Change()
    Dim i As Long
    With Me.ComboBox1
    If Not IsArrow Then .List = Range("YourList").Value
    If .ListIndex = -1 And...
  10. Re: know index over mouse movement...listview vba for excel

    or

    Option Explicit

    Private Sub ListView1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As stdole.OLE_XPOS_PIXELS, ByVal y As stdole.OLE_YPOS_PIXELS)
    Dim nodTemp As...
  11. Re: know index over mouse movement...listview vba for excel

    Hi luca90
    can you adapt this API code for Treeview to listview? Listview has a hittest function
    Module code

    Declare Function GetDC Lib "user32" (ByVal hwnd As Long) As Long
    Declare Function...
  12. Re: know index over mouse movement...listview vba for excel

    Hi luca90,
    do you mean in treeview?
  13. Re: "Method or Data Member Not Found" VBA issues in excel

    Hi BettyCrocker,
    The highlight first line will be yellow to indicates error in routine.
    If you scroll down the actual error line will be highlight too in blue.
    which line is highlighted blue?
  14. MsOf10 Re: [RESOLVED] help with vba control array, i wanna trigger enter and exit event of t

    No problem glad to help
  15. MsOf10 Re: [RESOLVED] help with vba control array, i wanna trigger enter and exit event of t

    to be more specific for userform code with form is named frm

    Option Explicit
    Public Event OnEnter(ctrl As msforms.Control)
    Public Event OnExit(ctrl As msforms.Control)
    Private oXitClass As...
  16. Replies
    2
    Views
    2,529

    Re: Compile error method or data member not found

    Better to use a userform than the troublesome date picker
    Help of reputable freebees about I use this one
    http://www.excel-it.com/excel_datepickers.html
  17. MsOf10 Re: help with vba control array, i wanna trigger enter and exit event of textbox arra

    is this what you are after?...


    Userform code


    Option Explicit
    Public Event OnEnter(ctrl As msforms.Control)
    Public Event OnExit(ctrl As msforms.Control)
    Private oXitClass As CtlExitCls
  18. MsOf10 Re: Multi-dimensional array driving me nuts

    besides
    Public Sub CRestoreFilters()
    Dim w As Worksheet
    ' Dim filterArray()
    Dim currentFiltRange As String
    Dim col As Integer
    you will need to dimension currectFiltRange
    Option...
  19. MsOf10 Re: Multi-dimensional array driving me nuts

    Is the Public FilterArray() dimensioned as a variant?
    Has the filterarray been redim(1 to 3,1 to 3) in a procedure?
  20. MsOf10 Re: Multi-dimensional array driving me nuts

    Hello,
    to access the limit of the array just use
    For col = 1 To UBound(filterArray)
  21. Replies
    17
    Views
    3,821

    Re: How to remove duplicate entries in combobox.

    Its a class formula by DonkeyOte
    Basically as the formula is drag down in the column it compare the list to the target list.
    The REPT("Z",255) is looking at the last string in the drag down list...
  22. Replies
    17
    Views
    3,821

    Re: How to remove duplicate entries in combobox.

    Hi,
    You will want the formula in the sheet somewhere like in the attached workbook
  23. Replies
    17
    Views
    3,821

    Re: How to remove duplicate entries in combobox.

    hi,
    one way is with the formula in the helper column to give unique list
    B2=LOOKUP(REPT("Z",255),CHOOSE({1;2},"",INDEX($A$2:$A$30,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$30,$B$1:$B1,0)),0),0))))
    and...
  24. MsOf365 Re: [RESOLVED] Creating a dynamic graph to visualise movement

    hope this helps.. you can do some crazy stuff with scattered charts
  25. Replies
    5
    Views
    1,131

    Re: [Excel] Row/Col highlight

    no, it was an alternative.
    You can go to File> options > general> personalise your copy of microsoft office >office theme
    you can pick white grey or dark grey theme
    This will change the colour...
  26. Replies
    5
    Views
    1,131

    Re: [Excel] Row/Col highlight

    Hello,
    something like this syntax in the worksheet module maybe better to high light the column and Row, but depends on the sheet format
    Private Sub Worksheet_SelectionChange(ByVal Target As...
  27. Replies
    4
    Views
    954

    Re: Transfer Textbox value to worksheet

    or

    Dim rngNullString

    Set rngNullString = Intersect(ws.Columns("A"), ws.Columns("A")).Find("")

    If rngNullString.Row < ws.Cells(ws.Rows.Count, "A").End(xlUp).Row Then
    Set...
  28. Re: Copy data from one sheet to another sheet based on combobox value

    Hello,
    Maybe ,,,,
    Option Explicit

    Private Sub cmdAdd_Click()
    Dim LastRow As Long
    Dim ws1 As Worksheet
    Dim ws2 As Worksheet
    Dim rng As Range
    Dim rgnSearch As Range
  29. Re: Define numger of decimal places for populated textbox

    Hi,
    If the textbox on a userform then

    Private Sub TextBox1_Change()
    Me.TextBox1.Text = Format(Me.TextBox1.Value, "0.00")
    End Sub
  30. Re: Changing Default Folder in Excel VBA for Application.GetOpenFilename

    Hi NateBrie,
    Its can be solved with APIs
    this is an old snippet of syntax form msdn to try

    Option Explicit

    Private Declare Function SetCurrentDirectory Lib "kernel32" Alias...
  31. Thread: test bbcode

    by pike
    Replies
    0
    Views
    3,207

    test bbcode

    v
    A
    B
    C
    D
    E
    F
    G
    H
    1
  32. Re: Excel VBA Issue: Scroll Bar will Not Appear in Frame Until Click

    can you attach a picture ? Its doesn't sound quite right if the scroll bar is for the tools box
  33. Re: [Excel - Office 2007] EXACT intrinsic function is causing "Sub or Function not d

    hi dynomo
    try..
    Set wb1 = Workbooks("Initial Category List - Final Version.xlsx")
    Set wb2 = Workbooks("Combined product ListUpdate1Macro.xlsm")
    Rri = 251
    With wb1.Sheet1
    ...
  34. Replies
    4
    Views
    1,110

    Re: Join listbox value into one string

    Hi Waka
    you can use the IFF statment to determine if a comma is required

    Dim xItem As Variant
    Dim allstr As String
    With Me
    For Each xItem In .List10.List
    allstr...
  35. Re: Excel 2010 VBA Using Like On a List of Values

    Hi Skywriter
    something like ...
    Sub LetterPattern()
    Dim x As Long, z As Long, nRow As Long
    For nRow = 1 To Cells(Rows.Count, "A").End(xlUp).Row
    ' {"EO-EI-PU-UA-V-FML-STD-WC-J-S-B-OL"}
    ...
  36. Re: Excel 2010 Regular Expression in VBA Code

    Hi skywriter
    .Pattern = "([A-Z]+\s?[A-Z]{0,2}, [A-Z]+\s?[A-Z]{0,1}) (.+) (WATER MGMNT|POLICE|GENERAL SERVICES|CITY COUNCIL) (\d+)"
    is looking for 4 substrings consisting of...
  37. Replies
    3
    Views
    692

    MsOf10 Re: [Excel] City & state dropdowns

    WorkHorse

    In the attached zip file the validation list is in cells B2 and C2 .. with a value from a thrid column in D2
  38. Replies
    3
    Views
    692

    MsOf10 Re: [Excel] City & state dropdowns

    WorkHorse
    try..=OFFSET(Data!$B$1,MATCH(B2,Data!$A$2:$A$290,0),0,COUNTIF(Data!A2:A290,$B$2),1)
    in the example below
  39. Replies
    23
    Views
    15,468

    Re: *** mask password in inputbox

    Kvracing

    try ..
    Option Explicit

    '////////////////////////////////////////////////////////////////////
    'Password masked inputbox
    'Allows you to hide characters entered in a VBA Inputbox....
  40. Replies
    7
    Views
    1,123

    Re: [RESOLVED] advance Search in excel using vba

    no problem the service table adjustment by -6 rows and the bill by -24 rows

    =IFERROR(INDEX(Table1[Service Date],SMALL(IF($A$15&$C$7=Table1[Room Number]&Table1[Guest Name],ROW(Table1[Service]) -6 ...
Results 1 to 40 of 55
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width