Free Excel VBA Course #33 - Creating a Simple Application Using VBA

In this video, I show you an example of an application you can create in Excel using VBA.

For this video, I have chosen the important urgent matrix in Excel when you can record tasks and mark these as complete with a double click

-------------------------------------------------------------------------------------
00:00 Introduction
00:13 Task Matrix
02:23 Adding Tasks
05:01 ToDo Lists
06:03 User Form
07:51 ToDo List
09:44 Double Click
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial

[theanimatedchef_Official]

You helped me save my job lol, not all heroes wear capes <3

[patrickbasseygospel]

Hi TrumpExcel, great video. Please could you tell me which of your other videos to watch to be able to perform the logic on sheet 2.

[yashlimbachiya]

Hey trump excel, How did you do it on second time double click the strikethrough has been removed

[aseelahduncan]

@ 12:57 I am not understanding why if a task is completed why you make it blank

[ashutoshb]

When I try to run the code, there is a compilation error citing that the project/library is not found. Please help out

[surajrawat]

after run this query, i am getting Run time error 1004:
Application defined or object defined error

Private Sub lblAdd_Click()
Sheets("To Do List").Range("B2").End(xlDown).Offset(1, 0).Value = txtask.Value
Sheets("To Do List").Range("B2").End(xlDown).Offset(0, 1).Value = cmbImportant.Value
Sheets("To Do List").Range("B2").End(xlDown).Offset(0, 2).Value = cmbUrgent.Value
Sheets("To Do List").Range("B2").End(xlDown).Offset(0, 3).Value = cmbStatus.Value
End Sub

what error i have made ?

[learnbahrainiarabic]

Hi dear
We are unable to download this files