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...
You can use this.
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.
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
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"
The second code will correct to 00:00 if the user used...