Posts by Pedro003

    Hi guys, I have this code, this makes an autofilter in real time, all right, but when I put some number for filter in column with numbers this show nothing, whats wrong? pls help


    Hi guys, I have this table


    And this code, this code makes an autofilter in real time, the problem is when I have a filter on anyone row, the code only search with the filtered information but not with all information from the table, how can i make the code search entire table?

    Hi guys, I have the next code, this is a real time autofilter on excel

    I want to when the text box its clean this filter with criterial "PENDIENTE" o field 15, but this not work, whats wrong?, with the button }works but with clean text box not work.

    Hi guys, how I can combine this two code for worsheet_change?


    Code
    /CODE FOR COLUMN O/
    Private Sub Worksheet(ByVal Target As Range)
    On Error Resume Next    With Target    If .CountLarge > 1 Or .Column <> 15 Then Exit Sub        .ClearComments        On Error GoTo 0        .AddComment        .Comment.Text Text:="Recepcionado el " & Format(Date, "long date") & " por: " & Application.UserName        .Comment.Visible = True    End With
    End Sub
    
    /CODE FOR COLUMN P/
    Private Sub Worksheet_2(ByVal Target As Range)
    On Error Resume Next    With Target    If .CountLarge > 1 Or .Column <> 16 Then Exit Sub        .ClearComments        On Error GoTo 0        .AddComment        .Comment.Text Text:="Confirmado el: " & Format(Date, "long date") & " por: " & Application.UserName        .Comment.Visible = True    End With
    End Sub

    Hi guys, I have this sample formula

    Quote

    =IF(O78="RECIBED";TODAY();"")

    this is in the cell O79 for example, but I want when I write RECIBED on the O78 cell in the O79 cell show de date of the day of modification, cause I need a date of RECIBED and I'm looking for it to be automatic :P

    Hi dears, I have mi data base on excel with trucks, I have DT trucks and numbers trucks ex:

    B1= 100

    B2= 101

    B3= 102

    ...

    B50= 150, you know, continuous number, en this its easy cause I need displace the cell, but when I have a DT its like this

    B51= DT

    B52= 151

    And my question: How I can put DT on the cell but make the down cell omit that DT and continue with de last number? :(


    Hi, how can i change the code for send a pdf file from my computer?

    Hi guys, I have mi excel with a button in each cell like img, this is for print de information to that row, I have the next code for that:



    But that code is for print de information of the row of the active cell, but when i press de button print that not active the cell, that is my question, how can i do that when i select de img to print the cell also activated?

    Hi dears, I have this code


    Range(activecell, Activecell.end(xlToLeft)).copy


    But the code onlye select to the empty cell, how I can i make it select all cell and empty too?