A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | Calculation Manual | |
| • | Calculation Option | |
| • | Call routine_name ' call is optional but clearer to new users | |
| • | Call Stack | |
| • | Calling a udf | |
| • | CamStudio | |
| • | Cancel or Pause a Batch | |
| • | CDbl - Convert to Double | |
| • | Cells(i,j).select | |
| • | Cells(i,j).Text | |
| • | Cells, Rows, Columns and Ranges | |
| • | Cells.autofilter field=lCol, Criteria1:="=*IBM*", Operate:=xlOr, Criteria2:="IBOR*" | |
| • | Cells.Clear - Clear all cells | |
| • | Cells.Rows.Count | |
| • | Cells | |
| • | center in excel - application.width / 2 | |
| • | Change Log | |
| • | ChDir - Files | |
| • | Check a result and take an action | |
| • | Check Input Data | |
| • | check_include - udf db implements sql include logic | |
| • | check_include(sSQL,"") - udf db | |
| • | CheckDatabase - udf | |
| • | CheckForUnadjustedSQL(sSQL, sNote) - udf db looked at SQL and searched for a table that shouldn't be used | |
| • | CheckIfLocked - internet - code to check if the desktop is locked | |
| • | CheckListForMOM - Automates a checklist that person used to verify data | |
| • | CheckScheduleSendMail - udf - email | |
| • | Circular Reference | |
| • | cl - udf - converts a # to the AA format | |
| • | Clear Method - Home > Editing (5 options) | |
| • | ClearClipboard - udf - Report Engine | |
| • | Click a button | |
| • | Click an item in the Quick Access Toolbar | |
| • | Click an Item on the Ribbon | |
| • | Clipboard - basic | |
| • | Clipboard routines | |
| • | Close #x ' Close a seq file | |
| • | Code indenting | |
| • | Coding Standards | |
| • | col variables - stores the number of a column which is retrieved via FindDataCol in case column moves (Hardcoding) | |
| • | Collapse/Expand outline | |
| • | Collections | |
| • | Color Dialog | |
| • | Colors in vb Editor - Green - comment - blue Excel statement ; red = syntax error | |
| • | Column references | |
| • | ColumnLetter - udf - converts a column # to a column letter | |
| • | Columns - basic | |
| • | Columns("A:A").ColumnWidth = 7.43 - recorded | |
| • | Columns("A:P").clear | |
| • | Columns("H:I").NumberFormat = "#,##0" | |
| • | Columns(1).select - selects a column | |
| • | Columns.("A:E").EntireColumn.AutoFit | |
| • | ColumnWidthToPixels - internet code | |
| • | ColumnWidthToPixels - internet code (Data accuracy report) | |
| • | commenting code | |
| • | Companies Have Unique Language - first day on the job story | |
| • | Company Language Issues and Excel | |
| • | CompareTwoFiles() - udf | |
| • | Compatibility Mode | |
| • | CompatiblityCheck | |
| • | Compile | |
| • | Compress Large Excel Workbooks | |
| • | ComputerName - internet - Gets users computer name using ActiveDS.WinNTystemInfo | |
| • | Concatenate a string to create a range | |
| • | concatenation - & | |
| • | Conditional - Or vs. And vs. Not , precedence, ( ) and nested | |
| • | Conditional operators | |
| • | Config | |
| • | Confusing in Excel | |
| • | Connection Sting | |
| • | Constants | |
| • | Constants - Const SW_SHOW = 1 | |
| • | Convert formulas to values | |
| • | Convert2link | |
| • | Copy | |
| • | Copy formula c7 - B7 and get weird values and need to do =if(c7="","",C7-B7)🔝 | |
| • | copy modules in and finding all the syntax error | |
| • | Copy Transpose | |
| • | CopyChartToPPT ... udf - very important | |
| • | CountFiles(sDir, sFilter) | |
| • | CountIfString(sCol,sValue) - counts the # of times the svalue appears in sCol | |
| • | CountUnique | |
| • | Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows) | |
| • | Crawling Ants | |
| • | Create a Drop-down web menu using Excel | |
| • | Create a Sheet with a number of columns to run queries and process Excel output | |
| • | Create HTML files | |
| • | Create Look - Idea - Dev Small - fix - works - New ideas/problems - Repeat | |
| • | Create sheets from a list | |
| • | Create syntax error to save a location you want to go back to | |
| • | CreateDirectories | |
| • | CreateDirs | |
| • | CreateHTMLTableForEmail (html, css,) - coverts spreadsheet visible data to HTML format | |
| • | CreateQueryTable - db - | |
| • | CreateSheet "name" - adds a new sheet and deletes current one??? udf | |
| • | Creating a folder | |
| • | CSV file | |
| • | Cusip Problem | |
| • | Custom Lists | |
| • | CVDate(string_field) |