Search results 461

Sorted from new to old.

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

OnChange

Detect when user changes a textbox using JQuery Needed to have this documented ...

2018Dec29

Prevent Submit until reCaptcha

Disable Submit button until Google reCaptcha is verified, used reCaptcha v2.0 ...

2018Dec20

IsBin

Checks if the passed argument is a binary or not

2018Oct16

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24

PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

1 2 ...20 ...28 29