davesexcel.com

Excel information

EXCEL VBA CODES

VBA Codes

VBA Codes

Revised Codes

 

Old Looping Code

 

 

Copy and Paste to Next Sheet

 

 

Copy and Paste Row to Next Sheet

 

 

Copy and Paste Column to Next Sheet

 

 

Copy and Paste Range to Next Sheet

 

 

Loop Template Code- Start your loop with this.

 

 

Add an Item to the right click menu

VBA Codes

Adding an Item to the right click menu

Right ClickIf you want to add an item to the right click menu, This is a way to do it.

The below code belongs in a Regular Module. Hit Alt & F11 then select insert module and paste the code there.

The below codes belong in the Workbook Module

Right Click

 

 

Right Click on the worksheet, select "Show Message" and the message box appears.Right Click