Search results 109

Sorted from new to old.

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5

Val2

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

2019Jan3

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

2019Jan1

Show/hide ribbon

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

2018Dec30

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

2018Sep12

TreeView

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

2018Sep2

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

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

2018Aug14

CSSFlowChart

Shows a chart with links, nice sitemap maybe, or just easy way to show ...

2018Aug14

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

InternationalComma

Convert an international numeric with , instead of . Into American style . ...

2018Aug8

MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

1 2 ...6 7