Posted on

Find Last Entry in SQL

SQL Statement to find last entry from MS Access using in VBA

 

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

Userform Zoom

This code will help user to make ZOOM feature on Excel /VBA Userform Just Change the value  on me.Zoom + Value

 

Posted on

Userform Resizable

Reference :here

This code will help user to make Userform resizable.

 

Posted on

Userform position

This Code will help user to set position at the time of initialization of UserFrom

 

Posted on

Multipage Position on Userform

Help user to adjust Position of Multipage when Userform  Size changed

 

Posted on

Upload data line wise excel to access

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

 

Posted on

Unselect /Deselect Cell from range

There are many time when user selected many different cells and then need to remove some selected cells, Below piece of code will help to do that

 

Posted on

Unmerged cell

When user needs to unmerged some selected range only.

 

Posted on

Unique value from Excel Data

Copy only unique data from range (No duplicate).