Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Previous code to select 1 of multiple selections not working

    I have code to open 1 of multiple folders, depending on the selection. Previously it worked like a charm. Now it hangs on MyFolder. I have no idea what is wrong. I have trouble shot it, & it hangs on...
  2. Replies
    19
    Views
    458

    Re: VBA Code to Clear Cell

    My bad. you are correct, it is not my Thread, it won't happen again.
  3. Replies
    19
    Views
    458

    Re: VBA Code to Clear Cell

    Hi Fluff. Now I feel like a complete idiot. I closed with out saving & reopened. Apparently something changed. I just love technology. than for responding so quickly.
  4. Replies
    19
    Views
    458

    Re: VBA Code to Clear Cell

    What about cells where the value is greater than 1. I.e. 10, 11.....19?
  5. Re: Complex Yes/No Mesg Box Pop Up prior to deletion.

    Problem solved.

    Here is the code:


    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)


    'This code is activated if the delete key is activated,
  6. Re: Complex Yes/No Mesg Box Pop Up prior to deletion.

    :) :confused: Ok. I have one problem, I have not been able to resolve. I have code that runs when change occurs in range M3:M329. When "Pending" is entered the 1st one runs, & the 2nd one runs....
  7. Complex Yes/No Mesg Box Pop Up prior to deletion.

    :confused: I am trying to code a pop up when the user deletes "Pending" Column M. I have searched for samples where; entry was deleted & the message had Yes/No response. I have a previous message...
  8. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    True. But again my boss. Is there a link you could direct me to.
    Here is my 1st attempt at looping:

    Private Sub Worksheet_Calculate()
    If Range("X4:X17").Value = "True" Then
    MsgBox "Hi"
    Else...
  9. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    This is my first attempt at looping. Please forgive me for a lot of questions. Column Y has the following formula =AND(W4=TRUE,X=TRUE), this Column is based on Column W & X(both Boolean formulas)....
  10. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    Yep. I just use it, because of my boss. Ok. I will start working on your suggestion, of using the Calculate event by it self. I will probably will not have a chance to get back to you till next week.
  11. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    Column Z has a formula. =IF(Y4, "Yes", "No"). I thought that you couldn't have a formula in a cell.
  12. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    Fluff Thanks. However I was able to pinpoint the problem. I have code to copy the values from Column Z. I tested the code with 1 row of values & it worked. When I did standard range of cells it ran...
  13. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    Ok. Now it is firing if the response Yes or No. However I didn't get this far before.
  14. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    I had tried VBA to copy in Column Z into AA, & I did copy the values only. I as not successful in getting to run as a calculated change. The 1 question I have, is it possible to have it fire wit...
  15. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    It did fire because as Fluff said change events don't work with formulas & it was based on column W( no formula).
  16. Replies
    17
    Views
    507

    Re: Looping through cell & generate Msg Box

    No response or error message. The bottom line, is that I am trying to have the error message pop ug & the other file called when "Yes" is in Column Z. Here is a link to one drive for a sample. I...
  17. Replies
    17
    Views
    507

    Looping through cell & generate Msg Box

    I am trying to I am trying to write a macro to loop through a column (Z), & find the cells with a "Yes" in them. When a Yes is found I am trying to generate the following Msg “"Check to verify...
  18. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    I can not thank you enough for your assistance & patience. Once I had a chance to really study your formula, it is so simple & easy to understand. Again thank you.
  19. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    Sorry. I found I had some typos in the last posting. Here is the corrected posting.
    O4 is populated “No”, P4is empty, Q4is populated with “Yes”,R5 is populated with “Yes”; the expectedresponse for...
  20. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    Here is are some examples. O4 is populated “no”, P4is empty, Q4 is populated with “Yes”,R5 is populated with “Yes”; the expectedresponse for N4 is “No”.
    O5 is populated “Yes”,P4 is empty, Q4 is...
  21. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    Sorry being so unclear. I just learned that I need a yes/no response for the range.
    If the response "Yes" in that range N4 is populated with NO, & "No" in the range N4 is populated with Yes.
  22. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    Thank you Aladin Akyurek. That worked. I replaced ? with "".
    1 final question. Can you lead to a link where I can combine this with similar formula. =if(countifs(O4:R,"No"), "Yes","")
  23. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    I just tried your newest formula. I found that if Yes is entered, the is nothing in cell N4. If No is entered, There is ?. I need to have No in N4. If there is a Yes response in the range indicated.
  24. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    The only one I track is Yes. The example you stated earlier is possible.
    O4=yes
    P4=No
    Q4=No
    R= No
    I have the cell conditionally formatted to hide the No responses, but if the user hovers over...
  25. Replies
    21
    Views
    593

    Re: VLOOKUP formula not working.

    The formula works. just not as I thought it would. The only answer that you will have in Range O4:R4 is either Yes or no. N4 should only fill with "No" if there is a Yes in O4:R4. The formula as...
Results 1 to 25 of 117
Page 1 of 5 1 2 3 4