• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Belleke

    question, I don't want the second msgbox activated.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then MsgBox "Maak eerst je keuze in cel A1", vbExclamation, "Cel A1 is leeg" End If End Sub
  2. Belleke

    Shorter code?

    @ MarcL, thank you for your code, works perfect.
  3. Belleke

    Shorter code?

    Can you give what more explenation, afther beiing in the hospital for almost a year, i lost a lot of my knowledge. I just want to help a friend with his fishing competition.
  4. Belleke

    Shorter code?

    + ? is a typo, it should be +1
  5. Belleke

    Shorter code?

    Case Is = 1 T_00.Value = WorksheetFunction.Max([Nr_1]) + 1 Case Is = 2 T_00.Value = WorksheetFunction.Max([Nr_2]) + 1 Case Is = 3 T_00.Value = WorksheetFunction.Max([Nr_3]) + 1 Case Is = 4 T_00.Value = WorksheetFunction.Max([Nr_4]) + ? Case Is = 5...
  6. Belleke

    how to change formula

    It looks as the result that I want GrathH Thanks. :)
  7. Belleke

    how to change formula

    Example
  8. Belleke

    how to change formula

    =IF(E1="C purchased" to =IF(E11Like"C purchased" How to change?
  9. Belleke

    Embedding the Hyperlink( ) within a string of text

    I don't understand the question anymore that's what happens when you click in the cell. Why, you can't have 2 ore more hypelinks in one cell. What do you want to accomplish
  10. Belleke

    Embedding the Hyperlink( ) within a string of text

    Something like this? Hyperlink in C10
  11. Belleke

    WORD doc Formula for Drop Down list without adding item one by one

    does this help? https://www.exceldemy.com/drop-down-list-in-word-from-excel/
  12. Belleke

    Need Help summarising excel data

    Glad to help. :)
  13. Belleke

    Need Help summarising excel data

    What about this?
  14. Belleke

    Combine this formula so that I get only result when cell is not Blank.

    Thanks p45cal, works perfect. @ vletm, sorry for the mistake, my bad.
  15. Belleke

    Combine this formula so that I get only result when cell is not Blank.

    =IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case")) Now I get Upper Case when cell is empty.
  16. Belleke

    Week-Off Days name

    Good luck with this set up. Suc6
  17. Belleke

    Week-Off Days name

    Something like this?
  18. Belleke

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    Try Sub belle() Dim oTextBox As TextBox For Each oTextBox In ActiveSheet.TextBoxes If oTextBox.Characters.Count = 0 Then oTextBox.Delete Next oTextBox End Sub
  19. Belleke

    vba Code for Make a yellow background, and the writing font should be Bold red for all new, unread emails

    I don't get it. At the top of the message list, above the column headings, are two preset filtering options—All and Unread. When All is selected, every message in the current folder is shown in the message list. When Unread is selected, only the unread...
  20. Belleke

    Generating two values from a mean

    Does this help? Orange fields are formulas.
  21. Belleke

    diference in transportcost

    This one workks =IF(C2<=15000;C2*VLOOKUP(B2;A10:D12;3;0);(C2-15000)*VLOOKUP(B2;A10:D12;4;0)+15000*VLOOKUP(B2;A10:D12;3;0)) I want this something like this =((B10-15000)*D10)+(15000*C10)
  22. Belleke

    diference in transportcost

    Thanks for your response. I will check the original file
Back
Top