Posted on

Excel to Access using VBA

This Piece of Code will help for Data Entry from Excel  to Access and Update  and Fetch data from  Access

 

 

Posted on

Stop Userform Movement

This code will help user to stop movement of userform from one position to another position.

Put this code in module

Put this code in Userfom

 

Posted on

Upload data line wise excel to access

When user wants to upload data from Excel to Access Line by Line

 

Posted on

Unique value from Excel Data

Copy only unique data from range (No duplicate).

 

Posted on

Replace Space in excel

This is formula to use in Excel, So put your main data in Column A and put this formula in Column B and just copy and past value from column B — >  Column A. When you paste Value each time it will remove Spaces.