Search results 199

Sorted from new to old.

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

User profile card - BS4

Profile card, in Bootstrap 4, used in this website here, with several options ...

2019Feb8

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

2018Nov25

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

2018Sep2

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

2018Aug25

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

1 2 ...9 ...12 13