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.

Transfer or transfer without repetition of values from your UserForm (Watch the Video).

Delete simply or delete after confirmation (Watch the Video).

Modify and save your new values (Watch the Video).

Search in a column, cell, TextBox, or everywhere (Watch the Video).

Reset your fields in the UserForm after the transfer or upon opening your application (Watch the Video).

Stop the systematic refresh of your UserForm using the Anti-vibration code (Watch the Video).

Ensure that the Excel application closes when your UserForm is closed (Watch the Video).

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: