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 |
| • | i = i ' for debugging allows a place to set a break point while doing nothing | |
| • | i = i + 1 ' increment a counter | |
| • | iCnt = iCnt + 1 | |
| • | if - elseif - else - end if - and the final else | |
| • | if .Cells(i,j) ' referencing the with stmt | |
| • | if a * b * c * d = 0 then msgbox "unexpected" (where a is a col lookup | |
| • | If cn.State = adStateOpen then ' db | |
| • | If Day(Now()) <= 19 then | |
| • | if Error = "[Microsoft] [ODBC Driver Manager] Data source..." Then after set gADO and ask to install driver | |
| • | If gADO is Nothing then | |
| • | If input file format changes | |
| • | if not x then | |
| • | If pptshape.name like "xxxxx" | |
| • | If rs.EOF then | |
| • | if rs.fields.count = 1 then | |
| • | if then else end if | |
| • | if x = "scott" then | |
| • | iif(num_rows = 20, 1, 0) - immediate if | |
| • | Immediate Window | |
| • | Import module file and there is a duplicate routine (I named the routine with a suffix "_dbs" for the module | |
| • | InArray(array, the_value) | |
| • | InArray(array,value) - determines if value is in the array - udf | |
| • | Indirect Function | |
| • | InitDB - udf to initialize a database | |
| • | Initiate a task via a button press | |
| • | Initiating Macros | |
| • | Input file format is changed | |
| • | inputbox | |
| • | Insert a column - Columns(lCol).EntireColumn.Insert ' recorded | |
| • | Insert_to_dataissues_click | |
| • | Inserting Objects | |
| • | InsertStoryOrBug | |
| • | InsertSubtaskOrSubbug | |
| • | Install Software in VBA | |
| • | instr( ) - find a string within a string and return the offset | |
| • | instr(lcase(..) ) | |
| • | Int() | |
| • | integers 1000 vs. 1000.0 | |
| • | Interface Concept | |
| • | Intersect | |
| • | Is Nothing - Objects? | |
| • | IsArrayEmpty - udf | |
| • | IsAutorun() - udf looks at the filename if has the name autorun then set flag to true | |
| • | IsBizDay(vDate) | |
| • | IsDataAvailable | |
| • | IsDate(string_field) | |
| • | IsEmpty( ) vba function | |
| • | IsError( ) - vba function | |
| • | IsMissing(var) | |
| • | IsNull |