Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    Hi Mumps,

    Your code works splendidly. :)

    God bless you! :beerchug:
  2. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    Hi Mumps, I just want to thank you for your patience with me.

    I am new to VBA and to this forum, so thank you for bearing with my incompetence. :rofl:

    However, the above macro you sent me isn't...
  3. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    Hi, mumps

    So sorry for not pointing this out earlier, but the column A and B of my master file, worksheet "MrExcel" isn't in the same order as the column A and B of my source file, worksheet...
  4. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    Hi mumps,

    I did a test run of your code by having M7 and down contain ALL Y. On the master file, it didn't highlight ALL of column A7 and down.
  5. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    If possible, can you comment each line of code and explain what it is doing?

    Thank you so much!:cool:
  6. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    Ah sorry, I put the wrong comment in my code. It should say 'checks M7 to last row', 'checks T7 to last row', and checks 'AA7 to last row'.
  7. Re: Check 2 cells from source to master file, if match, highligh cell X in master

    The other two are "T" and "AA".
  8. Check 2 cells from source to master file, if match, highligh cell X in master

    Hi all,

    Context: I have three error-checking columns in source file, worksheet "MrExcel". If there is a Y in any of the columns, goto columns A and B. If columns A and B matches with columns A...
  9. Re: Highlight one workbook cell if another workbook cell has a value

    Closed. I no longer need help for the above.

    Thanks though!
  10. Re: VBA Loop instead of Conditional Formatting

    Yep. I meant to say I got IT to work. Thanks!
  11. Highlight one workbook cell if another workbook cell has a value

    I have two workbooks: master and source workbooks.

    I am trying to have an error checking tool that when a certain cell in the source cell has value "Y", then the a cell in the master file will be...
  12. Re: VBA Loop instead of Conditional Formatting

    Hi DanteAmor,

    Sorry if I wasn't being clear. I got to work by editing a few parts of your sub, so it was great that I had something to go off of.

    Thanks!
  13. Re: VBA Loop instead of Conditional Formatting

    I am going down the column in pairs and checking the numbers.

    Going off of your table above, the macro would first start at C7. It would check whether or not 1 or 4 is greater than the other 3x....
  14. Re: VBA Loop instead of Conditional Formatting

    Hi DanteAmor,

    The code doesn't work when I put in dummy data. When I removed On Error Resume Next, I got division of zero error by

    If c / c.Offset(1) >= 3 Or c.Offset(1) / c >= 3 Then...
  15. VBA Loop instead of Conditional Formatting

    I am completely stuck on this one.

    I have twenty seven columns I wish to format, however I feel conditional formatting might slow down my workbook.

    There are three columns per sheet, with a...
  16. Re: Copy 3 Dates from one worksheet to the next

    Solved. How do I delete this thread?
  17. Copy 3 Dates from one worksheet to the next

    Context: The dates that I'm trying to copy are side by side.

    I am getting an error message when I run the code:



    Public wsMT As Worksheet

    Master_File = ThisWorkbook.Name
    Set wbM =...
  18. Re: How to detect if multiple checkboxes are selected

    Thank you Yongle!

    Everything works now :)
  19. Re: How to detect if multiple checkboxes are selected

    Sheet_A
    Sheet_B
    Sheet_C

    are the names of the checkboxes.

    I changed your code because I didn't want the checkboxes to be named cb_Sheet_A, as it's not user-friendly.
  20. Re: How to detect if multiple checkboxes are selected

    Hi Yongle,

    Your macro works perfectly! However, since each worksheet requires a different macro, a For Each loop wouldn't work.

    How can I extract worksheet names from the List array and set...
  21. Re: How to detect if multiple checkboxes are selected

    Hi Yongle, thank you for the quick response.

    It works!
  22. How to detect if multiple checkboxes are selected

    I am creating an userform that have checkboxes users can tick off, and then press select files.

    I already have working code that corresponds to each of the checkboxes users can select, however I...
  23. VBA Index Match doesn't allow spaces?

    Context: I am trying to automate a task through a macro. I have a source file and a destination file and dumping in specific data from the source file onto the destination file. However, since the...
  24. Replies
    3
    Views
    161

    How many lines of code can VBA run?

    When I run my code in debug mode, line by line, it works.

    However, when I run it as a macro through a button, the macro stops abruptly
    about 1/5 through the entire code.

    Any ideas why this is...
  25. Replies
    3
    Views
    162

    Re: Can variables hold methods?

    Thank you!
Results 1 to 25 of 26
Page 1 of 2 1 2