Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    2
    Views
    15

    Re: Trigger macro if range contains

    Try this



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A12:A1000")) Is Nothing Then
    If Target.Count > 1 Then Exit Sub
    If Target.Value = ""...
  2. Re: ComboBox selected recordís all columns visible?

    You can give more detail than you have.
    Is the combobox on the sheet? It is a combobox of userform or ActiveX control.
    Or is it a combobox in a userform?
    You have a code to load the data into the...
  3. Replies
    4
    Views
    40

    Re: search and display names

    Following your example: names in B, description in C.
    Write a name in H1 and the result will be in H2 and I2 down.
    Put the following macro in the events of your sheet.




    Private Sub...
  4. Replies
    1
    Views
    15

    Re: Update code for userform source

    You can fill them in the Activate event:



    Private Sub UserForm_Activate()
    Dim sh As Worksheet
    Set sh = Sheets("INFO")
    ComboBox1.List = sh.Range("AY2:AY" & sh.Range("AY" &...
  5. Replies
    3
    Views
    18

    Re: IF to evaluate errors also

    I'm glad to help you. Thanks for the feedback.
  6. Re: From excel timesheet create a import file csv

    If it is difficult for you to explain it with the columns, then upload 2 files to the cloud, an excel file with data, put the column headings in green and the rows in yellow that should be sent to...
  7. Replies
    3
    Views
    18

    Re: IF to evaluate errors also

    Try this

    =IFERROR(IF(B2=0,0,IF(B2>0,E2,F2)),0)
  8. Re: From excel timesheet create a import file csv

    I don't understand your columns, I need you to put the letter of the column, example: A, B, C, D, etc.

    Please, Put the letter of the column.

    - In which column values ​​equal to 0 should be...
  9. Replies
    3
    Views
    61

    Re: Workbook_SheetChange event

    I performed tests with your code and it does not enter a loop.
    Maybe something with your data.
  10. Re: VBA Help - Speed up a For Each Statement

    The problem of overwriting labels is a problem from your original code. I only transcribed your code, including "errors".


    I had to do that code transcript because I don't have the context of...
  11. Replies
    16
    Views
    249

    Re: Select account to send email from

    I guess it's a security issue for email accounts. I hope someone else can help you with the problem. Those are the instructions I know.
  12. Replies
    12
    Views
    187

    Re: VBA If statement

    I'm sorry but I still don't clearly understand what the request is.


    You could explain with an example each of the events you want to validate.
  13. Re: Excel VBA GetFolder from 2 Drive (2 location)

    I'm glad to help you. Thanks for the feedback.
  14. Re: VBA Help - Speed up a For Each Statement

    As I told you to improve the code, I need to understand what you need. And for that you must explain with examples of what you have in your sheets and the expected result.
  15. Replies
    3
    Views
    61

    Re: Workbook_SheetChange event

    Do you have other codes on another or other sheets?
  16. Replies
    4
    Views
    40

    Re: search and display names

    You can put some examples with fictitious data of how your data is on the sheets.
  17. Re: VBA Help - Array Loop Won't Populate Cell????

    I think I sent you the solution to this thread but in another one of your thread.
    The macro I put you uses arrays.
    As I mentioned you should give examples to understand the process.
  18. Re: VBA Help - Speed up a For Each Statement

    Try the following macro.
    Maybe it can be improved if you put a sample with 10 or 15 records per sheet and the result you expect. That way I can understand the process and seek an improvement.


    ...
  19. Replies
    12
    Views
    187

    Re: VBA If statement

    Then you can describe in words what you need.
  20. Re: SumIfs' formula with Multiple criteria including dates

    Hi TroyB, welcome to the forum!

    I show you two ways:

    =SUMIFS(Sheet2!$K$2:$K$21,Sheet2!$G$2:$G$21,Sheet1!A2,Sheet2!$A$2:$A$21,">=01/11/2019",Sheet2!A2:A21,"<=30/11/2019")

    ...
  21. Replies
    5
    Views
    35

    Re: Automated conversion from TXT

    It is right
  22. Re: INDIRECT formula with Relative Column References

    I'm glad to help you. Thanks for the feedback.
  23. Replies
    5
    Views
    35

    Re: Automated conversion from TXT

    Hi @, welcome to the forum!

    Check if the following is what you need, change "myfile" to the name of your file.


    Put the txt file in the same excel folder with the macro.
  24. Replies
    12
    Views
    187

    Re: VBA If statement

    Do you need a cycle to verify the dates you have in the range "B8:B66"?
  25. Replies
    16
    Views
    249

    Re: Select account to send email from

    I understand your concern so that users do not enter to modify the code.


    What I am trying to do is make a test, so you can see with which instruction the email account can change.


    Once you...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4