Irregular “Non-consecutive” UserForms transfer

Here you can,

Transfer data from a UserForm to a Spreadsheet. To make this easier, this sheet will now be called the “Database”. The transfer is made to a sheet whose destination columns do not follow each other. e.g., transfer to cells that are in columns A, D, E, etc.

ransfer, transfer without repetition of values or Transfer by automatically inserting a unique Reference number,

Simply delete or delete after a confirmation,

Edit and save your new values,

Search in a Column, Cell, TextBox or Everywhere,

Reset your fields in the UserForm after the Transfer or as soon as you open your application,

Stop the systematic updating of your UserForm using the Anti-vibration code,

Make the Excel application Quit when you close your UserForm

Simply, insert the requested value in the box, click on the “Get the Code” button and Hop, the code appears in the square at the very bottom of the page… copy and paste it into your UserForm…That’s it 🙂

Name TextBox of Search:

Name of DataBase:

Name of the 1st Column in DataBase:

Name of the UserForm: