Search results 148

Sorted from new to old.

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Excel sheet textbox

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

2020Feb22

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

1 2 ...5 ...9 10