Search results 236

Sorted from new to old.

ConvertMultiLine2 + 6

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

2018Jul11

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

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

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

2018Jun6

Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

1 2 ...14 15