Search results 109

Sorted from new to old.

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

Resize_Me2 + Resize_Me3

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

2020Dec11

BS3 Checks

Check boxes with Bootstrap colors From

2020Oct30

Input text - pre-Placeholder

Remove text when textbox is selected, then put it back if it left empty This ...

2020Oct10

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

Reset ID Column

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

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

1 2 3 ...6 7