Search results 74

Sorted from new to old.

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

SQL Related posts

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

2022Jul6

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

Quarter_to_Words

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

2020Dec17

Paste into textbox

Paste text from clipboard into textbox Needs Userform, textbox, commandbutton

2020Oct11

Input text - pre-Placeholder

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

2020Oct10

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

UI_2ValidationsUpdate

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

2020May27

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

1 2 3 4 5