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) |