Search results 109

Sorted from new to old.

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

ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...

2018Aug26

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

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

1 2 ...6 7