Search results 74

Sorted from new to old.

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

May11

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

Popup button

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

2022Oct13

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

1 2 3 4 5