• 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.

Recent content by Belleke

  1. Belleke

    Searchable ListBox with Multi Tab

    1. Have a look at the properties of the listbox. (ColumnWidths) 2. For the column headers I used 2 labels. If you want headers in the listbox you have to use RowSource instead of List and I never use RowSource. (I was told once RowSource is for people that use VBA but don't know VBA;))
  2. Belleke

    Searchable ListBox with Multi Tab

    Glad to help.:)
  3. Belleke

    Searchable ListBox with Multi Tab

    Like this?
  4. Belleke

    Searchable ListBox with Multi Tab

    Here you are.:)
  5. Belleke

    Searchable ListBox with Multi Tab

    Hi, Like this? Don't forget to change the correct path in the code first (3x) No need to open Data file. When the user form is opened, Warehouse 1 is loaded. If you change to tab 2 then Warehouse 2 is loaded, if you go back to tab 1 Warehouse 1 is loaded. When you use the search function, the...
  6. Belleke

    print data in userform list box

    Like this? Change Sheetname with the real name of your sheet where the listbox records have to go. Put the code under a button, make sure the name of the button and the buttonname in the code are the same. Private Sub CommandButton1_Click() With Sheets("sheetname") .Range("A" &...
  7. Belleke

    Hiding Formulas in a unprotected sheet

    The code goes in a normal module not in ThisWorkbook module.
  8. Belleke

    Hiding Formulas in a unprotected sheet

    Maybe with something like this? (without a sample) Sub Protect_All_Formula_cells() On Error Resume Next Application.ScreenUpdating = False For i = 1 To Sheets.Count With Sheets(i) .Unprotect Password:="password" With .Cells .Locked = False .FormulaHidden = False End...
  9. Belleke

    Populate dropdown list, lookup and create pdf in VBA

    Does this help? Keep the excel file in the same folder as the Quotes (PDF) folder.
  10. Belleke

    Help in VB Code, Save PDF File on same file location and then in a folder

    The VBA code in your file is password protected.
  11. Belleke

    Vlookup with Two Userform Inputs

    Hi, You did it pretty well. It was partly my fault, now that I've looked at your file it's clearer. First remark, avoid using AddItem,it is a slow way to fill combo-en listboxes. Wat did you do wrong. To fill the listbox you used With LB_00 .List = [ITs].Value .ColumnCount =...
  12. Belleke

    Vlookup with Two Userform Inputs

    You get this error because you don't have 31 Columns in your listbox. (listbox start with column 0) Name your textboxes as I do and start with T_00 OR T_01 assuming we have 10 textboxes then you use For i = 0 To 9 or For 1 T0 10. To start in Column T For the Add New Record button Change...
  13. Belleke

    Vlookup with Two Userform Inputs

    Glad to help:)
  14. Belleke

    Vlookup with Two Userform Inputs

    Like this? See attached
  15. Belleke

    Vlookup with Two Userform Inputs

    Hi, See attached. You kan add a comment with de edit button. Comment is added in column A, but you can easy change it. in de Edit Record button code change the 1 with the column number you want. ws.Cells(fnd.Row, 1).AddComment T_18.Value
Top