Search results 125

Sorted from new to old.

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Shape_Select_or_CreateThenSelect

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

2022Jul21

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

Execute exe embedded in Excel

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

2021Apr16

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Paste into textbox

Paste text from clipboard into textbox

2020Oct11

ANStrSort2

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

2020Sep24

iframe link to parrent

Link to the parent from inside an iFrame using JAVA

2020Feb3

Barcode Generator

Pure ASP Classic barcode generator This is one of my past findings, I will be ...

2020Feb1

1 2 ...5 ...7 8