Codes Required

Card image cap
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

Similar codes

Card image cap
CTRL+K,C

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

2019Jan5

Card image cap
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

Card image cap
FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Dec29

Card image cap
Show/hide ribbon

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

2018Dec30

Card image cap
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Card image cap
RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

Card image cap
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

Recently by developer

Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Random Codes

Card image cap
WinXP css theme

CSS theme to show page as windows style, this one is WinXP

May30

Card image cap
ReadBinaryBuffer

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

2023Apr30

Card image cap
MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

2019Oct20

Card image cap
Tabs12 in BS4

More Tabs in Bootstrap4, non-default that is smooth look, and elegant

2019Feb4