Search results 105

Sorted from new to old.

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

SQL instr

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

Feb3

SQL Cross Apply String_Split with XML Path

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

Jan20

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Multi-Select searchable drop-down in Bootstrap 5

Multi-select drop-down with search in Bootstrap 5 From

2023Nov25

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

1 2 ...6 7