Search results 109

Sorted from new to old.

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

Old cell value

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

2021Dec30

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

1 2 ...6 7