• 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

    Can you help me with ListBox Code Please?

    Thanks for the feedback.:)
  2. Belleke

    Can you help me with ListBox Code Please?

    This time send beer:cool: See attachment
  3. Belleke

    Can you help me with ListBox Code Please?

    Send more coffee:DD See attachment.
  4. Belleke

    Can you help me with ListBox Code Please?

    See attachment. What did I change? I changed the data list into a table. I added an automatic number, this number is used to find the correct row to edit or delete. Start typing in the search box, data that do not meet the search criteria will be removed from the list. Select a line in the...
  5. Belleke

    Populating Userform from table and change table entries

    NEVER use merged cells together with VBA, to start with remove the merged cells in the report sheet, then I can help you further. I should add an extra column with an unique number.
  6. Belleke

    Help With Code

    Something like this? Zip file contains excelfile and a folder, keep them together.
  7. Belleke

    Help With Code

    Something like this? Sorting happens when you save.
  8. Belleke

    Help with Textbox Time Display

    Like this?
  9. Belleke

    How to insert pdf into a userform

    You have to use a webbrowser element in your userform. See example. Unpack and put a few pdf's in the folder named PDF and open the excel file
  10. Belleke

    Renaming a file names in folder.

    You can use this. https://www.bulkrenameutility.co.uk/ Select the files you want to change in the top window In the replace textbox of the program type _Translated.docx and leave the With texbox empty and click the Rename button. Done.
  11. Belleke

    Recipe Book

    Something like this?
  12. Belleke

    I need your help with Copy and Paste VBA Code.

    Thanks for the feedback.:)
  13. Belleke

    Subscript out of range error

    I MEN and SAD use there own computer you can use Environ("username") In the ThisWorkbook section On top of your code, just under Dim c As Long add this line of code. If Environ("username") = "MEN" Or Environ("username") = "SAD" Then GoTo nolog And add these lines of code at the end just under...
  14. Belleke

    I need your help with Copy and Paste VBA Code.

    There are known problems with the DataObject on Windows 8 or later. You would be well advised to use API calls instead. See the example. Module 1 is just to open the form In module 2 you find the Declarations and Routine to put the text in the clipboard. The code for your button Private Sub...
  15. Belleke

    User Form text box issue

    First code wil pop up a message that the format has to be 00:00 format when you enter the Starttime textbox Private Sub TextBox3_Enter() MsgBox "Start time need to be in 00:00 format only.", vbExclamation, "Use correct format" End Sub The second code will correct to 00:00 if the user used...
Top