BoldCodes

VBA-Excel 289 Visual basic for applications that works only in Microsoft Excel, aka macros

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

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

2018Jun24

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

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

2018Jun22

Gets first file found matches a wildcards mask, using Dir()

2018Jun20