Random codes

Codes Required

CanAccessVBA

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

2018Jun22

ANmarAmdeen

Similar codes

CTRL+K,C

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

2019Jan5

ANmarAmdeen

Protecting VBA code

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

2022Jul6

ANmarAmdeen

FontAwesome Custom icons issue

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

Dec29

ANmarAmdeen

Show/hide ribbon

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

2018Dec30

ANmarAmdeen

BrowseFolder

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

2018Jun14

ANmarAmdeen

Excel sheet textbox

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

2020Feb22

ANmarAmdeen

RunFromShared

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

2018Aug9

ANmarAmdeen

CanAccessVBA

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

2018Jun22

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

Modal form open Workbook

Do not open workbook from userform after .show

Aug3

ANmarAmdeen

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

ANmarAmdeen

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

ANmarAmdeen

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

ANmarAmdeen