Resource Detail

Go Back Return to Home
Udemy-Excel 2013-The Ultimate Excel Programmer Course - VBA
Size 1.15 GB
Files 165
Info Hash: 3ECB933FE5F823DA59FC111519F9D64653F76E84
Indexed 2020-05-01 00:00:00
Updated 2020-05-01 00:00:00
📂 File List (165)
🎬
01_-_The_Range_Object/01_-_Intro_and_Course_Workbooks_download.mp4
2.78 MB
🎬
01_-_The_Range_Object/02_-_Get_the_Developer_Tab_and_Intro_to_Developer_Tab.mp4
3.58 MB
🎬
01_-_The_Range_Object/03_-_How_to_Leave_a_Udemy_Review.mp4
5.55 MB
🎬
01_-_The_Range_Object/04_-_Getting_started_with_Range_object.mp4
1.98 MB
🎬
01_-_The_Range_Object/05_-_Creating_Your_First_Macro_From_Scratch.mp4
4.26 MB
🎬
01_-_The_Range_Object/06_-_Adding_a_Secondary_Command._._..mp4
1.57 MB
🎬
01_-_The_Range_Object/07_-_Debugging_in_Excel_VBA.mp4
2.5 MB
🎬
01_-_The_Range_Object/08_-_Saving_a_Macro-Enabled_Workbook_.xlsm_.mp4
2.38 MB
🎬
01_-_The_Range_Object/09_-_Several_Ways_to_trigger_your_Macro.mp4
2.12 MB
🎬
01_-_The_Range_Object/10_-_Affecting_Multiple_Cells_with_One_Range_Command_-_2_Methods.mp4
3.06 MB
🎬
01_-_The_Range_Object/11_-_Adding_Strings_of_Text_to_a_Cell.mp4
2.54 MB
🎬
01_-_The_Range_Object/12_-_Using_a_Named_Range_with_the_Range_Object.mp4
2.16 MB
🎬
02_-_Range_Properties/13_-_.VALUE_Property.mp4
2.98 MB
🎬
02_-_Range_Properties/14_-_.TEXT_Property.mp4
1.62 MB
🎬
02_-_Range_Properties/15_-_.ROW_and_.COLUMN_Properties.mp4
2.11 MB
🎬
02_-_Range_Properties/16_-_.SELECT_Property.mp4
1.53 MB
🎬
02_-_Range_Properties/17_-_.COUNT_Property.mp4
3.78 MB
🎬
02_-_Range_Properties/18_-_.ADDRESS_Property.mp4
3.41 MB
🎬
02_-_Range_Properties/19_-_.FORMULA_Property.mp4
7.36 MB
🎬
02_-_Range_Properties/20_-_.NUMBERFORMAT_Property.mp4
3.64 MB
🎬
02_-_Range_Properties/21_-_FONT.BOLD_UNDERLINE_or_ITALIC_Properties.mp4
4.75 MB
🎬
03_-_The_Cells_Object/22_-_The_Cells_Object.mp4
4.44 MB
🎬
03_-_The_Cells_Object/23_-_Using_Column_Letters_instead_of_Numbers.mp4
2.17 MB
🎬
03_-_The_Cells_Object/24_-_Using_Cells_Positionally_within_a_Range.mp4
3.78 MB
🎬
03_-_The_Cells_Object/25_-_Affecting_ALL_Cells_in_a_Worksheet.mp4
5.53 MB
🎬
03_-_The_Cells_Object/26_-_Using_Range_Object_with_Cells_Object.mp4
5.5 MB
🎬
04_-_Variables/27_-_Intro_to_Variables.mp4
2.34 MB
🎬
04_-_Variables/28_-_Declaring_Variables_-_Variable_Types.mp4
4.96 MB
🎬
04_-_Variables/29_-_Declaring_Variables_-_Types_Demo.mp4
5.48 MB
🎬
04_-_Variables/30_-_Calling_a_Procedure_from_Another.mp4
2.33 MB
🎬
04_-_Variables/31_-_Public_and_Private_Variables.mp4
5 MB
🎬
04_-_Variables/32_-_Using_Constants.mp4
3.35 MB
🎬
05_-_Toolbars_and_Menus/33_-_File_Menu_walkthrough.mp4
4.89 MB
🎬
05_-_Toolbars_and_Menus/34_-_Edit_Menu_walkthrough.mp4
10.03 MB
🎬
05_-_Toolbars_and_Menus/35_-_View_Menu_walkthrough.mp4
5.7 MB
🎬
05_-_Toolbars_and_Menus/36_-_View_Menu2_-_Watch_Window_Locals_Window_and_Immediate_Window.mp4
13.1 MB
🎬
05_-_Toolbars_and_Menus/37_-_Watch_Window_Wonders_.mp4
9.9 MB
🎬
05_-_Toolbars_and_Menus/38_-_Insert_and_Format_Menus.mp4
1.68 MB
🎬
05_-_Toolbars_and_Menus/39_-_Debug_Menu_Important_.mp4
9.33 MB
🎬
05_-_Toolbars_and_Menus/40_-_Run_and_Tools_Menus.mp4
7.55 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/41_-_Determining_the_Last_Row_in_your_Data_Set.mp4
7.92 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/42_-_Determining_the_Last_Column_in_your_Data_Set.mp4
4.82 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/43_-_Determining_the_Next_Row_in_your_Data_Set.mp4
3.15 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/44_-_Recording_a_Macro.mp4
7.26 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/45_-_Absolute_vs_Relative_References.mp4
7.89 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/46_-_Using_With_and_End_With.mp4
6.34 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/47_-_Comparison_Operators_in_Excel_VBA.mp4
1.94 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/48_-_If_Then_Statement.mp4
4.01 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/49_-_Using_Is_Not_Equal_To_.mp4
1.52 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/50_-_Logical_Operator_NOT.mp4
1.86 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/51_-_If_Then_Else_Statement.mp4
2.77 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/52_-_If_Then_ElseIF_Statement._._..mp4
3.91 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/53_-_Comparitive_Operators_with_Text_and_Numbers_.mp4
3.95 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/54_-_Use_If_Then_Statements_in_a_One-Liner_of_code.mp4
2.82 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/55_-_Using_GOTO_and_Labels.mp4
2.95 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/56_-_Select_Case_as_Alternative_to_IF_THEN_Statements.mp4
4.18 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/57_-_Message_Box_with_Yes_and_No_Buttons.mp4
19.07 MB
🎬
06_-_Super_Important_Tools_and_Excel_Logic/58_-_Relative_Positioning_using_Offset.mp4
5.5 MB
🎬
07_-_Loops_and_Report_Writing_Basics/59_-_Intro_to_Loops_the_For_Next_Loop.mp4
4 MB
🎬
07_-_Loops_and_Report_Writing_Basics/60_-_Fun_with_our_For_Next_Loop.mp4
6.85 MB
🎬
07_-_Loops_and_Report_Writing_Basics/61_-_Beginning_our_first_Report_using_Loops.mp4
10.91 MB
🎬
07_-_Loops_and_Report_Writing_Basics/62_-_Using_an_InputBox.mp4
5.06 MB
🎬
07_-_Loops_and_Report_Writing_Basics/63_-_Adding_InputBox_to_Our_First_Report_to_make_it_Dynamic.mp4
5.19 MB
🎬
07_-_Loops_and_Report_Writing_Basics/64_-_Add_a_Button_to_Open_Our_Report.mp4
7.75 MB
🎬
07_-_Loops_and_Report_Writing_Basics/65_-_Add_a_Cool_Looking_Button_or_Image_to_Open_Report.mp4
6.07 MB
🎬
07_-_Loops_and_Report_Writing_Basics/66_-_Our_First_Printable_Report_part_1_-_Declaring_and_Setting_the_Sheets.mp4
8.87 MB
🎬
07_-_Loops_and_Report_Writing_Basics/67_-_Printable_Report_Part_2_-_Getting_Items_On_Report_Sheet.mp4
11.55 MB
🎬
07_-_Loops_and_Report_Writing_Basics/68_-_Printable_Report_Part_3_-_Clearing_Last_Report.mp4
12.37 MB
🎬
07_-_Loops_and_Report_Writing_Basics/69_-_Printable_Report_Part_4_-_Ensuring_Visibility_and_Autoselect_Report_Sheet.mp4
10.35 MB
🎬
07_-_Loops_and_Report_Writing_Basics/70_-_Using_PrintPreview_Automatically.mp4
3.16 MB
🎬
07_-_Loops_and_Report_Writing_Basics/71_-_Using_PrintOut_to_Send_Directly_to_Default_Printer.mp4
5.34 MB
🎬
07_-_Loops_and_Report_Writing_Basics/72_-_Handling_Debug_Error_When_Cancelling_InputBox.mp4
7.1 MB
🎬
07_-_Loops_and_Report_Writing_Basics/73_-_For_Loop_Going_Backwards_using_STEP.mp4
7.86 MB
🎬
07_-_Loops_and_Report_Writing_Basics/74_-_The_FOR_EACH_Loop.mp4
9.5 MB
🎬
07_-_Loops_and_Report_Writing_Basics/75_-_FOR_EACH_Loop_-_Practical_Examples.mp4
6.41 MB
🎬
07_-_Loops_and_Report_Writing_Basics/76_-_Intro_to_DO_LOOPS.mp4
7.51 MB
🎬
07_-_Loops_and_Report_Writing_Basics/77_-_DO_Until.mp4
2.95 MB
🎬
07_-_Loops_and_Report_Writing_Basics/78_-_Loop_Until.mp4
2.28 MB
🎬
07_-_Loops_and_Report_Writing_Basics/79_-_DO_While.mp4
2.66 MB
🎬
07_-_Loops_and_Report_Writing_Basics/80_-_Loop_While.mp4
1.57 MB
🎬
07_-_Loops_and_Report_Writing_Basics/81_-_EXIT_DO_-_Multiple_Exits_using_your_own_Criteria_along_the_Way_.mp4
2.37 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/82_-_Intro_to_Worksheet_Events_and_Selection_Change.mp4
6.38 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/83_-_Worksheet_Activate_Event.mp4
2.44 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/84_-_Worksheet_Deactivate_Event.mp4
4.35 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/85_-_BeforeDelete_Event_-_for_Worksheet_Deletion.mp4
2.38 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/86_-_BeforeDoubleClick_Event_-_Trigger_a_Macro_when_Double_Clicking.mp4
4.86 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/87_-_BeforeRightClick_Event_-_Trigger_a_Macro_when_Right-Clicking.mp4
2.63 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/88_-_Calculate_Event.mp4
5.93 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/89_-_How_to_Disable_Events_on_the_Workbook.mp4
2.81 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/90_-_Intro_to_Change_Event.mp4
2.14 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/91_-_Change_Event_with_EnableEvents_toggle_-_Avoid_endless_loop_.mp4
7.74 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/92_-_Change_Event_Triggered_with_Custom_Range_Using_Intersect.mp4
5.54 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/93_-_FollowHyperlinks_Event.mp4
6.19 MB
🎬
08_-_EVENTS_-_Worksheet_Events_made_Easy/94_-_Final_Thoughts_on_Worksheet_Events_and_Review_Other_Events.mp4
4.5 MB
🎬
09_-_WorkBook_Events/100_-_Before_Print.mp4
3.53 MB
🎬
09_-_WorkBook_Events/101_-_Deactivate.mp4
3.37 MB
🎬
09_-_WorkBook_Events/102_-_NewChart.mp4
9.22 MB
🎬
09_-_WorkBook_Events/103_-_NewSheet.mp4
4.26 MB
🎬
09_-_WorkBook_Events/104_-_Sheet_Activate.mp4
6.83 MB
🎬
09_-_WorkBook_Events/105_-_Delete_DoubleClick_RightClick_Calculate_Change.mp4
12.39 MB
🎬
09_-_WorkBook_Events/106_-_SheetDeactivate.mp4
7.02 MB
🎬
09_-_WorkBook_Events/107_-_Follow_Hyperlink.mp4
3.49 MB
🎬
09_-_WorkBook_Events/108_-_SheetSelectionChange.mp4
4.36 MB
🎬
09_-_WorkBook_Events/109_-_WindowActivate.mp4
3.38 MB
🎬
09_-_WorkBook_Events/110_-_WindowDeactivate.mp4
2.36 MB
🎬
09_-_WorkBook_Events/111_-_WindowResize.mp4
7.28 MB
🎬
09_-_WorkBook_Events/95_-_Workbook_Open.mp4
8.85 MB
🎬
09_-_WorkBook_Events/96_-_Workbook_Activate.mp4
4.64 MB
🎬
09_-_WorkBook_Events/97_-_Before_Save.mp4
5.12 MB
🎬
09_-_WorkBook_Events/98_-_After_Save.mp4
7.45 MB
🎬
09_-_WorkBook_Events/99_-_Before_Close.mp4
9.81 MB
🎬
10_-_Activex_Controls_on_Worksheets/112_-_Activex_Controls_vs_Forms_Controls.mp4
5.84 MB
🎬
10_-_Activex_Controls_on_Worksheets/113_-_Button_Click_-_Wage_Calculator.mp4
6.59 MB
🎬
10_-_Activex_Controls_on_Worksheets/114_-_Keydown_Event.mp4
6.09 MB
🎬
10_-_Activex_Controls_on_Worksheets/115_-_BONUS_-_Capturing_Shift_Alt_Ctrl_or_some_combination_using_the_Shift_variable.mp4
6.77 MB
🎬
10_-_Activex_Controls_on_Worksheets/116_-_KeyPress_Event.mp4
6.67 MB
🎬
10_-_Activex_Controls_on_Worksheets/117_-_MouseMove_Event.mp4
3.39 MB
🎬
10_-_Activex_Controls_on_Worksheets/118_-_MouseMove_Event_with_Application.Statusbar_-_fun_and_useful.mp4
6.41 MB
🎬
10_-_Activex_Controls_on_Worksheets/119_-_MouseUp_and_MouseDown_Events_-_Left_Middle_and_Rightclick_Shift_Alt_and_Ctrl.mp4
11.41 MB
🎬
10_-_Activex_Controls_on_Worksheets/120_-_GotFocus_and_LostFocus_Events.mp4
2.27 MB
🎬
10_-_Activex_Controls_on_Worksheets/121_-_Use_a_Checkbox_for_its_VALUE.mp4
4.54 MB
🎬
10_-_Activex_Controls_on_Worksheets/122_-_Checkbox_Event_Without_a_Button.mp4
2.84 MB
🎬
10_-_Activex_Controls_on_Worksheets/123_-_LinkedCell_Property_with_a_Checkbox.mp4
2.28 MB
🎬
10_-_Activex_Controls_on_Worksheets/124_-_Option_Buttons_Intro_-_What_is_an_Option_Button_and_Grouping.mp4
4.53 MB
🎬
10_-_Activex_Controls_on_Worksheets/125_-_Grouping_Alignment_and_Aesthetics_for_Controls.mp4
4.52 MB
🎬
10_-_Activex_Controls_on_Worksheets/126_-_Homemade_Quiz_using_Option_Buttons_and_a_Command_Button.mp4
7.01 MB
🎬
10_-_Activex_Controls_on_Worksheets/127_-_Compliance_Checker_for_your_Forms_or_Quizzes_Part_1.mp4
6.54 MB
🎬
10_-_Activex_Controls_on_Worksheets/128_-_Compliance_check_part_2.mp4
20.01 MB
🎬
10_-_Activex_Controls_on_Worksheets/129_-_SpinButton_with_Cell_A1.mp4
6.66 MB
🎬
10_-_Activex_Controls_on_Worksheets/130_-_SpinButtons_with_Textboxes_and_Numbers.mp4
9.94 MB
🎬
10_-_Activex_Controls_on_Worksheets/131_-_SpinButton_BONUS_-_Move_Textbox_Position_with_SpinButton.mp4
8.74 MB
🎬
10_-_Activex_Controls_on_Worksheets/132_-_SpinButton_with_Dates_in_a_Textbox.mp4
6.85 MB
🎬
10_-_Activex_Controls_on_Worksheets/133_-_Activex_Label_Control_-_Basics.mp4
6.79 MB
🎬
10_-_Activex_Controls_on_Worksheets/134_-_ComboBox_-_Fill_with_ListFillRange.mp4
7.73 MB
🎬
10_-_Activex_Controls_on_Worksheets/135_-_Creating_a_Dynamic_Range.mp4
8.63 MB
🎬
10_-_Activex_Controls_on_Worksheets/136_-_ComboBox_-_How_to_use_Multiple_Columns.mp4
6.25 MB
🎬
10_-_Activex_Controls_on_Worksheets/137_-_Using_.ADDITEM_to_Get_Specific_items_in_your_Combobox_List.mp4
17.73 MB
🎬
10_-_Activex_Controls_on_Worksheets/138_-_Noteworthy_Properties_of_a_Combobox.mp4
12 MB
🎬
10_-_Activex_Controls_on_Worksheets/139_-_Multiple_Columns_in_Combobox_with_.ADDITEM_and_List_ListCount_etc.mp4
16.21 MB
🎬
10_-_Activex_Controls_on_Worksheets/140_-_ListBox_Basics_using_Dynamic_Range.mp4
15.37 MB
🎬
10_-_Activex_Controls_on_Worksheets/141_-_Listbox_Click_event_and_Dynamic_Options.mp4
7.11 MB
🎬
10_-_Activex_Controls_on_Worksheets/142_-_ListBox_-_Referencing_Column_0_and_1_in_a_cell_Dynamically_.mp4
10.61 MB
🎬
10_-_Activex_Controls_on_Worksheets/143_-_Dynamic_ListBoxes_Using_.ADDITEM_and_More.mp4
19.8 MB
🎬
10_-_Activex_Controls_on_Worksheets/144_-_Make_and_Utilize_INVISIBLE_Columns_-_Special_Trick_.mp4
6.47 MB
🎬
10_-_Activex_Controls_on_Worksheets/145_-_Using_a_Scroll_Bar_on_a_worksheet.mp4
4.72 MB
🎬
10_-_Activex_Controls_on_Worksheets/146_-_Pictures_on_a_Worksheet_plus_using_FollowHyperlink_Method.mp4
13.91 MB
🎬
10_-_Activex_Controls_on_Worksheets/147_-_Toggle_Button.mp4
4.57 MB
🎬
10_-_Activex_Controls_on_Worksheets/148_-_A_Brief_Note_on_Alternate_3rd_Party_Controls.mp4
2.9 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/149_-_Userform_-_Hide_Show_and_Unload.mp4
9.13 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/150_-_Sample_Database_and_Creating_a_Data_Entry_Form.mp4
34.48 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/151_-_Fill_Status_combobox_with_Rowsource_when_Userform_starts_-_2_methods.mp4
9.39 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/152_-_New_Employee_Data_Entry_Form_.mp4
36.52 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/153_-_Format_Textbox_Numbers_as_Numerals_Clearing_out_Form_upon_Submission.mp4
8.69 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/154_-_Set_the_Tab_Order_for_Userform_Controls.mp4
5.51 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/155_-_Set_Default_Values_to_Make_Data_Entry_Easier.mp4
5.47 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/156_-_Avoid_Duplicate_Employee_ID_and_other_Fun_Automation_Tricks.mp4
15.76 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/157_-_Edit_Mode_for_Employee_Database_-_Part_1.mp4
37.32 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/158_-_Edit_Mode_for_Employee_Database_-_Part_2.mp4
25.05 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/159_-_Edit_Mode_Pt_3_-_Adding_Automation_and_Save_Button.mp4
43.94 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/160_-_Userform_Report_with_Filters_-_Part_1.mp4
26.37 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/161_-_Userform_Report_with_Filters_-_Part_2.mp4
15.71 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/162_-_Applying_the_Dynamic_Filters_to_Reports.mp4
8.46 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/163_-_Clear_out_Last_Report.mp4
6.99 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/164_-_Report_Generation_and_Aesthetics_Headers_Footers_Repeat_Rows_etc..mp4
10.65 MB
🎬
11_-_Userforms_-_the_best_thing._EVER#0BB3/165_-_Concluding_Thoughts._._..mp4
3.36 MB
⬇️ Offline Download

Disclaimer

This website only provides DHT network resource indexing services and does not store any resource files. All resources come from the DHT network, and this site cannot control their content. Please comply with local laws and regulations and use network resources rationally. If there are copyright issues, please contact [email protected].