Random codes

Random 24 Codes by our developers.

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Most recent in Oracle DB

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

2020Feb7

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

Textbox.io textarea editor

An embed text editor for bootstrap Get official latest release from

2019Jan18

ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

List and delete files

Enables users to list and delete files

2018Apr23

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

Webapp-ScrollAreas

Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...

2018May19

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

CSS loading spinner

Nice simple CSS loading spinner

2019Feb16

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

Jul27

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

PI

Returns a double representing the mathematical constant Pi

2018Jul5

CSS Buttons B4BS

This was used widely on my end before we got Bootstrap. Still have potential ...

2019Jan15

MetricToUSStandard

Converts a Metric Measure into a US Standard Measure. Arguments: ...

2018Jul17

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

CSVs2Sheets

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

2021Oct5