Search results 60

Sorted from new to old.

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

ShapeDelete

Safely remove certain shape from worksheet

Sep30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

Custom Excel UI ribbon

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

May11

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

2024Jan18

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ChartLabelsNumberFormat

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

2023Dec23

Send page to print

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

2023Aug11

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

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