Recent content by Belleke

Thanks for the feedback.:)

This time send beer:cool: See attachment

Send more coffee:DD See attachment.

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

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.

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

Something like this? Sorting happens when you save.

Like this?

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

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.

Something like this?

Thanks for the feedback.:)

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

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

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