• 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

    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
  2. 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...
  3. Belleke

    Generating two values from a mean

    Does this help? Orange fields are formulas.
  4. 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)
  5. Belleke

    diference in transportcost

    Thanks for your response. I will check the original file
  6. Belleke

    diference in transportcost

    See example I am looking for a formula that calculates the cost under 15.000 km at 0.018 and the difference above the 15.000 at 0.022 and make a total
  7. Belleke

    Formula will not auto update when sheet is protected

    Where is your example???????????????,
  8. Belleke

    Copy cell to column of another sheet

    Glad to help an thanks for the feedback :)
  9. Belleke

    Copy cell to column of another sheet

    Like this?
  10. Belleke

    Need to Split Days, Month & Year from Date

    =DAY(A2) =MONTH(A2) =YEAR(A2)
  11. Belleke

    Drop Down List items to make different things happen

    This is not a photoshop forum, so please post an excel example not some pictures.
  12. Belleke

    Error in my code

    Thanks for the feedback. :) If you have questions or extra info just shoot.
  13. Belleke

    Error in my code

    Removed.
  14. Belleke

    Error in my code

    Like this?
  15. Belleke

    Error in my code

    I don't understand,what can be beter than a good working userform?
  16. Belleke

    Multiple buttons

    Like I said post a real example, excel NOT A PICTURE
  17. Belleke

    Multiple buttons

    Post your real example with some dummy names etc..........
  18. Belleke

    Multiple buttons

    In my example there are no macro's just formulas.
  19. Belleke

    Multiple buttons

    Does this help?,
  20. Belleke

    VBA Macro - invoice - add data to the record fail

    What can we do with a textfile, post an excel example.
  21. Belleke

    Error in my code

    That is what I made until now.
  22. Belleke

    months in service for a given year.

    Thank you :)
  23. Belleke

    months in service for a given year.

    See example
Back
Top