Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    87

    Re: All Excel sheets combine into one sheet

    So are all columns identical? Are there duplicates? Will the duplicate rows need to be 'handled'?
  2. Replies
    5
    Views
    188

    Re: Color every second Row

    Start here...


    Sub ColorIt()
    For Each sh In ThisWorkbook.Sheets
    If sh.Name <> "Data" And sh.Name <> "FrontPage" Then
    For i = 0 To sh.UsedRange.Rows.Count
    ...
  3. Replies
    18
    Views
    446

    Re: Workbook should not open - code require

    Try this.



    Private Sub Workbook_Open()
    Dim myDate As Date
    Correct_Password = "test" ' Set this to the password you want.
    myDate = "8/7/2019" ' Set this to the...
  4. Re: Repeating my code until the last row of data

    Are you asking to have this code run against the last row of your sheet or are you asking for this code to run on every line of your sheet, all the way down to the last row?
  5. Re: Check a list of values against multiple columns and output a list that appears in each?

    Let me know how close this gets you..




    Sub Go_Baby_GO()
    With Sheets("Sheet1")
    mArr = .Range(.Cells(1, 1), .Cells(.UsedRange.Rows.Count, .UsedRange.Columns.Count))
    For y...
  6. Re: Check a list of values against multiple columns and output a list that appears in each?

    Okay. I am working on something else at the moment. What you need can be done. If someone doesnt beat me to it, Ill get it written sometime this afternoon I think.
  7. Replies
    4
    Views
    157

    Re: File open with textbox entry.

    Try this instead..




    Sub File_Picker()
    Dim MyFileDir As String, FName As String, myXLFile As String, FirstTime As Range
    MyFileDir = "P:\Production\Hours ReportingArchives"
    With...
  8. Re: Check a list of values against multiple columns and output a list that appears in each?

    Have you tried VLOOKUPs?

    https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
  9. Replies
    8
    Views
    177

    Re: Force certain Values in Input Box

    WAY ahead of you. Reading all about it now. Cannot believe I have coded VBA for this many flippin years and never ran into the Like operator.


    I have been using inStr inside of do/loops to...
  10. Replies
    3
    Views
    146

    Re: user form Check box, recheck with code

    Can you please comment out the code i quoted jsut above using the ' and try using my code instead? This REALLY needs cleaned up so that is more readable and debuggable. I will guide you through the...
  11. Replies
    8
    Views
    177

    Re: Force certain Values in Input Box

    I hate to admit it, but i have not seen that one before. Impressive.
  12. Re: Mass Userform Textbox formatting as number via AfterUpdate()

    This cant be done. A textbox contains "STRING" values.

    However, you can refer to the TEXT contained and convert it..

    For example. If we take textbox423 and you type the number 423..



    ...
  13. Replies
    4
    Views
    157

    Re: File open with textbox entry.

    Try this..



    Sub File_Picker()
    Dim MyFileDir As String, FName As String, myXLFile As String, FirstTime As Range
    MyFileDir = "P:\Production\Hours ReportingArchives\"
    With...
  14. Re: VBA to take a Random 10% sample of rows with data in column A.

    Please clarify both of your requests. Provide me some examples if possible. I have no doubt what you want is possible. I just need to make sure I fully understand it.
  15. Re: Opening Excel File - Every tab viewed automatically

    I figured it would be a silly add-in. Those rascally buggers have given me some of the strangest behavior's ive ever seen in Excel.
  16. Re: Opening Excel File - Every tab viewed automatically

    So it was an add-in then?
  17. Re: Adding a Message Window if files are not found in folder

    Glad to help! Let us know if there is anything else.
  18. Re: Opening Excel File - Every tab viewed automatically

    Also, check your Add-Ins and make sure something silly hasnt made its way in.
  19. Re: VBA code to Save As in Current Folder and a Cell Dependent Name

    Happy to help! Feel free to throw a like on the code.
  20. Re: VBA code to Save As in Current Folder and a Cell Dependent Name

    Sub SaveAs()
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & ThisWorkbook.Name
    'ActiveWorkbook.SaveAs Filename:=ThisWorkbook.FullName 'This...
  21. Re: Adding a Message Window if files are not found in folder

    Sub Check_Exist()
    'Set your variables accordingly...
    'strFULLPATH = "C:\Users\Steve\Desktop\Test
    'strFILENAME = "REPORT_NAME.xlsx"
    If Dir(strFULLPATH & "\" & strFILENAME,...
  22. Replies
    2
    Views
    196

    Re: Have a Yes/No show up based on table data

    I feel like you need a macro.
  23. Re: Combine two Private Sub Worksheet_Change formulas

    How about this?




    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$F$2" Then
    Range("F3").Value = ""
    End If
    If Target.Address = "$F$3" Then
  24. Replies
    1
    Views
    106

    Re: Creating generic update statement

    My Insert code requires it be fed an array. I have included one of my array constructors so that you can see the dimensions/whatnot for the array you will need to to construct...



    Function...
  25. Replies
    3
    Views
    184

    Re: Button show hide on load of excel

    Create a form. Put two buttons on it. Paste this code...



    Private Sub CommandButton1_Click()
    CommandButton1.Visible = False
    'CommandButton1.enabled = False ' This is useful too.
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4