• 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

    Display Personalized Message before exiting Excel

    Did you do as I told? Private Sub Workbook_BeforeClose(Cancel As Boolean) Range("A4") = 0 Range("A7") = 0 Range("A10") = 0 MsgBox "Please contact Prince on 0242425696" ActiveWorkbook.Save End Sub
  2. Belleke

    Data Validation Drop Down List - Can you make it have more than 8 lines?

    For a form control Combobox For an active X Combobox
  3. Belleke

    Display Personalized Message before exiting Excel

    Add this line: ActiveWorkbook.Save Private Sub Workbook_BeforeClose(Cancel As Boolean) Range("A4") = 0 Range("A7") = 0 Range("A10") = 0 MsgBox "Please contact Prince on 0242425696" ActiveWorkbook.Save End Sub I changed the way you use the msgboxes when you open the...
  4. Belleke

    Excel Userform ComboBox/TextBox match

    Glad to help.:)
  5. Belleke

    Excel Userform ComboBox/TextBox match

    It is possible but it is a bit tricky. Have a look in the module to see the code. Hoover over the Combobox and scroll.
  6. Belleke

    Excel Userform ComboBox/TextBox match

    Here you go.
  7. Belleke

    Excel Userform ComboBox/TextBox match

    If you get the same result i guess column D data is not included in "TFO_SORs!ItemName"
  8. Belleke

    Excel Userform ComboBox/TextBox match

    Can you post a small example?
  9. Belleke

    Excel Userform ComboBox/TextBox match

    Set it to 2
  10. Belleke

    Excel Userform ComboBox/TextBox match

    In your Combobox properties is column count set to 2
  11. Belleke

    Excel Userform ComboBox/TextBox match

    Private Sub ComboBox1_Click() TextBox1.Value = ComboBox1.Column(1) End Sub
  12. Belleke

    I just don't get Dates and Data.

    In the printpreview menu you can set print active sheet only.
  13. Belleke

    I just don't get Dates and Data.

    Like this?
  14. Belleke

    Two Condition Check

    glad to help.:)
  15. Belleke

    Macro not working in VBA

    Sub SetPDFTemplate() Dim PDFFile As FileDialog Set PDFFile = Application.FileDialog(msoFileDialogFilePicker) With PDFFile .Title = "Select PDF Form" .Filters.Add "PDF Type Files", "*.pdf", 1 If .Show <> -1 Then GoTo Noselection...
  16. Belleke

    Two Condition Check

    Something like this?
  17. Belleke

    User Form With Searchable Combo Boxes

    Thanks for the feedback.
  18. Belleke

    User Form With Searchable Combo Boxes

    Data that do not meet the search criteria disappear from the list
  19. Belleke

    User Form With Searchable Combo Boxes

    This time it worked. I am off to work now but if nobody is before me i provide you with a solution tomorrow.
  20. Belleke

    User Form With Searchable Combo Boxes

    You have to save the example where the userform is included as xlsm. Saving your xlsx without userform as xlsm won't bring back the userform.
  21. Belleke

    User Form With Searchable Combo Boxes

    You made the same mistake (no userform), when you save a example as xlsx, userforms, macro's and code are all removed. You have to save your example as xlsm or xlsb, then post it here.
  22. Belleke

    User Form With Searchable Combo Boxes

    You posted a example without the userform.
  23. Belleke

    automaticly convert cell

    Thanks, ,solved the problem
  24. Belleke

    automaticly convert cell

    When i enter 1234567899, i want the cell changes automaticly into 12-34.-5678.-9\9 formula, vba Cell Properties, every solution is ok. thanks
  25. Belleke

    Enter Key Use In Combobox

    You are welkom.:)
Top