Skip to content

Instantly share code, notes, and snippets.

View Zadigo's full-sized avatar
🌴
On vacation

John PENDENQUE Zadigo

🌴
On vacation
View GitHub Profile
@Zadigo
Zadigo / DynamicMacroShapes.bas
Last active October 25, 2017 18:15
Assigning a macro to any given shape in Excel
Option Explicit
Sub assign_MacroToShape()
'
' This macro assigns a macro to a given shape
'
'Set variables
Dim active_Book As Workbook
Set active_Book = ActiveWorkbook
@Zadigo
Zadigo / DynamicBorders.bas
Created October 25, 2017 18:08
Create table borders anywhere in Excel
Sub create_Table_BordersAnywhere()
'Get current range selected
Dim current_Selection As Range
Set current_Selection = Selection
'Set in range
Dim create_Table As Range
Set create_Table = Range(current_Selection.Address)
Dim elements(5) As String