Monthly Archives: February 2017

Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, The Farm CEO

Tayo Solagbade’s Excel-VB Poultry Farm Manager – Video Interview With Lagos Farm CEO After Problem Resolution [PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 2 of 2 | Based on a True Story]

Leave a comment

In this second and concluding part of yesterday’s newsletter, I feature the FULL video interview (with the verbatim text transcript). I recorded it with Thompson Obuseh, a Lagos based Poultry Farm CEO, after I’d resolved a major part of the “Compile Error” problem he’d been having, for 4 days with my Excel-VB Poultry Farm Manager on his 64-bit laptop computer.

Preamble/Background

On Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a young Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

I’d made him an offer then which he’d not taken up. Then on Tuesday 20th February 2017 he’d called in at about 8a.m and 24 hours later, he’d made payment to take up a new offer I made to him.

However, over the next 4 days after I emailed him a personalized copy of the software, he had NOT once succeeded in making use of it, due to a nagging “Compile error” message it kept throwing on his Laptop.

I tried to support him remotely, to no avail. He was understandably disturbed – & even expressed doubts that the app worked!

To resolve the problem, I invited him to meet me in Ikeja, made upfront payment to his bank account to cover to/fro fueling of his car from his Victoria island based, so I could solve the problem – and prove that my app worked!

By the time we were done, I got him to take a photo with me and also recorded THE testimonial video you’re about to watch, of him sharing his feelings and observations about what had been done, and the experience he’d had using the app, in the few hours he’d used it.

Read Issue PII 055 of my Performance Improvement Ideas newsletter published yesterday Monday 27th February 2017, for details of how I identified the code module declarations (for Windows API calls I used in my app) that new requirements needed me to adding the PtrSafe attribute highlighted in the error message to.

1. Read this video’s text transcript below, and the full story about what happened here

2. Watch 16 step-by-step User Guide Video Demos at www.tinyurl.com/15pfmVideos

3. You can contact me using the form at www.tayosolagbade.com/contact.htm

The PFM has been proven to work in Excel 2007 up to 2016 without ANY problems – and this is captured in video demonstrations.

The problem Thompson had is more of a rare exception, than the norm. Thompson himself estimated there will probably be only 1 in 50 buyers I would encounter with his kind of peculiar situation, in which his laptop is always plugged into the corporate network where daily automatic updates happen to its Windows and Office installations.

An Excel-VB app like mine, meant for private use by the owner, when run on such a laptop would be encounter restrictions designed to prevent unauthorized apps with potentially malicious code from running without limitations on it, since it could infect other PCs on the network if it was a virus.

In case you’re not aware, Excel-VB code has been successfully used to create harmful virus applications that have caused major damage in the past.

This is the reason why Thompson’s 64 bit laptop settings were stricter than those on other 64 bit computers I’d seen my app run on before meeting him.

Read Issue PII 055 of my Performance Improvement Ideas newsletter published yesterday Monday 27th February 2017, for details of how I discovered I needed to make changes in the code module declarations (for Windows API calls I used in my app) by adding the PtrSafe attribute highlighted in the error message.

Below: Verbatim Text Transcript  of the Video Testimonial Interview with Thompson Obuseh which I recorded with him, AFTER we were done

Tayo: Right. So I’m speaking with Mr. Thomas. How do you pronounce your surname again?

Thompson Obuseh: It’s not Thomas actually. It’s Thompson Obuseh.

Tayo: Okay Thompson – sorry! Apologies for that. Okay, I know when we met this morning, I could see smoke coming (from your ears)

[Both laugh]

Tayo: So, so…maybe I should show my face [Camera turns to briefly show Tayo’s “mug” :-)]

Tayo: This is me O, guys Ehn! [Camera returns focus to Thompson]

Tayo: Now, it’s been a long time since I did a video, but I want to do this because this relationship has happened and I’m happy about the way we ended it. So ehm Thompson, we’ve had a session – about 2 hours right…probably more than that?

Thompson Obuseh: More like 2 hours

Tayo: More like 2 hours. Okay and ehm Thompson came (driving) all the way down from Ajah

Thompson Obuseh: Yes. It’s even beyond Ajah sef. Abijo – that’s where I stay.

Tayo: Oh really?

Thompson Obuseh: Yes, I stay in Abijo. I just dey say Ajah because…

[Video cuts off due to run down of my workhorse Blackberry Smartphone’s battery]

Luckily, I’d gotten my 18 year old son to lend me his Gionee E3T Smartphone as a backup in case that happened (Experience having taught me well in the past!).

So, about 2 minutes later, we started the interview all over again – but only after I’d gotten Tom to teach me how to use the touch screen interface of the phone.

By way of interest, I am yet to embrace those kinds of devices due my bias for the key based use of mobiles. As a result, my kids use cooler looking and more expensive mobiles than I do! Why? Well, that’s a subject for another day.

====

Tayo: Just a minute O. Okay. Alright, so ah, this is Mr. Thompson Obuseh. Ah I was just making a comment that when we first met, after I got directions to get him down to this place in Omole Phase 2, I’m serious, smoke was coming from his ears

[Both laugh]

Tayo: We had been on phone for 4 days or 5 days sef, and it was not funny. He was getting compile errors from the Excel-VB Poultry Farm Manager, and me I could not understand where compile error was coming from.

Anyway, long story short, I had to direct him to meet with me. You know, we were all blowing grammar on the phone.

I said “Let’s just meet and sort this thing out once and for all!”

Ah, he’s going to speak now. We’ve finished…we’ll we’ve gotten some things started. At least we have sense of direction and I just want him to comment on how he feels NOW!

[Both laugh]

Thompson Obuseh: Well, I’m a lot (better) because I invested some amount of money and I was not getting results. Like every customer

Tayo: Naturally…

Thompson Obuseh: Yes. Naturally, like every customer if you don’t get service for what you have paid for…

Tayo: You start wondering…

Thompson Obuseh: Yes, you have to wonder. But now I think there’s a sense of direction. He’s been able to resolve let’s say 50% of the problem. I can now use it, but the others as they should come up, he promised to fix them.

Tayo: Yeah. Okay, good. And eh, what would you say in terms of, how do I put it now, the application itself. How easy it is to relate to? How to you find it?

Thompson Obuseh: Ah, from what I’ve seen, just like I saw online, I think it’s good…the interaction is perfect. You just need to have the basic knowledge of Excel just to use it. Yes. You can interact with it excellently.

Tayo: Right, so this is me speaking. Let me show myself [Laughter]

Thompson Obuseh: You can show yourself

Tayo: Yeah, you told me about how to do it, but you know, me and this thing, you guys are seeing us abi? [Laughter]

Tayo: Okay so, we’re  making fun of ourselves now. It turns out that Thompson’s wife speaks French and teaches French. So, since I speak French, that’s another dimension to the whole thing. Anyway but it’s been a useful experience for us today, and ehm I’m sure we’re gonna sort this out to final point. And then I’ll be using Thompson’s version for any other person that comes with this wahala of compile error. I just carry am throway – “Take, no disturb me!” [Laughter]

Thompson Obuseh: (Jokingly) Well, it’s good. maybe you just have to give me some commission

Tayo: Yeah, no…we’re going to…what we’re even going to do is, this video, we’re going to say, without Thompson coming up with his compile error thing, I wouldn’t have had a need to come and look at it and actually meet…I cannot remember when last I met with anybody. Because I’ve been selling and people are just using it, and we talk, and they say I’m made entry, I had this…plotted this chart…

So when this happened…he rightly pointed it out, I don’t disagree, that having the opportunity to do this has created a new dimension in terms of level of users. Because there are some users who will have this problem he’s having and we’ll be able to have an answer for them.

Thompson Obuseh: Instant answer. Once he’s just…say don’t worry, this is what we’ll do.

Tayo: Yes, no need to asking questions. Just say “Oh, that’s the problem you’re having? here is the solution! We’ll call it “The Thompson Solution” {Laughter]

Tayo: Alright, cheers men

Thompson Obuseh: Alright, bye bye.

Career Development, Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, Self-Development, The Farm CEO

PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

Leave a comment

Nothing beats being a master of your craft. You need to invest endless time, effort, money and any other necessary resources, to become as proficient as possible at it, so that ANYTIME those you serve demand for your problem solving attention, you will not be found wanting.

It is with regard to my Excel VB Solutions Development that I have narrated the true story featured below, in this week’s issue of my Performance Improvement Ideas newsletter.

Yesterday, Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a Lagos based Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade's Performance Improvement IDEAS(PI Squared) Newsletter

Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

Monday 27th February 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016. I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

************

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

Nothing beats being a master of your craft. You need to invest endless time, effort, money and any other necessary resources, to become as proficient as possible at it, so that ANYTIME those you serve demand for your problem solving attention, you will not be found wanting.

It is with regard to my Excel VB Solutions Development that I have narrated the true story featured below, in this week’s issue of my Performance Improvement Ideas newsletter.

Yesterday, Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a Lagos based Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

tom-pre-solution-thb

I’d made him an offer then which he’d not taken up. Then he’d returned last Tuesday, on 20th February 2017 – calling in at about 8a.m in the morning. About 24 hours later, he’d made payment to take up a new offer I made to him.

In my usual manner, I proceeded to use details he supplied to me about himself and his farm business, to personalize the PFM and accompanying products, which I emailed to him.

I could however never have predicted what happened over the next four days.

The drama began with Tom writing in to say he’d been unable to launch the spreadsheet app, because each time he tried to do so, it returned a “Compile error”.

Past experience with other users who’d initially struggled, made me ask if he was using a computer running a Mac OS. He sent me – in response to my request – screenshots of his PC’s specs as well as that of the error message returned by the app. I noted he was using a 64 bit HP ProBook – so the Mac issue was ruled out.

Long story short, my mind went to the possibility of a 32-bit vs 64-bit conflict. But I had problems accepting that possibility because not only had I successfully run the app on 64 bit computers myself, but I had also seen others do the same – including the manager of a neighborhood café I use.

So, I had a dilemma. In the past, I’d had to follow tips provided on the Microsoft website to adviSe a client in 2014, to step down his Excel version from 64 bit to 32 bit via custom install from the disk.

He’d reported getting a different error message – shown below – from that seen by Thompson:

“Microsoft Forms… Could not load an object because it is not available on this machine”

The problem I had in Tom’s case was however that all he got was a “Compile error” message, so I could not make much of it. I needed more information, and I knew the best/quickest way would likely be to interact directly with the computer on which this was happening.

At a point, Tom wrote an email saying he believed my app did not work – and he challenged me to prove that it did by getting it to work on HIS own laptop!

I replied that I had told him there were other clients who used the app. I told him my suspicion was that his was a unique/peculiar problem that was NOT general to others.

After some heated debates on phone and email, I decided to invite him to meet with me, so I could address the problem he was having. Luckily, this was made easy by the fact that he lived in Lagos, and I was also in town.

By the time we met at Omole Estate Phase 2, I promptly removed the password protection from the Visual Basic Editor. Then I ran the Workbook Open procedure again, with the password removed.

This resulted in more descriptive information being added to the error message that appeared.

Compile error:

The code in this project must be updated for use on 64-bit systems.

Please review and update Declare statements and then mark them with the PtrSafe attribute.

Once I saw that, I immediately knew what the problem was, and what I needed to do. It was the modules in which I’d used Windows API calls that contained the  lines of code throwing the error.

I promptly made modifications to the code modules in a way that enabled the app launch fully to the login screen – and beyond. When this happened, Tom’s face lit up. It was the first time since he purchased the app, that he was seeing it working like I’d demonstrated it in the video he’d watched, in deciding to buy it.

While I worked, I deliberately engaged him in conversation and learned from Tom that he worked as a Network Administrator on a 9 to 5 job, and that his laptop was always plugged into the corporate network where daily automatic updates happened to the laptop’s Windows and Office installations.

On hearing that, I told him that updates downloaded to a computer on a corporate network would be designed to minimize chances of unauthorized application being run without restrictions on it.

An Excel-VB app like mine, meant for private use by the owner, when run on that kind of laptop would likely encounter restrictions I may not have provided for.

Note here, that Excel-VB code has been used to create harmful virus applications that cause major damage in the past.

When I made this point, Tom nodded in agreement, and went on to add that he estimated there was a 1 in 50 chance that I would encounter a user with his kind of situation – to which I exclaimed saying; “Now, you see what I meant when I said yours was a peculiar situation!”

We went on to spend over 2 hours looking through the various data entry and reporting interfaces in the app, as I gave him practical tips on how to use it.

At the same time, I also shared real life examples of how to make use of the app to monitor and manage farm operations to ensure timely decision making for optimal performance.

We ended by agreeing to work via email, as I proceed to make the remaining needed changes in the code module declarations by adding the PtrSafe attribute highlighted in the error message.

For now, he’s able to commence posting of farm data from paper records prepared by his farm hands.

By the time we parted, we’d shared a lot of banter, and he even arranged for me to converse, in French, with his wife, who works as a French Language Instructor with a Lagos based institution.

Before he drove off, I got him to take a photo with me and also recorded a testimonial video of him sharing his feelings and observations about what had been done, and the experience he’d had using the app, in the few hours he’d begin using it.

me-tom-post-solution

At the risk of stating the obvious, it was my confidence in my Excel-VB coding ability that made me invite Tom to come down with his laptop, so I could fix the problem once and for all.

Indeed, I actually made upfront payment to his bank account to cover to/fro fueling of his car for that purpose. That was how determined I was to solve the problem – and prove that my app worked!

I have been selling my Excel-VB Poultry Farm Manager (PFM) since 2009. I began selling my Excel-VB Ration Formulator software in 2004.

Over the years, I’ve had Farm C.E.Os. from within and outside Africa, by from me – but majority of my buyers continue to come from within Africa, and especially Nigeria, my home country.

The point to note however is that I CULTIVATE and ENJOY healthy relationships with my buyers long AFTER they buy from me.

Some buyers initially need my help to identify why they had issues, but I have NEVER needed to change my code to get it to work!

This experience with Tom, is one that has enabled me demonstrate in a new way, that I deliver on my promises and practice what I preach.

THAT is what I do: I SOLVE problems for those who connect with me, using the solutions I develop. And if a buyer encounters difficulties in trying to make use of my solutions, I ALWAYS adopt a POSITIVE MENTAL ATTITUDE to SOLVE whatever challenge s/he may be faced with.

The above is what I successfully DID today, with the Lagos based Farm CEO shown with me in this above shown photo taken just before we parted AFTER our meeting.

If you make mastering your craft a deeply ingrained habit, like I do, you WILL also be able to succeed in spite of setbacks or problems you encounter in your practice of it!

PS: Tomorrow, in the 2nd and concluding part of this article, I will feature the video testimonial by Tom.

tom-vid

sdn-pre-flyer

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app – watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

PII 054: Boost Your Success Achievement Using These 4 Services

[Tuesday]:

Two Learning Resources to Educate Farm CEOs and Other Stakeholders On the Need to Adopt an Entrepreneurial Mindset

[Wednesday]:

Equip Your Kids to Deal With Abuse of Any kind and Excel [Hint: TV Talk Show Relationship Expert Psychiatrist/Author Answers Question by Male Caller Claiming to be Abused by His Wife]

[Thursday]:

Download the “PRACTICAL LIVESTOCK FEED FORMULATION HANDBOOK” – BY TAYO SOLAGBADE, Best Practice Farm Business Support Specialist

N/A

[Saturday]:

The FARM CEO (Issue 75): Top 11 Articles on Best Practice Farm Business Management for Profit – by Tayo K. Solagbade, Best Practice Farm Business Support Specialist & Founder of the Farm Business Support Centre

[Sunday]:

[TRUE STORY] He was NOT smiling when we met, face to face, for the first time, today – because of My Excel-VB Poultry Farm Mgr!

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners).

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region.

His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter.

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas
Entrepreneurship, Excel-VB Solutions, Farm Biz, The Farm CEO

[TRUE STORY] He was NOT smiling when we met, face to face, for the first time, today – because of My Excel-VB Poultry Farm Mgr!

Leave a comment

He was NOT smiling when we met, face to face, for the first time, today – and for good reason too.

My Excel-VB Poultry Farm Manager which I’d personalized and emailed to him 4 days earlier, after I received his payment, had NOT once launched successfully for him to use!

NB: He is the VERY first buyer of my Excel-VB app I am having to meet face-to-face, post-sales, since 2012, to resolve the problem he reported having. What I found from examining my app on his PC clearly revealed I could NOT have helped him without doing so. However, the modified version I’m creating for him will addresss the needs of any others – though they are likely to be few.

I DELIBERATELY took the photo on the left when he arrived to capture the mood at the start of our interactions. By the time we were parting ways however, he was ALL smiles, and I’d even had a chat with his wife in French (after he learnt that I could speak the language).

Apart from the photo on the right (showing us smiling), I got him to do a short video interview in which he stated his satisfaction with the progress made, and he noted how intuitive/user-friendly the app was, from his very first use right there.

Tomorrow – Monday 27th February 2017 – I will be sharing insights from the full story of our interactions, ending with the video. My purpose for the above, and what is to come tomorrow? It’s simple: To make it clear that I DELIVER what I PROMISE to every client, NO MATTER WHAT IT TAKES.

Watch out for the VERY interesting full story in Issue 55 of my Performance Improvement Ideas newsletter tomorrow

sdn-pre-flyer

Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, Recommended Websites & Articles, Self-Development, The Farm CEO

The FARM CEO (Issue 75): Top 11 Articles on Best Practice Farm Business Management for Profit – by Tayo K. Solagbade, Best Practice Farm Business Support Specialist & Founder of the Farm Business Support Centre

Leave a comment

Below are links to some past articles I’ve published that I give out to farm CEOs who reach out to me – with my best wishes. No strings attached I.e it’s NOT designed to get you to buy from me.

These articles explain various aspects of what I call a BOPMS (Best Operating Process Management System)™ – or at least mentioned the need for it, towards achieving consistent farm business performance.

1. Story: After Resolving Layers Feeding Problems, Selling Increased Eggs Output Became a Headache! |

http://tayosolagbade.com/sdnuggets/story-after-resolving-layers-feeding-problems-selling-increased-eggs-output-became-a-headache/

2. Your Business Should Free You, Not Restrict You

http://tayosolagbade.com/sdnuggets/your-business-should-free-you-not-restrict-you/

3. Adopt Standard Operating Procedures to Succeed More With Less Effort (This Works for Solopreneurs and Large Organisations)

http://tayosolagbade.com/sdnuggets/adopt-standard-operating-procedures-to-succeed-more-with-less-effort-this-works-for-solopreneurs-and-large-organisations

4. Five Essential Poultry Layer Farm Production Records

http://tayosolagbade.com/sdnuggets/five-essential-poultry-layer-farm-production-records/

5. Practical Poultry Farm Business Performance Calculations

http://ezinearticles.com/?Practical-Poultry-Farm-Business-Performance-Calculations&id=2635011

6. Five Powerful Tools for Accurately Measuring Your (Farm) Business’ Health

http://nigeriabusinesscommunities.com/features/5-powerful-tools-for-accurately-measuring-your-farm-business-health.html

7. Five Proven Ways to Boost Farm Profits without Raising Prices

http://africabusinesscommunities.com/features/5-proven-ways-to-boost-farm-profits-without-raising-prices.html

8. Producing Good Catfish is Important, But Finding Good Buyers is Imperative!

http://ezinearticles.com/?Producing-Good-Catfish-is-Important,-But-Finding-Good-Buyers-is-Imperative!&id=3209812

9. Reducing Catfish Feeding Costs (A Secret Weapon) – Part 1 of 2

http://africabusinesscommunities.com/features/reducing-catfish-feeding-costs-a-secret-weapon-part-1-of-2.html

10. Reducing Catfish Feeding Costs (A Secret Weapon) – Part 2 of 2

http://africabusinesscommunities.com/features/reducing-catfish-feeding-costs-a-secret-weapon-part-2-of-2.html

11. Top 10 Ingredients Used in Livestock Feed

http://nigeriabusinesscommunities.com/features/top-10-ingredients-used-in-livestock-feed.html

This Best Practice Farm Biz Support Centre (FBSC)™ - tentative layout plan below - was first conceived in 2000 by Tayo Solagbade, to function as a creative Research/Extension Advisory Services provider.

Excel-VB Solutions, Farm Biz, My DN Travel News, The Farm CEO

Download the “PRACTICAL LIVESTOCK FEED FORMULATION HANDBOOK” – BY TAYO SOLAGBADE, Best Practice Farm Business Support Specialist

Leave a comment

My Feed Formulation Handbook was written and began selling offline in 2002 – and later via the web.

ffhb-doc-player

It remains my most popular product, followed closely by my Excel-VB Ration Formulator spreadsheet software, which I built in response to requests by buyers of the handbook who wanted an automated means of computing ration formulas.

When I wrote it, I noted that it would be a valuable reference for students of Agriculture, Livestock Farmers, Nutritionists & other stakeholders in the livestock farming industry.

Looking back over the past decade, I can confirm that the sales I’ve made have been to people from all those groups I anticipated would need it!

Here’s the abstract on the cover:

This Handbook reveals ALL The Secrets needed for ANYONE to become Proficient in Poultry (Even Livestock) Feed Formulation and Compounding!

It comes loaded with over 60 pages of: Detailed notes, worked examples, practical tips, and illuminating insights into the science of feed formulation using the Pearson Square computation technique.

In-depth exposition on critical considerations in selection and use of feedstuffs, plus tables of nutrients/energy values of local feedstuffs, anti-nutritional factors etc Essential features of Broiler starter/finisher, Chicks starter, Growers & Layers rations as well as Sample/Pre-formulated rations all of which have been fully used for production in real-life settings – And lots more!!

Get a FREE 27 page PDF download preview:

If you’d like to get a peek at the contents of the handbook, all you need do is subscribe to my newsletter mailing list, using the form located towards the bottom of this page, and follow the instructions that come to you via autoresponder.

Alternatively,just click here to contact me directly.

Excel-VB Solutions, My DN Travel News, My Ideas for Making Nigeria Better, Parenting, Recommended Websites & Articles, Self-Development

Equip Your Kids to Deal With Abuse of Any kind and Excel [Hint: TV Talk Show Relationship Expert Psychiatrist/Author Answers Question by Male Caller Claiming to be Abused by His Wife]

Leave a comment

If you have (or plan to have) kids that go on to have empowering and fulfilling relationships in their personal and work lives, I recommend you STOP and read this article. It’s based on text transcript excerpts I prepared from a TV Talk show on Domestic Violence, featuring a Psychotherapist specializing in domestic abuse.

[A word of caution before you begin reading or acting on what you read or watch in the rest of this piece: This is another in my Best Practice Parenting series. The information offered is to guide your efforts in parenting your kids.

However, only an adult who is competent in handling him/herself in relationships, can be reasonably expected to be able to empower his/her kids to do the same.

So, if you struggle with the abuse issues raised here (be you the abuser, or the abused), I recommend you follow the tips offered by the expert (and others) to help yourself, so you can be better enabled to help your kids.

As the saying goes, “You cannot give what you don’t have!“]. Now read on….!

The real life male caller to this show was somebody’s son – and he apparently had been suffering in a marital relationship, because he did NOT know what to do.

TV show on Domestic Violence, featuring a Psychiatrist specializing in domestic abuse

I do NOT want my child to ever have to wait to call in on a TV show, to get help to get free from abuse of any kind. What if no such show even exists where s/he lives?

In my adult life, I have both witnessed and experienced abuse – including vicious verbal, emotional as well as physical kinds. So I KNOW how damaging it can be. What has saved me from being ruined by my exposure to those potentially traumatizing experiences has been the powerful physical and mental stamina I developed and nurtured all through my adult life.

It is what has always protected me, and kept me from ever going under, till I freed myself from the abuser.

That’s why as a parent, I am DETERMINED to coach my kids to develop their own mental toughness as well.

They will learn to do so, with regard to making the right choices of friends, and partners to relate with, and how to MANAGE those relationships to experience the healthiest physical, and emotional existence possible.

You owe yourself and your kids a similar obligation – and this TV show’s message provides a useful starting point.

Text transcript of excerpts from the show

Janelle So [Kababayan@la18.tv, 8/10/2010 4:46:07 PM]: All your questions about domestic violence being addressed today, on the show, with Dr. Jill Marie – a psychotherapist. She’s written a lot of books about domestic violence and we’ll talk a little bit about that also today.

But for now, let’s go to the phone lines, because the phone lines are burning. So many people want to call.

It’s okay if you want to call anonymously, we’ll still get your phone call.

Ehm. we have an anonymous call – a male caller. Hello and welcome to the show!

Anonymous male caller: Yes, hello, ehm…I would like to speak to a doctor(indistinct)

Janelle So: Yes, go ahead

Anonymous male caller: Okay, my name is Kotey, and I am in relationship, and er, my wife, sometime(s) she tell(s) me very mean thing(s), and sometime(s) she beat(s) me and she tell(s) me mean thing(s) like I have big nose and she make fun of my english. And she says if I report her to the authorities that she (will) take away my children. So I, I, I (don’t) know what to do.

Janelle So: Thank you

Dr. Jill Marie (Psychotherapist/Author): Well I’m really glad he called because we really shouldn’t think that this is all males abusing females. Females can be very abusive to men. They can be abusive physically and they can be abusive emotionally. And Janelle, these threats that this gentleman just talked about, that his wife is making, are emotional and verbal abuse.

And so….

…The title of my 3rd book is “But He Never Hit Me”, and I want people to understand that it is not “just” emotional abuse, or “just” verbal abuse. Those are crippling, crippling, abuses. A lot of times people ask me, what’s worse? Emotional Abuse or Physical Abuse? As if one is okay, which they are not. If I had to choose, I would say…

Watch the video below to for the full responses and advice given by the psychotherapist guest on the show.

Do this for YOUR own sake, and especially for YOUR kids, and other loved ones who may benefit from getting the powerful insights provided by this expert.

It is my considered opinion that ALL adults MUST make the effort to equip themselves, as well as male and female kids they have, with the know-how to DEAL effectively with, and protect themselves against ANY form of abuse by others, be they members of the same or opposite sex.

I’m working on a new service to be offered via TayoSolagbade.com in which I will offer a monthly updated compilation of informative, and educative resources on “Protecting Yourself from and Succeeding In Spite of Domestic Abuse” from various sources that I will diligently research.

Click here to contact me if you wish to be notified when this new service goes LIVE.

Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, The Farm CEO

Two Learning Resources to Educate Farm CEOs and Other Stakeholders On the Need to Adopt an Entrepreneurial Mindset

Leave a comment

Over the years, I’ve built a large following within and outside Africa using my Cost-Saving Farm Business Support Solutions.

About a year ago, I began creating LEARNING solutions (real life and DVD based) for Farm CEOs and other stakeholders, to educate them on the need to adopt an entrepreneurial mindset to their businesses.

If you’re a decision maker for a farmers group or organization, the learning resources described below would benefit your members.

  1. Below is a link to a 1 hour talk I offer at NO CHARGE to attendees.

All they need do is get me down to the venue, and back etc.

http://tayosolagbade.com/sdnuggets/one-hour-talk-speaker-one-sheet-earn-extra-income-from-your-farm-at-zero-cost-5-little-known-strategies-you-can-use/

NB: I also have a special Sales & Marketing Coaching Program (DVD) Specifically Prepared for Farm CEOs

  1. Do you have a passion for improving data handling/analysis for research and report generation – especially with MS Excel?

If YES, you may also be interested in my newly launched MS Excel Visual Basic Club and Competition

Watch the video below:

Title: Spreadsheet Automation Can Boost Your Success [What MANY African Professionals Are Missing]

URL:  http://tayosolagbade.com/sdnuggets/video-3-of-9-ms-excel-heaven-visual-basic-competition-to-compete-you-must-be-a-member-of-sdacs-excel-vb-club/

(a). The club offers serious minded business users a platform to learn useful spreadsheet automation skills using MS Excel-Visual Basic.

(b). The competition provides such business users with a REAL WORLD relevant challenge that they can use to test their new skills, thereby building the confidence to deliver greater value to their employers or clients – leading to increased productivity and income.

I’m offering FREE membership to students whose learning institutions take up membership.

[I am also reaching out to sponsors to cover membership fees for them or to sponsor the competition – I have my own prize, but that’s just an extra (see details in the slideshow below)]

Click the link below to download the 9 page slideshow that offers FULL details:

http://www.tayosolagbade.com/uploads/xlhcluboffer.ppsx

Learn more about my MS Excel Heaven Solutions at http://www.excelheaven.biz or http://www.excelheaven.tayosolagbade.com

 

Go through the above, and let me know if you can put something together to benefit people at your end.

Like I said, I require NO PAYMENT. Just get me down…and back.

Career Development, Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, Self-Development, The Farm CEO

PII 054: Boost Your Success Achievement Using These 4 Services

Leave a comment

This week’s issue of my Performance Improvement Ideas (PII) newsletter is a special broadcast edition that announces four (4) key Performance Improvement Solutions I offer via www.tayosolagbade.com, www.thefarmceo.net, and www.excelheaven.biz.

My achievements and reputation speak for me. I keep promises I make to EVERY client. If you want reliable expert support to Boost Your Success Achievement, consider taking up these solutions I offer!

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade's Performance Improvement IDEAS(PI Squared) Newsletter

Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

Monday 20th February 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016. I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

************

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 054: Boost Your Success Achievement Using These 4 Services

This week’s issue of my Performance Improvement Ideas (PII) newsletter is a special broadcast edition that announces four (4) key Performance Improvement Solutions I offer via www.tayosolagbade.com, www.thefarmceo.net, and www.excelheaven.biz.

My achievements and reputation speak for me. I keep promises I make to EVERY client. If you want reliable expert support to Boost Your Success Achievement, consider taking up these solutions I offer!

1. PUBLISH YOUR BOOK AT ZERO COST

As an expert in your field, you would greatly boost your market place credibility by writing & publishing one or more book(s) sharing your knowledge and insights about your area of expertise. There is an internationally proven way to do this AT ZERO COST. I discovered how in 2005. Today, my books can be purchased in hard copy at www.lulu.com/sdaproducts .

(NB: I also offer a book writing service. Call 234-803-302-1263 or +229-66-122-136. Visit http://tayosolagbade.com/pod-letter.html)

“Infact, there is the greater likelihood of the success of export drive involving our cultural products and talents than one involving our outstandingly shoddy manufactures and primary produce nobody wants. The only problem is : our writers and artistes have to think like business (people). They have to learn to study the international marketplace and woo it with skill & subtlety” – Sina Odugbemi (SOURCE: Article titled “Why Writers Are Poor (part 2)”. Subtitle: “A critical look at the economic status of writers in the contemporary society” – published in Newswatch magazine, January 2, 1989 page 38

2. ORDER A WEB MARKETING SYSTEM

I help clients develop and implement custom web marketing systems to make their websites get found by potential clients without their having to spend ANY money. Click the link below to view a PDF flyer (wms_talk_offer.pdf) I use to introduce and explain key benefits a Web Marketing System can deliver to its owner – IF well conceived and implemented.

http://tayosolagbade.com/uploads/wms_talk_offer.pdf

“Unless the person running your marketing is patient, it will be difficult to practice commitment. View marketing as an investment, be consistent, and make prospects confident. Patience is a guerrila virtue.” – Jay Conrad Levinson in “The 15 Secrets of Guerrilla Marketing”

3. BUILT-IN EXCEL SOLUTIONS DEVELOPMENT

Self-Development Academy’s Excel Heaven™ is the FIRST provider of Preprogrammed and Custom Spreadsheet based solutions in Nigeria. We offer Workbook Auditing/Optimisation and VBA Automation; Custom Spreadsheet Software Development; Sales; Job-Based Spreadsheet Coaching; and Consulting/Advisory Services on effective application of spreadsheets for business use.Call 234-803-302-1263. See video demos at http://www.youtube.com/user/TKSolagbadeSDAc

Visit our Excel Heaven mini-site at : http://www.excelheaven.tayosolagbade.com or http://www.excelheaven,biz

4. COST-SAVING FARM BUSINESS (BEST PRACTICE) SUPPORT SERVICES

SDAc’s Cost-Saving Farm Business Ideas mini site offers custom best practice farm management systems (and software) development at affordable rates to farm business owners in Nigeria/Africa. This is a new, unconventional, but practical approach to provision of Modern Extension Services for farm businesses in this part of the world.

I work with crop and/or livestock farmers to develop and implement intelligent decision making systems that help their farm businesses become more efficient and profitable, through low cost adaptation of technology, while building on indigenous knowledge systems.

Visit the mini-site at : http://www.iff.tayosolagbade.com

Also subscribe to Weekly Newspaper – The Farm CEO™ at www.thefarmceo.net

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app – watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

PII 053: If Achievement of Authentic Non-Corner-Cutting Web Marketing Success Was Easy, Everyone Would Be Doing It! [Hint: What You Need to KNOW – and DO]

[Tuesday]:

Case Study – Crop Farmers Make 30% More Money Using Innovative Weather Predicting platform: Interview with Professor Oladimeji I. Oladele [Professor of Agricultural Extension]

[Wednesday]:

To Achieve Quality Success, Building Your Business Needs to be a Labour of Love [Hint: Special Valentine Celebration Offer of Two Cost-Saving Audio Podcasts for Farm CEOs]

[Thursday]:

Your Mental Attitude Can Help You Develop Street Wisdom Needed to Safely and Profitably Navigate Shark Infested Waters of Business

[Friday]:

N/A

[Saturday]:

N/A

[Sunday]:

Protected: The FARM CEO (Issue 74) : SMART SKILLS FOR SMALLHOLDER FARMERS, ORGANIC AFRICAN FARM, Buhle Farmers’ Academy

What You Need to Create a Splashscreen for Your Custom Spreadsheet Application [Part 1 of 2]

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners).

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region.

His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter.

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas
Entrepreneurship, Excel-VB Solutions, General, My DN Travel News, Self-Development

What You Need to Create a Splashscreen for Your Custom Spreadsheet Application [Part 1 of 2]

Leave a comment

This week’s tutorial features an anatomy of the Excel-VB code and Graphic User Interface Active-X controls you can use to create professional looking Splash Screens for your custom Excel-VB apps.

As you develop increased proficiency in building custom apps for various uses, especially if you dream of launching your own range of commercial quality spreadsheet software, knowing how to add a Splash Screen to your app would go a long way to help your better impress your buyers/users.

Splash Screens provide users an interface to notify the user that the app is loading. They typically contain “an image, a logo and the current version of the software.” – and are generally visually appealing.

As soon as I learned that I could use Excel-VB code and forms/controls in the Visual Basic Editor, to create Splash Screens, I knew I would be using them for my apps.

Below are screenshots with short notes/tips about how the Splash Screen for my Excel-VB driven Poultry Farm Manager was built.

1. Double-clicking the workbook application’s file launches this Enable-Disable Macros dialog box.

The user will click “Enable Macros” for the app to continue loading. Otherwise, the code in the app will be auto-disabled, and the app will remain in the small window shown

xlh-tut08-19thfebruary2017-sc7

2. This is the Splash Screen – It appears (called by a line of code in the Workbook_Open procedure for the Workbook) after the “Enable Macros” button is clicked.

As can be seen from the code in the VBA interface of the form used to build the Splash Screen, it is set to stay visible for about 5 seconds, after which it “disappears”…

xlh-tut08-19thfebruary2017

3. This is the login screen for the app – it is loaded AFTER the Splash Screen is “killed” or “unloaded from memory”

xlh-tut08-19thfebruary2017-sc0

4. This is the Excel-VB code used to call the Splash Screen – in the “Private Sub Workbook_Open subroutine

This is the code that runs when the workbook is loaded into MS Excel, after the “Enable Macros” button is clicked. Notice the 4th line of black text below the “On Error Resume Next” entry i.e the text “ShowSplash”.

That is the name of the Excel-VB code procedure containing the instructions for loading the Splash Screen that appears after the “Enable Macros” button is clicked.

xlh-tut08-19thfebruary2017-sc4

5. This is a dialog box showing how the “ShowSplash” macro procedure is located by typing its name, so it can be opened for modification by clicking the “Edit” button.

xlh-tut08-19thfebruary2017-sc5

6. This is the Splash Screen “design” view in the Visual Basic Editor interface – In the video for Part 2 of 2, that goes LIVE next week, I will show step-by-step how to build this on a blank form control.

xlh-tut08-19thfebruary2017-sc3

Creating a Splash Screen does not require elaborate coding – or design…

The Graphic User Interface created using the form control does NOT need to be as complex as the one I created for my app.

You can simply add a few descriptive labels, for your purposes.

I have used the screenshot images shown above, to explain the thinking behind the creation of this Splash Screen, to give you insights into how you can go about creating such for your apps.

Next week I will create a step-by-step video demonstration showing how I built this app’s Splashcreen

NB: If you’re not a member of my Excel Heaven Visual Basic Automation Club, click here to request a copy of the video.