Search results 208

Sorted from new to old.

CellSave_Hyperlink

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

2018Aug9

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

Prn

Printout into page, along with additional function to decide where to put the ...

2018Aug5

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26

VB6Format

Trying to create VB6 "Format" function in Classic ASP, works now for date only, ...

2018Jul24

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

WeekNum

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26

CanAccessVBA

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

2018Jun22

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

BrowseFolder

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

2018Jun14

1 2 ...12 13