Okay, good morning and a very warm welcome to Everyone here in class as well as students online We pray and we will begin. So let me just begin with the word of prayer Heavenly Father, we thank you once again Lord for giving us this opportunity to spend time in your word We pray that Lord your word will build us up that Father your word will prepare our hearts Lord to serve you and Father God to live as mighty witnesses father for the glory of your name We commit Lord this entire course of the prophetic and apostolic ministry. We pray that Lord, it'll it'll be more than just theoretical knowledge that We will move oh God in the prophetic and father that we will demonstrate the apostolic father We pray for your blessing upon every single student Lord Was part of this learning process on all the platforms Lord. We pray that Lord you would oh God Lord just fill them with your spirit. Oh God and father cost them to flow In the gifts of the Holy Spirit. We thank you once again in Jesus name. We pray Okay, hope all of you have had a Good year or a good break. They're just starting the new year now So a very happy new year to all the students I think there's a comment here stating that the audio is somewhat low Just checking if online students. Can you hear me properly? Would you want the audio increased? It's fine Okay, it's it's fine. Okay, great. Yeah students are saying it's fine Sure So let's begin with the prophetic this course course 207 It has to do with the prophetic ministry as well as the apostolic ministry But we will take it up in two sections. So first we are going to look at the prophetic ministry and understand How to really flow in the prophetic and be a blessing to the people And then once we complete the learning about the prophetic We will go into studying what the apostolic stands for and for this course. We will use Initially understanding the prophetic one of the APC publications. So you can just download it from APCWO.org forward slash books and Follow through we are going to go through that book Sequentially and For the apostolic study, we will have notes which I will share with you once we complete the prophetic ministry And in this course, we will have two Assignments both of which will be 50 marks and 50 marks each Which I will put out periodically and you can actually, you know, go ahead and Answer the questions and as we've been saying want to encourage all students to maintain your score In the assignments out of hundred it should be a minimum of 35% or more and Attendance wise 85% or more. So please be mindful of that, especially the online students So coming now to the prophetic So one beautiful thing that we see today is that the Lord is restoring The prophetic ministry in the church. We have seen the Many seasons that the church has gone through and we've also learned about the dark ages and how The renewal of the church took place step-by-step and we saw how you know that there was this Concept of the baptism restored Healing was restored and then baptism in the Holy Spirit That's a revelation that was restored to the church and the time that we live in right now It is a time when God is restoring the five-fold ministry offices So that means that we will see believers as well as people who are positioned in leadership the five-fold ministry offices also Function in their gifts. So our attempt is to understand What this prophetic ministry is all about now? This is nothing new As far as the Bible is concerned. We know that in the Old Testament the prophetic was very much Functional and we will discuss about the Old Testament and the prophetic ministry shortly even in the New Testament Starting with Jesus himself. There were prophecies there was You know words foretold and in the churches the prophetic gift was encouraged by Paul So it has been there. It's nothing new just because we are discussing about it. It doesn't make it new however, the Understanding of what this prophetic gift is all about and how this prophetic gift really Flows through us is something that we need to get a grasp of because then we will be able to use it or Function in it in an appropriate way. Similarly. We said prophetic offices So the five-fold ministry offices apostle prophet evangelist pastor teacher So we will see many such people emerge Among us in the office of a prophet, but at that time we need some understanding of what this whole Position is all about and the function of that role of a prophet is all about and that is why we are trying to learn about this ministry and another thing that we could easily say is that because God has been restoring The prophetic and the five-fold ministry gifts We are getting a deeper knowledge now So maybe the previous generations from us they may have Moved in these things but not Discussed it as such so even terminology that we use today, right? These are all things that have emerged over the last Couple of years as we are observing more and more of the prophetic Manifesting, okay, so this is what is going on and which is why we need to understand What the prophetic ministry is all about? It will help us to function in this ministry now another thing that we want us to Recognize is we have a God who speaks so If our God we're not a communicating God like imagine, you know, he just gives us a book of rules and He wants us to function by those rules and that's it Okay, he doesn't ever talk Once again to us Then we don't really need the prophetic The prophetic is God speaking in the now He has already spoken in his word now all of us will agree that the Bible is already God speaking to us Okay, so if God were never to speak another new word to us, we still have We an understanding of God's heart because the Bible has already been given to us But what God does is he also speaks in the now So we'll see how he does that he inspires a word into our hearts in the current season of our lives and all of us would agree that words are so powerful we can very very sort of Animously say that whenever somebody has spoken a Discouraging word, maybe when we were children and we didn't have much understanding when somebody Tried to bully us or put us down. It hurt us so much. How did they do it? The words that they spoke so words carry so much power now Imagine a positive word that may have been spoken to us Maybe by our parents or our teachers when we were picked for a competition and we couldn't really Believe that we could do it No, that I can paint or I can speak or I can be a part of sports our teachers may have said something like You can do it You know, just practice you can win the prize and that gave us the confidence. So we all understand that words are powerful they either motivate us or they discourage us and that is the reason we need to Understand that even when we talk about the prophetic, you know, imagine if a word of a loved one Was so meaningful in a difficult time a word from God What a difference that can be Isn't it?  We want God to You know reveal the future What career we are going to take and you know, what Ministry we are going to have how is our church going to look? So we we desire to know so much from God's heart Now I'm not saying that God does not reveal all this. He does. In fact, he has given us the Holy Spirit We have the written word of God in which he has already revealed many things to us We have the Holy Spirit and Jesus said when I go I will send you the Holy Spirit He will lead you into all truth, which means that through the word through the Holy Spirit God is already speaking to us, but even when we have these things Whenever there is something that needs to be spoken even just one word from God Makes a world of a difference You know, we are stepping into a new year and we want a word from the Lord and we have this You know in our church the word of the Lord for 2024. What is God going to do this year? So the now word of God It could be so many things that God speaks the way he spoke to Abraham You know, I'm gonna do this. I'm gonna do that. You're gonna be like this. Oh, maybe just a word Right. We can testify that it makes a world of a difference Maybe a word like arise Okay, think about it if we receive just one word from God arise We get that confidence fear not Okay, be strong Be courageous. I Have my presence shall go with you one sentence That's all we can literally like feel in our spirit in our, you know, every part of our being that There is that strength and confidence that comes into us So that's the desire that we have because we have a speaking God because we have a God who communicates So it's a beautiful thing for us to trust God to speak to us and as I mentioned earlier the church has been through different seasons and from 400 to 480 after which that dark ages that we speak about God started restoring the church with various moves of God We had the Protestant movement in the 1500s. We had Aware, you know the Puritan movement in the 1600s We had the baptism and set baptism of water Separation of church this understanding came to us during the Puritan movement 1700s where the holiness movement and sanctification of the church was spoken about 1800s is the divine healing movement and the 1900s is the Pentecostal movement and that right now The you know 2000s and the 20th century. We are having the restoration of the prophetic offices and The under deeper understanding regarding the gifts of the Holy Spirit So before we delve deeper, we are going to touch on many aspects and understand Especially the prophetic gift and How to move in it? How to activate it? What are some? practical Guidelines which will help us function in that prophetic gift, but before I get into that This is just an introductory class, but are there any thoughts or questions? About whatever we have spoken so far For anything regarding the prophetic ministry that you just want to put forward Please feel free. You can you know talk about it and then I'll I'll get into some other details of the prophetic Yes, yes, Francis Not I have not one dog, but I have a question like yeah So even like you said my life one word will encourage But how we will understand it from God or like from our thought. Yeah, so one day what happens I'm praying for a person I sense on what of God, but I am literally a lot of confusions from my side or Gods will God want to talk. So how to understand like Yeah, like he's from really from God or from our thought. Okay. See one thing that we must be clear about is that God Gives us this gift as believers. We can all flow in the prophetic gift So there is something like the prophetic gift which flows through us Okay, so that is something we have to understand that means that from time to time When we desire God does release these words to us So some words are from God now the challenge that you're talking about is Identifying which is from God and which is from maybe, you know ourselves But for that, we're gonna talk about it that there is some level of Preparing yourself Okay, so when we do things like that, we will get a better understanding of what is from God and what is from us So if you may if you want to use another simpler term practice The gift is from God that we cannot change right the origin Origin or the source of the gift is God But when the gift is released to us the way we Work with the gift is in our hands. So one a person or a believer can train themselves Practice train prepare ourselves to recognize What is from God? So the more you flow in these gifts the quicker you would be able to identify that hey, this is from God Okay, so it's a matter of Training yourself is what I would say Francis initially Or in the beginning when we are just starting to flow It may be a struggle But when you recognize, you know, you you need to step out and then you recognize Hey, I was actually correct. So the next time you have more confidence the following time. You're even more confidence So that way you kind of pick it up Any other initial thoughts so we can proceed forward. Let me just see the online students Online students, please feel free to post your questions. It's a very Crucial subject and it's good to clarify your doubts if you have any Okay, so let me Go forward We will follow the notes just so you know, we we are in sync So right now I'm going to talk about prophetic progression We've been saying that in today's time and age God is releasing the prophetic gift and more and more people will function in it but in the Bible we have certain Levels if you want to call it off the operation of the prophetic We would term it as you know, these levels or these Sort of gradations we can we can classify them on the basis of the the gift that is given and You know the kind of ministry that God calls different people to so we see in scripture There's a mention of the gift of prophecy in a first Corinthians chapter 12 There are all the nine gifts are listed and one of the gifts which is listed is The gift of prophecy. Okay, similarly when we go to first Corinthians chapter 14 Even then Paul talks about the gift of prophecy and he makes an a very Interesting comment in the beginning of that passage of first Corinthians chapter one. He says, you know first you love and That you may prophesy, you know, honestly desire to prophesy You pursue love and you desire to prophesy he says and then he goes on to set many different Rules for the operation of the gifts of the spirit in the congregational setting and then he closes again, you know Where he says things like if you want to prophesy all of you prophesy one by one Okay, so the idea that we get in the Passages that Paul writes is that in the Corinthian Church, it seems like Everyone was operating in the prophetic Okay, people that prophesying which is why he was writing to everyone like if you look at first Corinthians chapter 13 That's a passage that we are all very familiar with where Paul talks about love that We need to carry God kind of love now everyone will agree that Paul was talking to Everyone so when he says you need to have love. No lovers patient lovers kind he's talking to all the believers in Continuation to what he's saying see we are the ones who put chapter and verse but when Paul wrote it He wrote it in continuation. He continued from the passage about love and he says Desire earnestly, you know the best gifts prophesy and then again he goes on to say when you prophesy prophesy one by one Okay, so the point is that he was talking to all believers and Instructing all believers on the operation of the gift of prophecy So one of the things that we can recognize is that there is something known as the simple gift of prophecy Simple gift of prophecy that all believers can operate in and this is mentioned for us in first Corinthians chapter 14 and verse 3 Where Paul talks about? Prophecy which is meant for edification exhortation and comfort we will talk more about The simple gift of prophecy and you know other things later on this is just an introduction so he Speaks to us about the operation of the simple gift of prophecy to encourage build up and comfort other believers through ordinary believers So that would be your first level where all believers can prophesy Okay, so is it correct to say all believers can prophesy? Yeah, to some extent we can the gift of prophecy operates through every believer So that would be your simple gift of prophecy which functions through all believers now if you look at the progression what we see is that believers some believers are called Into a certain ministry function Okay, and one of the ministry functions is the prophetic ministry and we read about this in Romans chapter 12 from most versus four to eight If someone is able to read this passage you can quickly turn to it and Read it Romans chapter 12 versus four to eight, please Romans 12 4 to 8 For as we have many members in one body But all the members do not have the same function So we being many are one body in Christ and Individually members of one another Having then gift differing according to the grace that is given to us Let us use them if prophecy that is prophesy in the proposition to our faith or ministry Let us use it for our ministry the he who teaches in Teaching he who exhorts in exhort exhortation he who gives with liberty he who leads with diligence He who saw mercy with cheerfulness Sure, so in this List we also have prophecy, right? So when it is mentioned he who prophesies But this is referring more to a Grace gift of God So the spiritual gift of prophecy all believers can move in it to some extent But there is something known as a grace gift. It is also termed as a ministry gift So what happens is that God sometimes calls Believers or if I may put it this way he gives the grace to operate in the prophetic ministry So to a greater extent there are certain believers who can Who can you know function In the prophetic more than what is expected of a simple believer Okay, so that would be your Grace gift of prophecy or there are people who call it ministry gift of prophecy So that now is the next level Of the operation of the prophetic Now coming to the You know sort of a major level of the prophetic is the prophetic office that we read about in Ephesians chapter 4 Verses 11 through 12 where God has spoken to us and said that Christ gave gifts to the church The Apostle prophet, you know pastor teacher evangelist So there a term such as a prophet is used That would be The office of a prophet. So we got to make distinction of these three levels simple prophesying believer somebody who has a prophetic ministry and Somebody who is a prophet Okay, now, what is the difference when we especially talk about a prophet There is a reference to this term prophet as I mentioned earlier In Ephesians chapter 4 versus 11 and 12 Again in first Corinthian chapter 12 and verse 28. There is a mention of this term prophet Referring to the office of a prophet. It simply means That somebody who is in the office of a prophet Is assigned by God Because Christ gave gifts to the church meaning they have been Called by God Specifically to operate in those ministry offices That also suggests That everyone is not a prophet Now I being a believer Operating in the gift of prophecy. I may prophesy a lot, but it doesn't make me a prophet Are you understanding what I'm trying to say? So the progression Would go like prophesying believer Somebody who's operating in the grace gift or the ministry gift of prophecy and then the office of a prophet So somebody in the office of a prophet Is specifically called by God. So again comes the question. I want to be a prophet. Can I be a prophet? It doesn't work like that If God has called you to be a prophet You will be a prophet But if God has not chosen us to be a prophet We cannot be a prophet But as a believer Can I operate to the best capacity possible in the prophetic? That is possible But even if I'm a very prophetic believer I am not a prophet Okay, are you understanding what I'm trying to say? So this is the progression Now what is so different about the office of a prophet? You know, we we recognize that the office of a prophet Comes with something known as governmental responsibility And governmental authority By which we understand that God holds the prophet accountable at a greater level For the for the gift that has been given To the prophet Now because they carry governmental authority And responsibility They would also be people who would release powerful prophetic words Okay, so what are these powerful prophetic words? They could be words that have to do regarding the The coming movements within the church or the body of Christ Now a simple believer A simple prophesying believer may have an idea that God wants to do something like this But it would be somebody who's a governmental authority Who with authority and clarity can call forth You know these words and say, you know, there is a move of God coming This is what the Lord is doing or uh, they may speak to the nations They may um You know, there is an aspect of warring in the supernatural with the prophetic So powerful things that a prophet can do With the grace that God has given uh to his life A simple prophesying believer will never be able to do that. So these are the differences Okay, so, uh, somebody who's in the office of a prophet carries governmental responsibility and governmental authority And the bible clearly teaches us that God has always wanted, you know Uh People in these positions. So when you look at the book of Acts, okay, we find there that God called people as apostles. They were apostles Right the 12 apostles of the lamb and we see in Ephesians 220 the bible also says that The church it has been built on the foundations of the apostles and the prophets Right but somebody uh quickly go to that scripture. It's also a key scripture for us Ephesians chapter 2 and verse 20 Ephesians chapter 2 verse 20 having been built on the foundation of the apostles and prophets Jesus Christ himself Being the chief cornerstone. Yeah, so you see that Having been built on the foundation Of the apostles and the prophets So even in the early church You had the apostles and the prophets who were like the pillars of the church They were strengthening the church guiding the church Releasing more of the supernatural Right, uh, so all that was happening when you look at people like, uh, you know, uh, uh, agibus There's a mention of this man called agibus is called as a prophet of God, right? So there were people who were operational in these ministry offices And uh, even as we go forward, we will see people in the prophetic office Now one more thing that we must be clear about is that We may not have, uh, we'll discuss this later when we say apostles There are classifications So the apostles of the early church were very different. They were the foundational apostles They were the ones who gave us the doctrines. So today when we have apostles, we don't expect them to, you know, rewrite Parts of the scripture for us because it's already done So the apostles of the lamb, okay, they were some of our foundational Apostles their role was different But today We can still have the apostolic. We can still have the apostles. Their role will be very different Similarly, when we consider the prophetic, we can't really compare. Yes, there will be a lot of, uh, Common aspects as far as the operation of the gift is concerned But there will be differences. You know, how God really uses the prophetic In different times and seasons, but we have to recognize that Apostles and prophets are very important part of the church Uh, and in fact, as what Anand read the church has been built on the foundation of apostles and prophets. Yeah, yes, Anna Question is, uh, grace gift of God. We, we, sorry. Yes. So the people who have the grace gift of God are not called to be as a prophet um so See being a prophet is, uh, is a very distinct and clear thing Now somebody who's operational in the grace gift of prophecy may Be a prophet That only time will tell Okay, but not all the people with the grace gift of prophecy are prophets I hope you understood And when we see this Efficient 220, yes, there will be apostles and prophets. Yeah, it was talking about the past what happened So is is it is there anything in bible that we will have Apostles and prophets now also Yes, and it's so As a normal people how we can how we have to recognize them as an apostles and prophets And many people are just naming themselves as prophets and prophets. How we can recognize them? Yeah, so that that's exactly what we're trying to answer through this course um, see Ephesians 4 11 and 12 Paul wrote to the Ephesian church Right that Christ himself has given us apostles prophets and as we study um the Episodes of Paul and the New Testament books nothing really says that It has stopped Isn't it so And Paul so clearly talks about how to function in the prophetic gift all of this only goes to say that Yes, God is raising up Apostles prophets He has been raising up. He is raising up And we are going to see more and more of this happening But again a very important question that Anand asked how to recognize Right, so that is something that as we look at scriptures, we will get a better idea of how to recognize um now People are calling themselves prophets and calling themselves apostles um Ideally that should happen the other way Okay, meaning for example, let's say I'm operating in the prophetic. Okay and people are blessed by my ministry over time People may recognize. Oh, this is a prophet of God and then people start saying a prophet so and so That is more honorable than doing it the other way because uh, we May I mean we run the risk of making an error if we start off by saying, you know, I might be um I might have the grace gift of prophecy, but again that doesn't make me a prophet. No So it's actually risky to do it that way Yeah But as people we will be able to recognize because uh, we'll we'll notice that someone is functioning so powerfully so accurately In every season of their lives in the prophetic and God is doing amazing things through their lives You know through the prophetic then We we can't help but say hey, here's a prophet of God right so Uh, that that's how we will recognize So I'll give you some pointers that should help you so here in our notes Uh on page eight on the pdf notes that I have. I don't know which one it could be in your books Basta Ashish has shared a testimony of his life where he writes about a very difficult time as a student in the united states um when uh for the sake of ministry he he spent All the money that he had I had a wonderful Ministry trip and came back to the u.s. But he recognized that his back account was down to zero and he had no You know money to sustain himself So it was a very dark period of his life and how God orchestrated a visit to Uh, a particular camp Where they were teaching about all these things, you know the gifts of the spirit how to operate the prophetic So he went for that and he was also ministering in that Camp he ministered but he writes about meeting a particular prophet of God in that camp and uh He writes about how he was so amazed that this prophet just came up to past ashes and started prophesying You know and said so many things which were already in his heart things like uh, you are here only for a season God is going to take you back to your own people India where you will establish a strong work of God. I mean these are all like When pastor went for the camp nobody really knows what is in his heart, right? um So when this prophet started saying all these things he was so amazed like wow How can someone who does not know me at all Know what i'm thinking and what God has been speaking in my life. And so I would just encourage you To read through that prophecy with all the details. It's amazing how You know, someone can speak through the heart of God and pastor actually shares a scripture In that testimony Isaiah 44 verse 26 Where he says who confirms the word of his servant and performs the counsel of his Messengers, that's the God we serve. You know God When we speak a word from God, right? It's not in vain and uh Pastor says that there are many things that he spoke That have already happened and there are many things that he is looking forward to So when there's a true prophetic word Uh, you know, we we will see God's God move in line with what he actually speaks Upon our lives Okay, but of course there's another point there which is about personal obedience. We'll come to that later No, we can't just say oh god you said and you and live in complete disobedience and you know Say why is it not happening? You said I will be a pastor and then you know God is like But you're not cooperating how how do I cause you to be that pastor that I want you to be When you're just not willing to to Walk in my ways, you know, so there's that aspect of personal obedience also but um When we obey God and when we walk in line with what he speaks Surely we can see the word of God confirmed in our lives Okay, so uh, this is a little bit about the prophetic today today's classes, but an introductory class Um, so just feel free if you have any other thoughts Uh, clarifications. It's nice to discuss Okay, so my my assumption is that you probably start having questions as we discuss more Okay, so let me touch on one A small theme before we close for today In the bible the earliest person Who is called as a prophet or the first person who's called as a prophet is any guesses? No minus marks the wrong answer So you don't have to be scared to ask That person is called prophet that Who's that first time first time in the book Moses, okay. You you feel it's Moses. Okay.   So that word prophet in the Hebrew there is the word nabi And nabi means inspired Inspired man Inspired by God. So what is the name that we give to Abraham usually? father of faith one more We sing a song also I am a Friend of God Right, so I'm a friend of God. So the beauty about Abraham is his communion with God What do we call communion with God? Relationship but communication with God two way communication Fellowship can we call prayer? prayer yeah, so The beauty about Abraham is That he communicated with God so many things we see he's discussing with God When Sodom and Gomorrah has to be destroyed He's actually going there and interceding for Sodom and Gomorrah. So he was a man of prayer He was a man who understood the divine purposes of God because of his close relationship with God and a prayer life We can easily say a man of prayer. So what we recognize here is that For for a prophet from the life of Abraham what we learn is One can be very prophetic When they have a prayer life Because what is a prophetic nothing but what does God want? What does God say in the now? Understanding God's heart, right? So when we are prayerful people We can be prophetic It's easier to be prophetic But the other way around Right, uh, is is when we are not prayerful. It's very hard to be prophetic Okay, so that's the testimony from the life of Abraham He heard from God and God himself called him a prophet and said hey Abimelech you have Abraham pray for you and you will be healed So we learn about prayer and intercession and the connection of prayer and intercession to the To the strong manifestation of the prophetic through anyone's life now, of course Abraham was a prophet But we can all learn a lesson, you know, we don't know which one of us is a prophet But for us even as prophesying believers when we have a strong prayer life a life of intercession We will be strongly prophetic Okay, so with that thought i'm just going to wrap For today and then we will pick up from where we stopped later on Um, so let's pray and close then and I want to request one of us to um lead First prayer who wants to grab that opportunity? Father god we thank you. We bless you for this time lord We submit each one of us until loving and lord father You're great and you're awesome father We we all worship you and father help us to walk in your prophetic lord Help us to hear from you and we are blessing to others lord. Jesus precious, may we pray Amen, amen Thank you nina. Thank you everyone and all the best for all your courses


So, let me present in a nutshell what I think the design failures are of the Eurozone, and then I will elaborate a little bit on this, and then in the second part I will talk about how to correct for these design failures. So first of all, what I see as a design failure has to do with the following, capitalism is a fantastic invention, but it's also very unstable, producing booms and busts, bubbles and crushes all the time. This has been for centuries like that, right? And these booms and busts have been there, and those who designed the Eurozone thought that they would be transformed into booms and busts at the Eurozone level. But no, they remained there, but at the national level. You had a boom and bust in Ireland and none in Germany. And so all this remained at the national level, creating potential for huge divergences and imbalances to which I will come back and that you know quite well, right? So that was in a way something that escaped the attention of those who created this thinking that if you bring money together, then you will have the same cycle, and we didn't have the same cycle. In fact, some people have argued that by the very fact that you are a monetary union, you might even have exacerbated these national booms and busts rather than making them more convergent. So that's one. The other one has to do with the following. For the centuries, we have introduced stabilizers in this capitalistic system, right? But they were organized at the national level. And when we created the Eurozone, these stabilizers at the national level were dismantled and nothing was put into place at the Eurozone level. So that essentially some key stabilizers did not function. I will elaborate on this. So let's first say a few things about these booms and busts dynamics that have remained national, right? What we did in the Eurozone was to centralize money fully, but most of the rest of macroeconomic policies remained organized at the national level, creating this potential for national booms and busts to continue to do their work, right, unhindered by the fact that there was a monetary union. The monetary union, in other words, was no disciplining force in terms of these booms and busts, and it did not at all bring them together into a Eurozone one. That would, of course, that was, in fact, the intention, because we know from the literature on optimal currency areas that the problem of monetary union is asymmetric developments, asymmetric shocks, and they continue to work unhindered. In fact, as I said, one can make the argument that the existence of a monetary union exacerbated this, because, as you know, the ECB had to put an interest rate that would prevail for everybody, and therefore it was way too low for Ireland, right, and too high for Germany, and as a result exacerbating the boom in Ireland and in other booming countries and making the boom, and later on the bust, more intense, right? So that is, I think, a major problem, design failure in a way that has very much to do also with the fact that we left the whole of the Eurozone unfinished business, right? We centralized money, but it's so little in terms of centralizing other parts of macroeconomic policies, right? That's what was left out of the agenda. We are now trying to do that, but certainly too late to have avoided the crisis. Here I show you the difference in inflation over the period prior to the crisis. This is probably something you have seen. Here you have Ireland, Spain, Greece, where the average inflation rate over the period of 80 years prior to the crisis was significantly higher than the other countries like Germany. That's the vertical axis, the horizontal axis, the unit labor cost that also tended to increase much faster in the booming countries, creating then the imbalances that we know, current account imbalances, the surplus countries increased their current account surpluses up to the crisis while the booming countries and deficit countries then increased their current account deficits as the boom, the consumption boom led to increasing current account deficits. This is the story that we know that has been very much emphasized as a design problem of the Eurozone, but let me concentrate on the other one that I think is equally important if not more so and has for a long time been totally unrecognized by those who created and then later on run the Eurozone. Prior to the existence of the Eurozone, each country had its own central bank and as a result also a lender of last resort to provide liquidity in times of crisis. This means that prior to the crisis, these governments had a backstop that they lost at the moment they entered the monetary union. Let me elaborate a little bit on this and this will then put at center stage the fragility of the government bond market in the monetary union. Governments in the monetary union when they're issued debt have to do it in what they factor is a foreign currency and as a result cannot give a guarantee to the bond holders that they will be paid out at maturity. It's literally possible that member countries of the Eurozone find themselves in a situation where they have no cash to pay out bond holders. That contrasts a great deal with standalone countries and all these member countries of the Eurozone used to be standalone countries that give an implicit guarantee to bond holders which is that they will always be paid out at maturity because there is a central bank that will be forced to do so in times of crisis. No sovereign will allow to be pushed into bankruptcy by the markets if it can avoid it by telling the central bank produce the cash so that I can pay out the bond holders. As a result, a standalone country can provide a guarantee to bond holders that they will be paid out at maturity while member countries of the monetary union cannot give the guarantee to bond holders that this will always be the case. That creates a huge fragility of a monetary union. It also produces a potential for self-fulfilling crisis. Here's the scenario that will occur when at a certain moment bond holders are fearful, they see some of the numbers that don't look right, they sell government bonds, interest rates increase, but more importantly, liquidity is withdrawn from the national markets. When the bond holders sell Irish bonds, the euros they obtain will be invested elsewhere and are drained out of the Irish money market and the government finds itself unable to roll over instead. No liquidity is available. It cannot call the central bank if the governor of the Irish central bank calls Draghi, Draghi will not take up the telephone. As a result, in a panic, the government has to introduce immediate and intense austerity. There's no cash. What do you do when you have no cash? You have to immediately cut spending, raise taxes, producing deep recessions and increases in debt to GDP ratio. That in turn can lead to a default crisis. So here we have scenarios that we have seen all the time. Countries that I think are solvent, I think for example that Ireland is a solvent nation pushed into a liquidity crisis that can degenerate into a solvency crisis because the country is pushed in such austerity that the capacity to service the debt declines, the debt to GDP ratio increases and as a result the capacity to service the debt declines. We see that what started as a liquidity crisis can become a solvency crisis. This of course creates strong fragility of these systems. The paradox is that when we entered the monetary union, we were told that because we are together in a club in the union, we will be stronger. The facts are is that by becoming members of this union, each of us became more fragile, more slaves of the financial markets because financial markets now in the monetary union have the power to force a default on a government. They don't have the power to force a default on standalone countries because a standalone country is always stronger than a market. They have a central bank that will produce all the liquidity of the world that is necessary to pay out the bond holders. And as a result we have a regime change here and this also explains the kind of macroeconomic policies that have been imposed on the eurozone, panic in financial markets that forces governments into excessive austerity that in the end instead of improving the capacity to service the debt makes the capacity to service the debt weaker. And this I think has been a story of, oops sorry, island, Portugal and Spain. I would have a different story about Greece. I think Greece was insolvent but we didn't know. So there you have to solve it differently. And this to restructure the debt and recognize that the claims we have on Greece should be abandoned or at least deep haircuts should be allowed. But so for the other countries I do think that this is a key problem and so we get here two interconnected issues, stabilizers that existed that have been, that have unraveled. Prior to the eurozone each of these countries had the last result that was willing to provide liquidity in times of crisis. This has been abolished in the eurozone and as a result of that the automatic stabilizer in the budget has also been disconnected because once you get into a crisis which is typically in the recession you have to increase taxes, you have to reduce spending, in other words make the budget torsiclical while in well-behaved countries that have a liquidity backstop, you have the capacity for the budget to do its work of automatic stabilizers. Not indefinitely of course but surely you have a possibility to do so. So we eliminated important stabilizers that we had built up over the years, over the decades to make capitalism more stable with lenders of last result, also in the government bond markets, not only for banks but also in the government bond markets and a capacity of budgets to do some stabilizing. All of this was de facto abolished in the eurozone creating the kind of crisis that we have seen. So let me skip a few things because of time constraints but this is a recent piece that I did for Fox where I show measures of austerity on the horizontal axis that were implemented in 2011 and the subsequent GDP growth and you can see that not surprisingly countries that introduced the steepest austerity measures also experienced the strongest decline of GDP. Ireland is a little bit above that line, did a lot of austerity but somehow managed to avoid the kind of recessions that other countries that did similar austerity went through. And then of course the other part of the story is that again when you put austerity measures on the horizontal axis the same austerity measures that I showed you, those austerity measures that were implemented in 2011 and the subsequent increases in the debt to GDP ratio and then you find a positive line that is the more you did austerity the worse became your debt to GDP ratio. So this is subsequent to avoid possible causality in two directions. So that illustrating the point that I am making that I have been making before. Let me summarize this. So the eurozone was left unprepared to deal with endemic booms and busts in capitalism. They are there. They will always be there. We should have no illusions that somehow we will avoid booms and busts, bubbles and crashes. They will come again. But we are totally unprepared. Probably the monetary union might have exacerbated these. And nothing was in place to stabilize an unstable system that pushed some countries into bad equilibria. Ireland was pushed into a bad equilibrium, so was Spain, etc. And others in good equilibria. Germany was pushed into a gentle good equilibrium. All the money of the West arrived in Germany and they could do nice things about it. For example, keep their banks afloat costlessly, almost costlessly, because they could borrow at almost zero interest rates. So it's easy to solve a banking problem. Germany also had a banking problem that could easily deal with it when the money is almost for free. And so that created huge antagonism also between these countries. Now we feel how the political tension that arises when some have it good and others have it bad in the same crisis. How to redesign the eurozone? That's the second part. How much time do I have left over? Okay, fine, perfect. How to redesign? I'm going to talk about three levels at which one should work. One has to do with the role of the European Central Bank. It will already be obvious what I want to say there, given the nature of the analysis that I've been making. The other has to do with what I call the medium one here, the macroeconomic policies in the eurozone. What's the nature of macroeconomic policies? How should they be designed, especially now in a crisis situation? And then the long run, that's when I will start dreaming about budgetary union, fiscal union, political union. They are important, but they are far, far out in the future there. So let me start with the role of the ECB. I think here what we certainly need to do is to re-institute a central bank at the level of the eurozone, because there's only one central bank in the eurozone that is willing to be the backstop, the lender of last resort, not only for the banks, but also for governments, in the government bond markets. I think that is key. That has been the great invention in stabilizing capitalism, the fact that the central bank is ready there to provide liquidity to solvent but illiquid banks and to solvent, but illiquid governments, because banks and governments have the same problem. Runs on banks exist, runs on governments also. And as a result, a central bank has to do its work there. It has taken some time for the ECB to recognize this, but as you know last year, the ECB finally acted and announced its willingness to buy unlimited amounts of government bonds. That's the key, unlimited. Prior to that, it had an S&P program, a program of buying government bonds, but this was announced to be limited in size and in time, and that's the worst thing you can do. If you say, I'm going to buy government bonds, but it's going to be limited, the amount that I'm buying, and limited in time, you give a signal to all these bond holders to sell when, now. If you were, in fact, planning to sell later, the announcement meant that all these bond holders said, now is the time to sell because they will stop soon buying, so it's the time to do it.  I'm not saying that it's only the ECB that does these things. So but now they have announced this outright monetary transaction program, OMT, that has this intention to be a backstop in times of crisis, and in fact, in defending OMT, Draghi used the same kind of analysis that I've been using, that is that the euro area, large parts of the euro area are in a bad equilibrium, in which you may have self-fulfilling expectations that feed on themselves, and you have to stop this, and central bank has the capacity to stop this. And as I said, in fact, spectacular effects on the spreads, since the announcement, the spreads have gone down dramatically, and the higher the spreads were, the stronger the decline was, therefore the great decline in the spreads was the most pronounced, and so forth. So I think this was the right step, the ECB, in fact, saved the eurozone, but I still feel a little bit uncomfortable because too many conditions have been attached to this, the ECB has announced that, well, you should go into some austerity if you want to have liquidity, and I personally feel that austerity has been too intense. But anyway, I think it's important. Yeah, I'm going to skip a few things. There's been a lot of criticism of this program, not going to go into that. Maybe during the question time you may want to raise these issues. What about inflation risk? What about the moral hazard risk of all this? And what about fiscal implications? But I will skip that so that if you want to come back to that, so I'm just going to skip quite a lot of these slides here. If you want to come back to this, I will be happy to do so. Now I come to my second dimension. I talked about the role of the ECB. What kind of central bank do we need in the Monetary Union? Now I come to the nature of macroeconomic policies. How should they be designed today? And here my fundamental point is that countries, the way it has been dealt with is very asymmetric. And we should move towards a symmetric adjustment mechanism. Here is the nature of the asymmetry. I show you the relative unit labor costs in the number of countries that have been experiencing financial difficulties. Prior to the crisis, you can see how these relative unit labor costs in all these countries increased. So the relative unit labor cost is the unit labor cost of a particular country divided by the average unit labor cost of the other countries so that it's a measure of competitiveness. If that line goes up, it means that unit labor costs increase faster than in the rest of the eurozone. And here you see Ireland with a very substantial loss of competitiveness prior to the crisis and since then quite a significant adjustment. And you see the same pattern or similar pattern in most of the other countries, although not as strong as in Ireland. Here is Greece, also significant adjustment. Here economists call this decline here, internal devaluations, you lower wages and prices so as to restore your competitiveness. I don't have to explain you that here in this country. I also don't have to explain you how painful that is and how that initially turns into a recession. And the positive effects that you may hope for, competitiveness improvements, take more time to work through and especially if everybody is doing this at the same time. That's the difference, for example, between what is happening in the eurozone and what has happened with one Baltic state that also does an internal evaluation. But being a small country and doing it more or less alone creates then a much more potent positive effect of improvement of competitiveness relative to the negative effect of a reduction of purchasing power of people. So this has been a very painful process in all these countries. One might have hoped that the other countries, these are the debtor countries, the creditor countries would have done the opposite, did they and the answer is no. Nothing, almost nothing happened there. So we have a very symmetric adjustment system where the debtor countries are forced to do all the adjustment. There are imbalances in the system, current account deficits of some, current account surpluses of others and it is the deficit countries that have to do all the adjustment while the surplus countries do very little. And that creates a deflationary bias. And in my view also the reason why we have turned into a double-dip recession. So this is the growth of GDP in the eurozone and you can see the big but relatively short recession in the period 2008, 2009, then there was a recovery and we turned back into a recession last year, essentially. And the question is, will we get out of this? But my point is that we got into that double-dip recession precisely because the macroeconomic adjustment was asymmetric and it created a deflationary bias. If only the deficit countries, the debtor countries have to do the adjustment by reducing spending relative to output while the others don't do the opposite, that is increasing spending relative to output since they have a current account surplus, then the whole system turns into a deflationary machinery. So towards more symmetry, how to do it? Well, clearly the debtor countries somehow are condemned to go on with some form of austerity but I would argue spread over a longer period. But this must be compensated by a willingness of the creditor countries to do the opposite. You have to reduce spending relative to output. The creditor nations should increase spending relative to output and they have the means to do so. Here I show you the debt to GDP ratios in the creditor countries and you can see that with the exception of France, all these countries have stabilized their debt to GDP ratios. So my rule would be just go on stabilizing your debt to GDP ratio. That is you can have some deficit, especially for Germany it's important. Germany is the major country among the creditor nations. Germany now tries to and has achieved a balanced budget, that is it's now pushing the debt to GDP ratio downwards. I'm saying stop this, take as a rule to maintain the debt to GDP ratio fixed and that allows you then to have a budget deficit of about 2 to 3 percent because the denominator in the debt to GDP ratio, GDP is increasing at a nominal rate of 2 to 3 percent and that allows your deficit also to be around 2 to 3 percent. You add some debt while your GDP grows nominally. But that is not what Germany wants to do today. Today they want to go to balanced budget like in the 1930s. In the midst of a recession, balanced the budget. So that should be the rule. The debt countries of course are on a very different path, an explosive path of debt to GDP ratio. I was told during lunch that it's going to stabilize here. Is that right, around 123 or 4 something, right? So most of the debt to countries are an explosive path. Italy is not really, they have not much choice but they should count on the others willingness to stimulate their economy so as to make it easier to stabilize their own debt to GDP ratios. Okay, so that's what I've, and then let me conclude by saying a few things but very short but come back to that at the later stage if you like. In the long run, economists have recognized right from the start and we talked during the lunch also about the McDougal report which was produced in the 1970s and which was a view about future monetary union. And the key element or the key proposal there was that if we do a monetary union, we should also have some form of fiscal union. We have completely disregarded this when we created the monetary union. Those who designed the monetary union said, we don't need the fiscal union. This turns out to be wrong, right? We now know it's completely wrong. So ideally we will have to go to a full fiscal union but what is a full fiscal union? The example of the United States that would be like a federal nation but with the union, fiscal union and that's 25% of GDP. So the budget, the EU budget is 1% of GDP and a discussion in Brussels to raise it from 1 to 1.1 leads to terrible conflicts, right? So it's clear that in the foreseeable future we will not go there maybe in 100 years. Who knows? But not in our lifetimes, okay? So that seems to me to be something we have to take into account. So the question is what can be done? Should we despair and say well it's lost? Some people say that, yes. I would say no, we can do a number of things that also have a signaling function, right? We all know that this full fiscal union is too far but by doing a number of things we can signal that we really want to go in that direction, right? That's the direction of the fiscal union. Well let's start moving in that direction and not in another one, right? That's key to maintain confidence in the future of that monetary union, right? And what do we have to do? Here are some things that have been floating around. I'm not inventing anything here. I do believe that partial pooling of debt is part of this, right? Where we issue euro bonds in a limited way, right? We take enough care for more hazard issues that arise there and there have been several proposals to do that, right? But that again is a signal, there's a signaling function, right? If you start doing it, it's like tying your hands and making it clear, yes we are, we want to stay together, right? That's what you want to do. The banking union is another important element in all this and we have moved forward. So we have done a number of things. Banking union has different components. One is the common supervision and that seems to be accepted. And the other one is a common deposit guarantee system and a common resolution mechanism. These are the weak points, especially the common resolution, because that also implies some type of fiscal union. When you have to resolve a banking crisis at the European level, then you need to pool resources to do so and some institution must be able to garner these resources quickly. In times of crisis, you really need a powerful institution that is capable of doing the trick of resolving banking crisis and that can only be if that is an institution that has some capacity to raise taxes or that can, through rules that are credible, obtain tax revenue from the participating countries. These are key elements that we have to introduce, but as you know, this is now very much contested, especially in Germany, and therefore it's unclear whether we will move towards a banking union soon. All this requires transfer of sovereignty. We shouldn't have no illusions. So sovereignty is key in this whole process. And as a result, we can also say that political union must remain and will remain the necessary condition to make this whole project sustainable in the long run. So one way to put this, the euro is a currency without a country, so we have the choice either we create a country at the European level and then we can keep the euro, or if we don't want to create a country at the European level, we should say goodbye to the euro. Thank you for your attention.


back to another video. So this video is going to follow on from our last one, what I looked at using or creating a very first user form for you to use in that form to do some data entry. So you remember we created this simple process. So ignore on the left here, this is obviously the VBA window or our actual form we've developed. By the moment, if you click open form, we get this pop up, not pop up, but this user form, what allows us to put in names, let's go Nicky Nels. So you can see I've got a first name and a last name for you. When we get submit, they are then added to this list of names that we have here in column A and B. What we want to do is we're going to build upon this so that actually it's a working or it's kind of like a mini database in the sense that we can obviously add new records. But also if we've got an existing record, we're able to go into that record by simply double clicking on the first name, which will then open the record up for us so that we can make the edits that we require. So there's a few things we need to do to this and we'll try and cover them off in separate stages as we go through. The first thing we need to do to our data really is to add a unique identifier. And the reason we need that is we want to have a unique idea or a unique reference for each record in this list so that we can use that ID when it comes to identifying if we're adding a new record or if that record already exists such as when we're trying to edit one obviously what's in already in that list. So the first thing we're going to do is we're just going to move our button out of the way just to give us a bit more space. And I'm going to create another field so I'm going to do the formatting there, paste it into here and we're going to call this employee ID. And because we've already got some existing data here let's just remove some of this. So let's get rid of these ones here. Let's move Mickey Mouse up to that one there and move our button out of the way, move here and just delete that just to make sure there is nothing contained in those fields. And for our employee ID we're going to follow the format of having the letter E standing for employee and then we're going to start our IDs from 1000 so we'll incrementally go up. So the first record we have here will be 1001. The next one will be E1002, E1003. So I'm going to literally just done that for those first three there just so we have a starting point to obviously start from. We could obviously get rid of all these names and actually maybe we should do that maybe that probably make more sense. Let's just get rid of these names that we've got here, delete, share sales up just to get rid of all that so we can start a complete fresh. And as I said we've obviously just added that employee ID there just so we've got a unique identifier for each of our records. I'm also just going to change this text so rather than open form we're going to call this new record because we're only going to be using this button when we want to add a new record to our sheet. So right there's a couple of changes that we now need to make. So at the moment we know if we hit this button it runs, it's assigned to this button so let's go into here. We can see we've got the open form macro so if we then go into our module where that's stored just double click. You can see at the moment we just have the simple instruction user form show once that button is pressed. So we need to build up on this now just so it'll obviously do the detail that we require. So we'll leave user form show there but I'm just going to add some rows in here to get us started. What we now need to do is we need to identify first obviously what is the next available row or how many rows of data are in our sheet and that's going to enable us to be able to identify what reference number should be assigned to them because obviously we want to incrementally increase each time. So to do that I'm going to go dim I last row as integer so that allows me obviously it's going to store an integer value there and lastly because we're in the module we need to be referencing to sheet number one in this instance. Obviously we're just going to stick with sheet number one but obviously you might want to be cool and that's something a bit more descriptive if you're doing this as a real world example. Dim sheet one as worksheet. So we've got them done for us so we now just need to define these two variables. So the first one is going to be set sheet one with equals sheets sheet one cool so that's that part then and then I last row is simply going to be our friend that we use quite a lot and that is going to be sheet one because we now just define that in that previous one there and we're going to do cells sheet one dot range on sorry sheet one dot rows dot count comma and then we'll do this in column A close brackets dot end in brackets excel dot row. So what I'm going to do is obviously give us how many rows basically of data we have the moment this will just give us the value of number one because obviously all we've got there in column A is one value which is obviously the header for us in this instance so once we've done that we've got the detail that we require and we can now get rid of this user form one dot show and not completely get rid of I'm just going to literally tidy this up by doing it within a with statement so we can do with user form one and we have to have end with at the end here so the first thing we now need to do is ah and actually we can't do this just yet I'm jumped ahead myself what we need to do is if we jump back into the user form and we'll go double click on there so we as you'll notice what we haven't done is we haven't added a third text box what is going to capture this employee ID so what I'm going to do is just pull this down ever so slightly pull our submit button down as well so move that here so let's go into a view toolbox there we go we'll have what we need so I just need to do a first one I'm going to create is going to be employee ID and let's just make that a bit smaller we don't need all that space taken up and that looks about in the right spots and again a toolbox popped over there let's now add another text box fields so I think it's about that sort of size yep perfect and let's get through the toolbox have a look how that looks yeah it looks about right and then what we can do is also with this text box I'm going to make this so it's um when we're looking for enabled I'm just going to just make that unenabled and I think there's another one I want as well and I'm going to lock it so basically all that means is to the user when they open this form they're unable to do anything with this field and that's because we're obviously going to define what that ID is in our code and we don't want the user to be able to change what that number is so we'll now add that field so we can go back into this module because we now have something to refer to um yeah so with user form one so the first thing we're going to do is we're going to go text box three you say it's not available there dot text equals and this is where we're going to define our um ID so we're going to define it's going to be e it's going to start with the letter e and it's going to be 1000 plus our i last row so what that basically means is in our i last row here we found that how many values are in our data and for us there's no data here at the moment so all it's going to do is say there's only one row of information at the moment therefore this is what is our head is so we know row number one is our head is therefore the first item we add to our list is going to be i last row so it's going to be the number of one so once we've done that and obviously it's going to have the e at the fun and be a thousand plus that number uh what will give us obviously the employee number and then the next part we need to do with the user form is go simply go dot show so it's going to show the user form so the first thing we'll do is our user form it'll set this text box three with our required id and then it will show the user form to us as well and that is it so having done that we can now quickly give that a test so module one if we do new records you can see it's giving us our user form it's popped up and you can see we've got our first id populated for us so it's e 1001 and as you can see we're unable to do anything with that field so we're unable to change it or yeah we just basically have to leave it as it is so this time we can go with our adding a record so just go home uh simpson and then when you go to tab because we've unable to disable that tab obviously it won't go to this field it goes straight to the submit button so once you hit now submit it'll add homo simpson to our data and you can see there's something we forgot to do obviously we haven't captured and stored the employee id therefore what we're going to do is just delete this one more time because obviously that's wrong go delete shelf cell so we now need to go into our user form so go to user form and go view code and simply the reason it didn't work is because we haven't defined obviously how to populate column three or column c shall I say all we need to do here is go sheet one dot cells and it's going to be i last row comma uh three so this is the cell reference that we want to populate so we're now looking at column c the what value of that equals text box three dot value and it is as simple as that and what we could do here as well just to tie this up as we've done it the last one is go with sheet one and then we go end with and then we can get rid of sheet one sheet one sheet one and it just tidies our code up and it just gets us looking a bit more structured with our information and also what we want to do is just tidy this up ever so much bring that back there and bring that one back there as well well didn't want to do that I want to do that there you go do that so you can now see it looks a bit more tidy there as well so this time if we go to add a new record here's our user form it's giving us our employee id comma simpson submit and you can see our id is now stored there as well and let's just try another one so this time let's go uh mcdonald duck and you can see that it's identified that we've already got one record there so the next record to add in there is going to be employee id 1002 and there we go and we can see we've basically got our information as required so that is all working perfectly we've got our new field added and we're able to add new records with a employee id so the next thing we now want to do is to be able to edit our records so say we've got Donald Duck here I can see that it's got uh hasn't got a capital D and I know you can go and change that here just by doing that but let's say you want to use the form so if you want to double click here and open the record within the user form how do we do that well in order to do that we need to now create another way of launching the form so I'm going to double click on sheet one and you can see at the moment we have no code entered in here so we're going to be looking at another change event so previously we looked at uh change events for when you first open save or close a workbook well this one is going to be called what is called before double click so it basically means that this event will launch every time you double click in a defined range that we provide so it looked quite familiar um in the first row of this sub routine as you've seen those previous change event videos but obviously it's going to be different uh because it's slightly different so we're going to go private sub worksheet and scroll before double click open brackets so we've got five our target as range so target is obviously the area that we're going to be double clicking in and then cancel as boolean so obviously if you're going to click into that range hit enter and you can see it's done the end sub routine for us as well and let's just move them down so we're going to need to use our last row finder again so we're going to just bring that into the equation so we're going to dim i last row as integer not interior integer cool and we've got that important for us so we can now do i last row equals cells so we don't need to refer to the sheet that's why i'm not defining the sheet in this one because we're actually coding within the sheet itself so it knows that everything is being referenced reference to such as cells is going to be contained within this sheet therefore that's why we don't need to define it just in case you're wondering there so we've got cells rows dot count a so and excel dot row so we've got that informed for us as well okay so we've got that information ready for us and this is literally just going to help us understand well not understand so what we want to do about double click is we're going to only have it working in column a and within column a we're only going to have it working within the number of rows that we have information for so if someone was to double click in row five nothing would happen because we have no no data available to us in row five but if they double clicked in row three then it is in a range that we want to obviously work with so what we're going to do is come down to here and we're going to type if not intersect intersect open brackets and we're going to target and we've got to define what our target is so that is going to be range a to to a so this is a column a part and i last row so it's only going to go the range of a to so from row two down to how many rows of data we have in that range obviously what's going to continue to grow over time is nothing then right cool so if not perfect perfect and we're just doing end if here as well and we can tap in so okay so if we do if there is a double click that happens and it is within this defined row so two and three as you see here what we want to do is we want to hear with user form one and with dot text box so what we're now going to do here is so if someone double clicks within this defined range we want to open our user form and not only do we want to open the user form we want the user form to be pre-populated with the information available to us on that row that we double clicked so we're going to do is go text box one dot value equals cells and it's going to be our active cell dot row and one so what that means is obviously i say we double clicked on download here this cell here so a three is now our active cell so what we want to do when we're populating text box one is we want to say okay we want to populate text box one based on the value in this cell and this cell is going to be active cell dot row so it's going to say okay it's row three and it's within column number one so column a so that's all we're going to do when we get any information the next one we want to populate is go text box text box two dot value equals cells that's going to be the same active cell dot row but this time we want to put it from column two and then the last one we've got text box three dot value before expel value value equals cells and it's going active cell dot row is going to be from column three and then the last thing we now need to do having populated the user form is to show it to the user so that they can see the user form with that information ready to be populated once that's all done we can then remove these and the last thing we want to do is just enter a row in here as cancel equals true so do that and what that just basically means is when you obviously double click into a cell obviously now you don't want to like it's the only stuck in the cell obviously it just moves away for us so what we can do is we do that so you can see at the moment you can double click and actually be in the cell to edit whereas if we do this cancel is true obviously you can't actually double click into a cell that's all it basically means and it just makes it easier using so say you said double click into a cell and there's some information and then come to move away from it you have to then click away from the cell before it's usable again and I probably made that quite hard to understand but the benefit of using this is obviously this single line of code here but if you still want your users to double click into the cell all you need to do is just delete or comment out this row here so let's have a look at what we've now got available to us here so if you want to do a new record we can do a new record it's going to pick up that the next ID should be 1003 and we can call this one a Mickey Mouse six emit and you can see that the record is there if we now go and double click in row six seven or eight or five nothing happens but if we double click Mickey Mouse you can see that it's opened up our user form for us and pre-populated the information available to us for Mickey Mouse we close that and then go home to Simpson you can see that it's now done the same for us again so we're now really getting into the dynamic use of our file the only problem that we have now is if I was to change this so let's go home to Simpson number one and hit submit you can see that rather than overriding or updating this existing record for home to Simpson it's added a new row so that's where we just now need to do a final little update to our the user form in the terms of when we hit the submit button so that it can identify if that record already exists or if it should be added as a new record so we now need to update that code in the user form so it was going to go into user form view code and you can see this is the existing code we have as it stands so that when the submit button is pressed on the user form all the information is gathered it will find the next empty row what's obviously going to be very five if we're looking at it now and paste the information in for us what we want to do is just apply a bit of logic that will say okay well if it's already existing in our range then therefore we want to take or we want to paste into the row number of that existing record or obviously if it's not we want to go to continue on with this new row so in order to do that we're going to add another integer so dim i row as integer and so this will make sense as we step along here so we've got sheet modified and we've got the last row here and this is obviously where the information is populated into our excel file so this intersection here we now need to do we need to have some logic so we want to say logic to determine where to add record so there we go this is the bit where we now need to add some additional code in here that will do this logic for us so the first thing we're going to do or basically what we are going to do is do an if statement so we're going to do an if statement that includes a match formula so you might be familiar with the normal match formula available in excel to basically try and find our if our record already exists and it's also going to use if error so this is where i can get not confusing in terms it's too technical just because we're going to be dealing with if error so obviously that can some obviously is going to give us the inverse of actually what we're looking for and i think that makes sense but we'll step through it so the first thing we need to do is go if is error open our brackets so we're going to do application dot match so this is how we can do a match function within vba and we're going to say okay what's the text box three dot text so this is the value that we want to search for we want to search for this in the range of sheet one dot range c2 to c and our last row and i may not just type this and then talk through what it's doing once complete that might be easier and then cool it might help if i actually do the ensemble rather than the number seven and then go enter perfect and then go down to here and if we'll tidy all these space up in a second so what this is saying is we're going to do this match formula here and the match formula is this section you see here what's going to happen is going to take the value within text box three which is our id and obviously this is the value in that text box it's then going to do a match formula in this range here so from c2 down to obviously how many rows so at the moment to row four and obviously we want to use we've got zero here to do an exact match what that's going to do is going to say well the match formula returns a number so it would tell us the number or the placement of the value if it existed in this row so let's say it was one zero zero or e one zero zero one the return of the match function would give us the number one however if it doesn't exist in that range then the match function will return an error message so it'll because the value is not available and that's why we've used is error so because we've used is error what this will now do is if our value is not available in that range so it doesn't exist and therefore it's a new record what's going to happen is this is error is going to return a true statement because what it's saying is if there's an error is there an error in this formula if it doesn't exist there is going to be an error therefore it's going to return a true statement so based on that we have two options if it is a true statement so it's not available then we want to add a new record however if it's not an error and the value is available there then we obviously want to make sure we update the existing row so how can we just do that so let's go into if and go let's just do a message box in msg box and we're going new record so this is the new record scenario so this is saying if there is a true and so there is an error here what we're going to do is i row is going to equal um i last row so let's bring that back in there and it might make more sense to do this so let's go i update this i row i row i row so previously with our our formula here or not formula code we were always adding our record into the next available row which is i last row but because we now have two options it could either be a new record or it could be an existing record this is why i've added i row so i row can then obviously default to either i last row or it can default to the active cell row if it's an existing record that we want to update so this is what we're using that if statement we're basically using the if statement to define what i row is and then we'll see i can just refer to it in this code down the bottom here so if it is a new record then we're obviously what a little message box at the moment will say oh it's a new record however and if it is a new record we want to place it into the next last row however if it's not a new record then we want to make sure we update the existing row where that uh record is currently occupying therefore we can do message box and then the existing record by so and therefore i row is going to equal uh active cell row like so and then we can just remove this information here like that we can remove that information from here that's about tidy so hopefully that now seems logical and let's just move that out perfect so what's going to happen is when we add a new or when a record is when we're basically in the user form section when we hit the submit button what will happen is we'll do this quick validation to see if our id already exists in this range if it does already exist it's an existing record therefore we want to update the data contained for that record else if it doesn't exist in that range then we want to add it as a new row so let's go through those two steps so add new record and we can see because we've done the add new record it's going to populate a new id for us so this is quite simple we know it's a new record and let's call this one uh mini mouse and then go submit and we can see we've got a message box here so it's done the validation for us it said okay take this id does it exist in this range was highlighted here no it doesn't therefore it must be a new record okay so it's going to submit it for us however if we double click on donald duck and obviously we've got our information populate for us including the id and let's say we change this to capital donald or donald like that uh donald duck one or donald one and duck one what it will now or should do this time is now hit submit yet you can see it's done the test it's identified that this id or because it already exists in this range and therefore it's identified as an existing record and because of that what it's going to do is say okay well this is the active cell here in a three what is the row number it's row three therefore populate this information into row three rather than add a new row and you can see it's done just that so that is how we can obviously build upon our last video to create this workable mini database for adding and amending existing data so i hope you enjoyed that video it was obviously quite a bit longer than our normal videos but obviously it was quite an in-depth one to talk you through that process i will make this file available to you so if you want to download this exact file and use it um basically either just to understand it better or if you want to build upon this for your own uses then obviously feel free to do so you'll find the link to this download in the description to this video if you did enjoy the video please do make sure you give the video a like uh it's obviously not only greatly appreciated by me but does help that all important youtube algorithm and if it's the first time finding the channel or you've watched our videos before please if you haven't already do subscribe to the channel and hit that bell notification button so you are notified of all of our future videos so lastly thank you very much for watching and we'll see you in the next video


alright everybody what is going on welcome back to another video and to my very first twitch streaming schedule today's video is pretty exciting for me this is the first step to you know trying to create some sort of a presence on twitch I want to have two platforms guys I want to have two platforms that I'm passionate about I want to have two platforms that I put equal amount of effort into and they are YouTube and Twitch now you guys know I've put a whole lot of effort into YouTube and when I want to do something I do it and I've been trying you know pretty sporadically to try and grow my Twitch channel I believe that the audience we can create on there could be really something quite cool I want to be the sports guy I want to be playing Madden I want to be playing NBA and I want to be playing FIFA the next step in my Twitch career I guess is to not only have a great environment to stream in which I do I can come in here switch to computers on and I'm ready to go not only that I've got that sorted secondly I need a schedule so to become a Twitch partner as a lot of you probably know already you need an average of 75 concurrent viewers on any stream any one stream at any one time over a 25 hour period over the last 12 days at the moment on average without me doing any advertising but I might put a quick post on Instagram or possibly on my YouTube story but I haven't done anything yet really to try and grow this audience my maximum viewers at any one time has been I think 20 and my average is about 7 so currently I'm a tenth of the way to becoming a Twitch partner and that is a huge goal of mine and I need your help so if any of you guys do enjoy Twitch I'm not gonna ask for your attention on Twitch if you don't actually enjoy it but if you do and you like me as a person and you want to come and play me either yeah come and play me come and suggest a game come and suggest me you know come and have a chat man that's what Twitch is all about I've come to find a lot of people that watch people on Twitch including myself go for the person they're not going for the actual game you know they might play the game in their spare time but you know most likely if you're gonna watch my stream I'm not the best at the game but I hope that my reaction and my personality shines through and you enjoy the time that you spend in the chat in the stream and that's you know all I can ask for so today we're gonna be making a schedule I'm gonna tell you that but also once the Twitch streams are done I'm gonna download the videos and upload them on my YouTube channel for you guys to see as well or the highlights at least so the schedule whoa slow down Jacob slow down the schedule Monday Wednesday Friday Australian time 4 30 a.m. to 6 30 a.m. now before we go on where I am in Australia is actually half an hour behind most of the coast most of the East Coast so that means it's gonna be most likely 5 a.m. to 7 a.m. Australian Eastern Standard Time which means if you're in Canada or the US the time will be if it's 4 30 my time it's gonna be 5 o'clock in Sydney 5 a.m. shipment this is testing my brain at 5 30 in the morning 5 a.m. in Sydney would be and correct me if I'm wrong 3 p.m. the day before in New York and 12 mid day the day before in LA so if we're going Monday Wednesday Friday 4 30 a.m. my time to 6 30 a.m. 5 a.m. to 7 a.m. Australian Eastern Standard Time that would be 3 p.m. to 5 p.m. New York time or 12 midday to 2 p.m. LA time and if you can tune in tune in I'm gonna be there we'll be putting reminders on my Instagram page before every stream but this is it guys okay so if you're in New Zealand or Australia you can work it out if you're in America if you're in LA let's say it's gonna be Sunday Tuesday and Thursday from midday to 2 p.m. if you're in New York it's gonna be Sunday Tuesday and Thursday from 3 p.m. to 5 p.m. and I hope to see you there Jacob McDonald to 7 is the name I will be there every single Monday Wednesday Friday Australian time I can't fucking wait today's date is Wednesday the 10th we're gonna be starting this on Friday Friday's gonna be our first stream 4 30 in the morning as you guys know 4 30 to 6 30 my time which is confusing because that's actually 5 to 7 Australian Eastern Standard Time which is gonna be the time that I use so we're gonna say 5 o'clock to 7 o'clock a.m. Australian Eastern Standard Time on Friday which for you guys in America is gonna be Thursday from midday to 2 p.m. or from 3 p.m. to 5 p.m. depending on what side of the country you're on following this video I'm gonna put up four different twitch highlight videos I've done four different streams on twitch so far I've cut them and created the highlights of all the attacking plays from from me playing Madden I hope you guys enjoy if you do like that that's the kind of stuff that you can expect on twitch so I'll see you there I'm not gonna ask again this is it my twitch streaming schedule Monday Wednesday Friday for 2 hours at the moment let's see how it goes 75 average viewers if we can do that man if I fucking get to partner you know it's gonna be amazing at the moment there's no way in hell I could ever do that without your help so that's what this video is about peace out guys have a fantastic day and I'll see you on twitch