Search results 60

Sorted from new to old.

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Bootstrap 4 progress bars variables

Enhanced way to use progress bars in Bootstrap 4 Using below variable ...

2020Feb1

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

1 2 3 4