All posts by Tayo Solagbade

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 organisations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems, freelance writing services, and best practice extension support services (for farm business owners). Tayo is the author of the Self-Development (SD) Bible™, the popular Livestock Feed Formulation Handbook, and developer of its accompanying Excel-VB driven Ration Formulator - as well as the increasingly popular Monthly Poultry Farm Manager app. On 1st April 2013, Tayo (who reads, writes and speaks the French language) relocated to Cotonou, in the French Speaking Benin Republic on the first lap of his slow travels 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). 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 previews of paid issues of The Farm CEO™ Newspaper (www.thefarmceo.net), in addition to his FREE Weekly Public Speaking/Web Marketing IDEAS newsletter - which he uses to promote Burt Dubin's Public Speaking Mentoring service to experts across the African continent. Visit Tayo's Flagship Performance Improvement website to download over 10 performance improvement resources to boost your personal and work related productivity. Join Tayo's international community of fans on his Flagship MS Excel Heaven Facebook page (click here). You can also connect with him via Twitter (@tksola).

[Recommeded] Japanese water-fueled-cars: the beginning of a new generation of green vehicles – The American Bazaar

The futuristic car can also use sea water.

Water, the elixir of life that makes you run, could also run your car pretty soon and just a liter of water, any kind of water, be it river, rain, sea water, or even Japanese tea as a Japanese clean energy technology company, Genepax, that had been working on the prototype of such a car has finally unveiled the car in the western city of Osaka.

Click the URL at the bottom of this email to read the full report…
====
#####

The above is the preview of a news report about the above mentioned car.

This weekend I’m taking a break from publishing both the Farm CEO newspaper and the Excel-VB newsletter.

I’m doing this in preparation for a BIG announcement I’ll be making in my Performance Improvement Ideas (PII) newsletter tomorrow.

The theme will be “Creativity and Innovation”

For now, I share the news report below about a new invention that was first announced 8 years ago, and which if mass produced commercially can (as an old schoolmate put it in Whatsapp) can one day, make crude oil “rot in the ground! And greedy pursuit of crude money will finally end naturally!”

But guess what?

Despite the massive multidimensional benefits to be had from use of this new invention, it’s taking so long to go LIVE.

That’s a sign that powerful forces reaping from sales of crude oil and its byproducts are probably not too happy.

Just the savings on carbon emissions and damage to the Ozone layer alone should be making nations fall over themselves to adopt it.

For instance, I personally see opportunity for Nigeria to benefit greatly if a version of that company’s Water Energy System (WES) technology is channeled into making power generators, in addition to existing water powered car engines.

If only our billionnaires and government would consider investing in that Japanese company with a clause that the factories be built in Nigeria!

Click below to read the story about this wonder car below:
http://www.americanbazaaronline.com/2016/06/16/413839/.

I’ve also linked a short video clip of the TV news report below:

Japanese Company Invents Water Fueled Car – YouTube

http://youtube.com/watch?v=tBm8ogwnpG0

Don’t forget to share the news!

[With Video URL] ‘Why I Hate School But Love Education’ Viral Video Points To Stupid In America And All The Wrong Questions | Huffington Post

Due to the fact that it perfectly captures the experience-based reservations I’ve expressed in my Best Practice Parenting articles over the years, I’ve been sharing the powerful video reviewed in this Huffington Post report for weeks via email and Whatsapp: Contact me if you want me to send it to you.

I’ve appended a preview ending with URL to the full article below.

It is instructive to note that the writer of the review picks holes in the argument made in the video (incl wrong spellings/facts).

That’s why I prefer to post the article’s URL below, along with the video’s URL: http://youtube.com/watch?v=y_ZmM7zPLyI

That way YOU can make up YOUR mind.

My advice: Be honest with yourself.
=

Why I Hate School But Love Education’ Viral Video Points To Stupid In America And All The Wrong Questions | Huffington Post

English rapper-poet Suli Breaks is out with a video that’s taking the Internet by storm, and young people are loving it.

“Why I Hate School But Love Education“ has received nearly half a million views since it was posted to YouTube on Sunday. The young, educated artist takes a strong stance on schooling, urging the world’s youth to “understand your motives and reassess your aims.”

Continue reading:

http://m.huffpost.com/us/entry/2246253

http://m.huffpost.com/us/entry/2246253

[FREE podcast] Create & Sell Zero Cost Products Using ONLY Your Smartphone Right from Your home!

Tough economic times often require us to reinvent ourselves to survive, and ultimately flourish.

 

This FREE podcast employs practical examples/true stories to describe a strategy for creating Zero Cost products (based on YOUR own unique knowledge and experiences) using ONLY your mobile phone, that you can sell to make money without leaving your home or office.

 

There’s a lot inside you that you take for granted – which others would gladly pay to hear you talk about, so they can help themselves.

 

Imagine having people send money to you, to access such products from you, which you create by speaking – and without writing a word?

 

No, don’t imagine it:

 

Listen to my FREE 30 minute podcast and learn how to get started making creating products you can sell REPEATEDLY to make extra money.

 

What I say in that presentation is based on use of this amazingly simple strategy, for years! to earn income even on weekends and public holidays.

 

So it’s based on “Street Wisdom” from application of my ideas in the real world, and NOT “Textbook Theory”.

 

I offer this audio FREE to any interested persons who send “YES” to me on Whatsapp via +229-66-122-136.

 

Once you do that, I’ll respond by sending you the FREE podcast.

 

If you need help getting started, send me a message via Whatsapp

 

<h3>Related Reading</h3>

 

1. <a href=”http://excelheaven.tayosolagbade.com/?p=334″ target=”blank”>What if you could print your own money – anytime you need it?</a>

 

2. <a href=”http://tayosolagbade.com/sdnuggets/spontaneous-coaching-program-monetize-your-expertise-to-make-extra-money-with-less-effort-by-creating-cash-flow-generating-assets-cfga/” target=”blank”>Spontaneous Coaching™ Program: Monetize Your Expertise to Make EXTRA Money With LESS Effort by Creating Cash Flow Generating Assets (CFGA)™ | SD Nuggets™</a>

 

3. <a href=”http://tayosolagbade.com/sdnuggets/how-to-publish-your-own-money-making-international-quality-physical-book-in-your-field-of-expertise-at-zero-cost-without-your-writing-a-single-word-download-free-pdf-report-or-attend-free-1-hou/” target=”blank”>How to Publish Your Own Money Making International Quality PHYSICAL Book in Your Field of Expertise: at Zero Cost & Without YOUR Writing a Single Word! [DOWNLOAD FREE PDF REPORT &/OR ATTEND FREE 1 HOUR TALK] | SD Nuggets™</a>

 

[Workshop for Kids – by a Kid] Build Your Own Battery Powered Toy Bike!

What is your child’s genius? Do you know?

Many parents do NOT know that schooling is a means to an end, and NOT an end in itself.

That’s why they focus so much on “schooling” their kids, and pay little or no attention to EDUCATING their kids in readiness for real world relevant success outside school.

This is why we have so many people who leave school with brilliant grades and go on to struggle to make impact in life.

It is why (as Robert Kiyosaki notes in his book) we see C students becoming more successful and employing A students after they all leave school.

It is also why we see UNSCHOOLED persons or school drop outs doing far better in the real world than their schooled counterparts.

I argue, as a Best Practice Parenting Advocate, that a parent’s NUMBER ONE role in giving his/her child an education is NOT to pay school fees, uniforms, textbooks etc. Neither is it to pay for access to summer school and exams.

Your primary role in your child’s education is the help him/her identify, and nurture to full bloom his/her God-given genius. This may or may NOT be along academic lines -and that is why YOU must avoid following the crowd of uninformed parents to give your child a one-sided education.

My audio podcast series titled “The Difference Between Schooling and Education” offers a LOT of real world relevant experience based insights designed to help you do your job well as a parent, so your child can thank you in future.

Like the cartoon of Einstein below shows, we are not all wired to learn or achieve in the same way!

einstein

The letter below, reportedly sent by the principal of an Indian school to parents of kids just before the exams, further underscores the point being made

ht-to-parents

And what is the point being made?

 

It is that HUMAN BEINGS have multiple intelligences and can therefore not go through life doing the same things the same way.

Each person will fare best if allowed and supported to make use of his/her unique gifts and abilities.

[EXAMPLE] I practice what I preach: Step-by-Step Demonstration Video by 12 year old

Click here to see it on Facebook. If you’d like it emailed to you, click here send me a message.

Imagine kids being able to build functional toys of this kind by themselves, instead of having their parents spend money to buy them?!

I am VERY close to each of my kids, and have spent hundreds of hours narrowing down to what they currently consider their natural passions, while controlling their exposure to conventional schooling in a way that ensures its potentially damaging effects on creativity are minimised.

[See Temi & Oluoma’s No-Oven Charcoal Stove Cookies]

Some months ago, I shared a video on my YouTube channel, of a battery-powered toy power bike built by my 12 year old son, using scrap materials he picked up from various places.

This video (click to view) is based on excerpts from a 4 part step-by-step demonstration video of my (now 13 year old) son building another of  his battery-powered toy bikes from beginning to the end, using scrap materials.

If you’d like the above step-by-step video emailed to you, click here send me a message.

I shared a video on my YouTube channel, of a battery-powered toy power bike built by my 12 year old son, using scrap materials he picked up from various places.

His 14 year old brother helped to hold the Blackberry camera, while playing background music – which we have now stripped out for copyright reasons.

I share photos along with this video clip.

img-20160210-00204

img-20160210-00192

img-20160210-00223

img-20160210-00211

img-20160210-00207

alagbado-20160210-00250

alagbado-20160211-00259

alagbado-20160211-00258

alagbado-20160207-00172

alagbado-20160211-00266

 

Our plan remains to organise a FREE workshop facilitated by my son during which he will teach other interested kids how to do what he does.

Imagine kids being able to build functional toys of this kind by themselves, instead of having their parents spend money to buy them?!

Related…

[Podcast] Real Reason Why Well Schooled People Commit Fraud (Tayo Solagbade’s “Difference Between Schooling & Education” Series)

[See Temi & Oluoma’s No-Oven Charcoal Stove Cookies]

PII 032: Maximise Returns by Integrating Rabbit Farming into Your Farm Operations [True Story: Excerpts from my response to a tweeted request from Eno, a Nigerian Rabbit farm owner]

Below: Screenshot of a tweeted request from Eno, a Nigerian Rabbit farm owner.

I’ve been passionately preaching the gospel of Commercial Rabbit Farming on this blog for years (see past articles below). This is because I believe its potential as a high quality protein supplying micro livestock (aka “Biological Refrigerator) is grossly underestimated.

It is for that reason that I always go out of my way to support any rabbit farming enthusiast or practitioner who reaches out to me (e.g Korku, the soft-spoken Accra based Rabbit Farm CEO client who purchased my Excel-VB Ration Formulator and Feed Formulation Handbook 2 months ago).
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 19th September 2016

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 032: Maximise Returns by Integrating Rabbit Farming into Your Farm Operations [True Story: Excerpts from my response to a tweeted request from Eno, a Nigerian Rabbit farm owner]

Below: Screenshot of a tweeted request from Eno, a Nigerian Rabbit farm owner

Screenshot of a tweeted request from Eno, a Nigerian Rabbit farm owner

I’ve been passionately preaching the gospel of Commercial Rabbit Farming on this blog for years (see past articles below). This is because I believe its potential as a high quality protein supplying micro livestock (aka “Biological Refrigerator) is grossly underestimated.

It is for that reason that I always go out of my way to support any rabbit farming enthusiast or practitioner who reaches out to me (e.g Korku, the soft-spoken Accra based Rabbit Farm CEO client who purchased my Excel-VB Ration Formulator and Feed Formulation Handbook 2 months ago).

Based on my personal experiences doing it in the past (which drives my vision to go into it via my proposed Farm Business Support Centre), I believe Rabbit Farming, properly done, offers low cost, multiple high income generating benefits, beyond sales of meat to include production of a wide variety of money making handicrafts from its many byproducts.

The tweeted request from Eno, a Nigerian Rabbit farm owner therefore excited me so much that I decided to feature it in this week’s issue of my Performance Improvement Ideas (PII) newsletter, with my response – which is in form of excerpts from notes I sent to a group of clients, earlier in the year.

I’ll end by saying that the versatility of the rabbit in terms of what it can eat and convert to flesh/meat, makes it an excellent animal to rear on ANY farm – or indeed in any backyard or homestead farm.

A little creative thinking and planning by most crop farmers can enable them integrate rabbit farming into their operations to maximise returns from their enterprises.

This can be done simply by developing systems to use relevant wastes to feed their rabbits for meat production purposes at a fraction of conventional costs.

If you need help making use of the ideas I’ve advocated here, click here to sent me a message.

Below: My response to Eno…

Thanks for your inquiry Eno.

I’m currently in Nigeria. But back in April 2016, I traveled from Cotonou to visit Songhai’s Porto Novo headquarters, on behalf of some members of my Farm Business Ideas Club, to make inquiries about pineapples, rabbits, grasscutters etc.

I notice you mentioned Ghana – and I am aware from speaking with my client, Korku, that they do have some good breeds there, though I do not have breed specific information. However, even he has spoken to me about the possibility of getting superior breeds from Benin Republic!

This is why I believe your best best would be to get what you need from Songhai – they are the ones I can vouch for in terms of the integrity of breeding stock you can purchase. I cannot however tell you what kinds of breeds they have in stock.

The Songhai officers I’ve met told me their rabbits are reared on another site located in a town called Savalou, but I have not been able to follow up the contacts and get the needed info.

TIP: It would help greatly if you can speak French in reaching out to, or visiting them. But they do also have officers proficient in English.

  1. Click here to visit the Songhai website | Click here to use the contact form
  2. Click here to contact them through their excitingly updated Facebook page (Don’t leave without LIKING it!!!)

Below are excerpts from an email broadcast I sent to my Farm CEO clients. It offers information I obtained directly from the officers I met

I shared this information below in my Cost-Saving Farm Business Ideas club’s group on Facebook (see https://www.facebook.com/groups/992652147472525/?ref=bookmarks) back in April 2016.

I’ve posted it on this blog, in responding to YOU, Eno, so as to afford other interested persons access to it via a link I can easily send out in future…I love to save my time :-)

Hope this helps – but do let me know if you need further assistance.

With kindest regards,

Tayo

PS: It goes without saying that the information below is NOT under my control, and the prices stated may have changed since the date(s) I obtained them. You will have to contact the gentleman I mentioned to establish the current status.

—–Original Message——
To: info at thefarmceo dot net
Cc: m
Subject: Re: Grasscutters, Rabbits, etc
Sent: Apr 21, 2016 9:36 PM

I finally got through to Monsieur Victor Boko at Songhai about the snails:

He said Songhai does not sell its snails – but offers training.

Will ask around for possible sources that sell snails of the kind needed for this business..

Tayo

——Original Message——
To: info at thefarmceo dot net
Cc: m
Subject: Re: Grasscutters, Rabbits, etc
Sent: Apr 20, 2016 2:14 PM

A note on current exchange rate: Last week I cashed N50k naira equivalent for approx FCFA 103k.

That means the Naira devaluation has resulted in a 2:1 ratio instead of the 3:1 ratio that existed (Naira : FCFA) before the crash.

So, you need to divide the FCFA prices given below by 2 instead of 3, to convert to the Naira equivalent.

1. Une famille de Aulacode [A family of Grasscutters] 4 females + 1 male – FCFA 90,000.0

2. Rabbits – FCFA 15,000 for one adult rabbit.

…deleted text…

I tried calling this morning to ask about snails, but he has not picked up.

He speaks French. Not sure if English is okay for him. But I’m told Porto Novo is Ajase, and many of them speak Yoruba. You may call him and try to communicate in English or Yoruba. I will keep trying here.

3. Caisse de transport (transport case)-

This is optional.

Price = FCFA 10,000.0

4. Certificat Sanitaire – this is needed to transport live animals across borders.

Price = FCFA 5,000.0

All the above info provided by the “Responsable du (I.e Head of) Production Songhai M. Victor BOKO.

His mobile: (reomved for privacy) – fill/submit this form to request it.

His email: (reomved for privacy) – fill/submit this form to request it.

Disclaimer

This is information passed to me by those mentioned. I have no means of verifying how realistic or accurate any of it is.

Listing them here does NOT constitute an endorsement of any of them.

You must therefore take the due diligence action of going further to check and verify etc.

Call me if you have questions or require clarification. I’m still moving around a lot and mat not find it easy to do emails.

For those of you who requested information about livestock like Rabbits etc, watch out for the next email.

In your service,

Tayo

Related Articles

  1. They Want to Learn English from Me & I Want to Improve my French! (PLUS Video of an angry Beninese Grasscutter, Photo of Rabbits, & a Photo of a 13 Year Old Burt Dubin Classified Ad!)
  2. THE FARM CEO (Issue 36): Rabbit Farm Business Startup As Alternative to Traditional Livestock Businesses, The Cost-Saving Farm Business Ideas Private/Closed Facebook Group Debuts, A Permanent Solution to Africa’s Low Per Capita Protein Consumption
  3. A Permanent Solution to Africa’s Low Per Capita Protein Consumption!
  4. Rabbit Farm Business Startup As Alternative to Traditional Livestock Businesses
  5. Layout Plan for TK Solagbade’s Proposed Best Practice Farm Biz Support Centre (FBSC)™ – Benin Republic

calavi

SDN Blog™

New posts from last week*

Monday:

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

[Podcast] Real Reason Why Well Schooled People Commit Fraud (Tayo Solagbade’s “Difference Between Schooling & Education” Series)

[Saturday]:

N/A

[Sunday]:

True Story Real Life (Phone SMS) Sales Conversation with a Farm CEO client

ExcelVB Case Study: Code to hide the row for a cell that contains a specific text string

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

ExcelVB Case Study: Code to hide the row for a cell that contains a specific text string

“Dear sir, Can you have a vb code in the condition that i want to hide (not to delete) the entire row if a particular cell has “katol”………. Please do it for me sir.

I created this Excel-VB coding tutorial in response to the above request from Pravin which he sent via my Facebook page on Sunday 18th Sept 2016 as a case study for members of my Excel Heaven Visual Basic Automation Club

[NB: By way of interest, I’ve had to respond to Pravin’s request once before in this same manner – click here. At the bottom of this post, I reproduce a detailed message I initially sent to him, explaining why I may find it difficult to respond to future requests of this nature from him – pointing out a useful forum he can visit to get reliable answers to his queries.]

Below: A screenshot of the MS Excel Worksheet I formatted the code driven interface to fit into [Click here to download the workbook with the code]

pravin-case-study

Steps to follow

In order to to have a cell’s row hide and unhide based  on the occurrence of a specific value,  it’s best to  write code for it in a Worksheet_Change event:

  1. Open a blank MS Excel workbook and click on the Worksheet Tab labeled Sheet1 to select it
  2. Next Press Alt+F11 to access the Visual Basic Editor
  3. In the Project Explorer Window, double click Sheet1 to open that Worksheet’s code window

TIP:  You can compress steps 2 and 3 into one by simply right clicking on the Sheet1 Worksheet tab after step 1 and clicking VIEW CODE on the shortcut menu that appears, to open the Worksheet’s code window

  1. Copy and paste the code below into the Worksheet’s code window

====Starts====

Private Sub Worksheet_Change(ByVal Target As Range)

    If Range(“CheckValue”).Value = “Katol” Then

        Range(“CheckValue”).EntireRow.Hidden = True

       

    ElseIf Range(“CheckValue”).Value <> “Katol” Then

        Range(“CheckValue”).EntireRow.Hidden = False

    End If

End Sub

====Ends====

  1. Recall from previous tutorials that I use range names to identify Excel objects I want to use code to refer to.

So, in the case of Pravin’s example, I’ve named the cell in which “Katol” appears, as “CheckValue” (the yellow coloured cell).

  1. Note the buttons to the top left of this frame – for posting the test string into the yellow cell and for erasing the cell’s contents. The code behind them is reproduced in the explanation boxes below them.

[Click here to download the workbook with the code]

Below: Detailed message I initially sent to Pravin this evening, explaining why I may find it difficult to respond to future requests of this nature from him.

I pointed him to a useful forum he can visit to get reliable answers to his queries. I reproduce it here in order to give the reader greater insight into how I do what I do, as it relates to coaching members of my Excel-VB club while working as a multi-discplinary expert.

Hi Pravin.

It would be my pleasure to send you the code to hide a cell or range. But like I told you before, I do a lot of things that require my serious attention. For instance right now, I’m modifying my Excel-VB Poultry Farm Manager for a new buyer who requested changes, and after that I need to prepare 2 newsletters and also write 4 articles for a UK client. I simply do not have the kind of time others do, to respond to requests of this nature.

In other words, I’m NOT your usual Excel expert who does only Excel based work. I am a multipreneur, engaged in various vocations, that take my time.

But I have a vision to build Excel-VB developers in my primary target market of Nigeria/Africa. I happen to think YOU have lots of experts in your country or region you can reach out to.

To do what I do out here, I feel if I am to add value to someone, it is best that I empower him/her to be able, even if over time, to find out how to do such stuff and others s/he may desire to do, by him or herself

It is for this reason that I prefer to challenge any persons who reach out to me to commit to EXPERIENTIAL LEARNING. I do NOT believe in TELLING people how to do things. Instead i believe in guiding them to discover how to write their own code.

So, responding to requests like yours tend to be difficult for me, especially since you are NOT in my coaching club. Unlike what obtains in YOUR country and other non-African nations, access to the Internet here is such that I simply cannot make myself available to respond to all requests. It not only costs a lot, but it also tends to be erratic in nature – plus I have a lot I’m doing.

Most importantly, and I have told you this before, there are people who run websites who invite visitors to send them such requests. A good example is http://www.mrexcel.com/forum/index.php – the forum at Mr Excel. There you can register and post ANY questions you have for experts to answer.

In my case, I am primarily focused on building Excel-VB skills in niche markets in MY country, and my strategy does NOT require that I make myself available to respond to all comers, much as I would like to.

Instead, I have to focus on serving people within my network, based on their specific needs as business users. That is why my Excel-VB club is my priority.

I will therefore end by telling you what I have told you before:

I will make out time to create a tutorial based on what you specified above for you, which I will use to teach my club members, featuring YOU in my broadcast to them.

However, AFTER I do this, let me make it clear that I will NOT be able to take on ANY requests you make in future – except you choose to join my Excel-VB Club.

I hope my offer is acceptable to you. If not, I advise that you visit http://www.mrexcel.com/forum/index.php and post your question there.

Maybe in future I’ll be able to re-invent the way I work, to take on all comers. For now, this is the best I can do.

With kindest regards,

Tayo

Related Article

Download MS Excel-VB Screen shot Demonstration Video Tutorials for Tayo Solagbade’s Introduction to Excel-VB Automation Workshop Held on Sat 19th March 2016 in Lagos-Nigeria [Includes video recorded in response to last week’s request for Excel-VB coding help from a business user in India]

True Story Real Life (Phone SMS) Sales Conversation with a Farm CEO client

I’ve written several articles in the past about the powerful sales boosting advantage of building a client and prospects/potential buyers contacts database/mailing list. You can over time grow and nurture, then ultimately MINE it for “gold” i.e form or money from sales you make to buyers on it!

This is what I do, and I do it at low to zero cost because I make smart use of PC and Internet Technology, while selling mainly digital products and services delivered by the web.

The true story you are about to read, illustrates one of many ways in which I do what I do, to make money even on public holidays or weekends – sometimes while lying down or playing with my kids :-)

The ideas I offer here can be successfully adapted for use by any interested persons, using a little creativity regardless of your field of interest or specialization.

SMS Conversation Starts…

Me: Tomorrow’s Sunday…and I’m in the spirit :)

Get a FREE copy of my Excel-VB Church Records Manager (N50k value). See your email! [NB: Offer Expires @ Noon]

Client: Did you say freeeeeeeeee?

Me: Go read your email first – 12 noon no far O. Ahem: “The Spirit of the Lord is upon me..” Take action while it lasts O loool!

Client: Lol! Óyá! Take am sharply sharply. His-emall-address@gmail.com

NB: I found it intriguing that he actually thought he needed to supply me his email address, since I had always had it from the very first time he called months ago. Indeed I have email and phone lists for clients and prospects that I regularly send offers to!

So I sent him this teasing reply:

Me: See you dis man. Me I don send you email since b4 I send my SMS lool

Client: You are blessed by the Most High.

Me: Pastor (name-removed) lool!

By way of interest, here’s the email offer I sent him, in which I wrapped a FULL PRICED offer of my new audio podcast product (on Biafran Alternative Feed Formulation Ideas) around the FREE gift of my Church Records Manager app built 9 years ago:

*********************Email Starts******************
Get a FREE personalised copy of my Excel-VB driven Church Records Manager (N50k value)

Tomorrow’s Sunday…and I’m in the spirit :-)

Get a FREE personalised copy of my Excel-VB driven Church Records Manager (N50k value) when you buy my new Audio Podcast titled “Amazing Story: How Biafran Scientists Innovated Low Cost Animal Feed (During the Civil War) Using Zero Cost Local Ingredients”. See http://tinyurl.com/biafratest |

Price = N2.5k

Pay to bank or like some buyers do, send airtime to a mobile number I send to you.

Reply YES to claim it.

NB: Offer expires 12 noon today, 17th Sept 2016.

Enjoy your weekend!

Tayo K. Solagbade www.tayosolagbade.com

*********************Ends******************

Profiling your clients will make it easy for you to up-sell to them later on, and make more money!

When a prospect contacts me online about products or services I offer, I ALWAYS ask him/her to CALL me on my mobile number, so I can ask 3 important questions that will guide me in:

A. Establishing that s/he is a serious inquirer

B. Responding later via email to his/her inquiry.

Anyone that refuses to call gets ignored. All my international buyers from across Africa, Canada, UK, UAE etc went through this process before they could buy from me, and I’ve found that it inspires mutual trust and respect.

So I knew from profiling the above mentioned client 5 months ago, when he called about and eventually bought my$375 USD priced Excel-VB Poultry Farm Manager app, that he worked as a Church “leader” in his spare time.

He was not the only one. I knew others on my mailing list, and had broadcast the offer to all of them.

But he had responded first and that was not surprising since he’d recently contacted me via Whatsapp after reading my article about the app.

Here’s what he said back then on Whatsap

Client: Hello Tayo!
Happy new year. ☺
…been quite busy with work.
I saw your mail w.r.t. Excel-VB driven Church Records Manager. I love its simplicity!

Well done [Sep 1 @ 10.41a.m]

Me: Thanks. That app was built > 8 years ago loool!

Client: …the video and download links aren’t active. Any clue?

NB: I respond by send an audio message saying the app is FREE for any persons who pay to join my Excel-VB club.

I add that there is no video and only the screenshots he’d seen were available.

I then type the following closing message:

Me: By the way, if you’re not interested in joining the XLVB club, you can still get the app via your membership of my Farm Biz Ideas club which gives you 40% lifetime discount on ALL products/services I offer. That means you instead of N50k, you get to pay N30k. As a gesture of goodwill, I’ll offer you N15k if you pay on or before 5p.m today. Call it my Solar Eclipse promo loool

I got no response from him and so moved on. But I make a mental note to “work” that angle by thinking up a new offer

That new offer is the one he’s responded to today – hopefully, he’ll not balk at buying the N2.5k audio podcast product, to get the FREE N50k app…lol!

Whatever happens, I’m sure you get the idea.

THIS is an example of how I sell – and I learned to think about making money this way 24/7 by studying ideas advocated by geniuses like Robert Kiyosaki.

The most important lesson I learned from is how to print my own money by creating Cashflow Generating Assets – in my case, with a focus on digital delivery platforms.

Several of my past articles on this blog (like this one) offer ideas you can use to do that.

I create and sell information products in book form, as videos, or in audio form directly downloadable or delivered offline via courier on my branded DVDs etc.

With regard to custom Excel-VB solutions, I have a growing range of popular apps bought by business – especially farm operations.

But I also have many more apps I built for all sorts of clients from my decade long pavement pounding past that are just lying idle on my disks.

This is because I’ve narrowed my focus to serve what I’ve identified to be my most lucrative niche market.

But rather let them go to waste, I constantly review potential opportunities to sell such otherwise obsolete apps, or to bundle them with other in demand products/services as deal-sweeteners.

I share this story to illustrate the power of building relationships to facilitate selling to total strangers, regardless of geographical distance.

It is only when you profile a potential buyer that you will more accurately understand their felt needs, interests and preferences.

This is what I’ve done for years, selling to buyers in and out of Africa in a manner that’s helped me build valuable high quality lasting friendships with clients I’ve yet to meet in the flesh.

It goes without saying, as can be seen from the conversations shown above, that selling this way can be a lot of fun. You should be able to enjoy yourself in doing a business you love and making money in the process.

Adopting the ideas I’ve share here can help you do just that.

Send me a message if you need help.

Related Articles

  1. The Best Way to Make Money (True Story)
  2. How You Can Create Income Generating Assets Without Having a Job or ANY Money! (True Story)
  3. Spontaneous Coaching™ Program: Monetize Your Expertise to Make EXTRA Money With LESS Effort by Creating Cash Flow Generating Assets (CFGA)™

[Podcast] Real Reason Why Well Schooled People Commit Fraud (Tayo Solagbade’s “Difference Between Schooling & Education” Series)

Why do people who have acquired decent levels of formal schooling, up to tertiary level (and even beyond) keep getting caught engaging in fraudulent acts in their personal/work lives?

What makes such otherwise intelligent people stoop so low as to engage, for instance, in (what Fela once called) “pen robbery”, tax evasion, taking/giving bribes and other forms of financial misconduct?

You could say GREED, but that would only be scratching the surface. It goes MUCH deeper than that!

This audio explains the root cause of this strange self-destructive behaviour exhibited by people who by their exposure to formal schooling would have been expected to know better.

If you have ever wondered why all those gurus in the banking industry indulged themselves in abuse of their positions to access customers’ funds for personal enrichment, then you want to listen to this charged half-hour presentation.

Disclaimer: Tayo Solagbade’s “Difference Between Schooling & Education” is a no-holds barred audio podcast series.

In each audio recording, I mince no words in speaking what I consider truths to make my points.

If you know you’re sensitive to hearing a person speak harsh truths with brutal frankness, on issues you feel strongly about, then do NOT request that I send you this FREE sample audio.

I’ll however say this:

Any person who listens to these recordings will come away with life transforming real world relevant insights that s/he can apply to advance financially in life – and also teach his/her kids.

Do you want that?

If YES, you’ll love THIS maiden podcast in my educational series titled “Real Reason Why Well Schooled People Commit Fraud“!

Format: AMR Audio = 2.2MB [MP3 = 6MB]

Duration: 0.5 hrs

Price: FREE [Let me know if you want MP3 or via Whatsapp]

To get it, send your full name, marital status, email and phone number to me via +229-66-122-136 on Whatsapp – and I’ll send you the 30 minute audio in return.

Alternatively, simply signup for the “Difference Between Schooling & Education” series (and others to come) by requesting access to Tayo’s School of Mental Emancipation and Personal Achievement on Facebook.

To Succeed, You Need to be a Problem Solver [True Story: Real Life Problem Solving Email Conversation With New Buyer of my Excel-VB Ration Formulator App]

Finding buyers for your products/services can be hard, but what is even harder is GETTING and KEEPING those buyers satisfied, so they do NOT feel what is called “buyer’s remorse” and demand their money back, or refuse to give you repeat business.

Having said the above, let’s be clear about one thing though:

You CANNOT please all your clients. There will be those with whom you simply will not be a good fit – and it will be NO FAULT OF YOURS. When that happens, you must be ready to let such people go. NEVER make the mistake of assuming you have to keep all clients at all costs.

In other words, client attrition is a necessary evil (I call it a blessing) that ALL of us will have to deal with every now and then.

What is crucial however is that you ensure that you keep it as low as possible, and ensure it does NOT happen with those you know are your ideal clients i.e people who fit your target audience profile.

In my case, I learned YEARS ago that NOT all buyers deserve to be my clients, so I’ve developed a screening system to identify and keep such people out of my network of potential buyers as much as possible.

With that system in place, I then go all out to use my marketing arsenal to rope in those who remain, and ultimately sell to some of them.

However, once a sale happens, I DO NOT go to sleep!

Instead, I stay alert for ANY issues that may be raised by the new buyer – even as I keep close contact (via periodic email, Whatsapp and phonecall “Hellos”) with even older clients.

If s/he (or any of the others) raises ANY issue with the solution provided, I instantly click into my accelerated Support Service Provision mode.

During this phase, I draw on all my knowledge and experience, as well as information from past client interactions, to help the client get the desired outcome in using the solution delivered to him/her.

I’m proud to say that 95% of the time time, I have succeeded in addressing raised issues, earning myself the client’s subsequent appreciation

In many cases, that ended up opening the way for more up-selling opportunities in the future, and at some point a real lasting friendship with him/her.

The screenshots and email transcripts reproduced below, illustrate a real life example in which I employed the strategy described in this article, very recently, to solve a problem for a “newly minted” buyer of my Excel-VB Ration Formulator app.

========

BELOW: His email informing me of the difficulty he was having, getting the app to run normally…

=========

Sep 15 (2 days ago)

Good morning
I was so busy during the Salah break that I was unable to down and run the RF app. However I was able to download the RF-Exports.xls , data-appended.xls and the zipped folder that contains the picture guides. And also the 4 YouTube videos. It seems these 2 excel files are not the main app for the ration Formulator because I could not find the login screen in order to use the password you provided in your email. Thanks

Sent from my iPad

am-64bit-shot0-start

==================

BELOW: I send him a reply, after speaking on phone with him – adding URLs to a video on how to enable macros etc….

=================

The video shows how. The 2 articles offer additional information and education

1. Start-Up – Excel-VB Ration Formulator.avi – YouTube | 23 Nov 2011 | Tayo Solagbade shows how to enable macros (in Excel 2007) to run his Excel-
VB …

http://youtube.com/watch?v=z8B1yX8e-GY

2. [Tutorial 01 – ExcelVB Coding Tips & Tricks for Accountants: How to Enable Macros in different versions of MS Excel I.e 2003, 2007, 2010 and 2013! | SD Nuggets™

http://tayosolagbade.com/sdnuggets/tutorial-01-excelvb-coding-tips-tricks-for-accountants-how-to-enable-macros-in-different-versions-of-ms-excel-i-e-2003-2007-2010-and-2013/

 

3. Protect Yourself from Macro Viruses [Potential Dangers of Enabling Macros in Excel-VB Workbooks From Unfamiliar Sources] | TayoSolagbade.com

http://excelheaven.tayosolagbade.com/?p=604

I will call you.

Tayo
Sent from my BlackBerry wireless device from MTNam-64bit-shot0
=====

BELOW: The above turns out to have been correctly done by him and NOT the issue he was having. So I send him ANOTHER reply, after speaking on phone with him – this time I add 2 PDF files, with explanatory notes about how their contents may help solve what I suspected to be the likely issue he was having

=====

Tayo Solagbade <tayosolagbade@gmail.com>

AttachmentsSep 16 (1 day ago)

to aliyu, Tayo
Hi Aliyu,

See attached file named Aliyu-PFM-Login-Screenshots.pdf

My conversation with you indicates you’ve most likely got this covered…but I still include it because of the details I added regarding the Mac OS

Excerpt: If you’re having this experience while trying to run it on your Mac then it’s understandable/expected. Like I told you, my apps are built using Windows based MS Excel version which uses VBA code syntax that’s not fully compatible with that in the Mac OS version of MS Excel.

My advice is that you run the app on a PC that runs Windows for best results.

However, below are 2 articles I’ve written to offer information, education and basic support for Mac users who have bought from me:

1. http://tayosolagbade.com/sdnuggets/you-need-this-zero-cost-app-for-trouble-free-use-of-excel-vb-windows-based-apps-in-excel-for-mac/

2. http://tayosolagbade.com/sdnuggets/useful-question-answer-email-conversation-with-a-new-farm-ceo-user-of-my-excel-vb-driven-poultry-farm-manager-pfm-software/

====

NOW, here’s another possibility to consider:

I just recalled that a past client (by name “Ekene”) experienced a problem (for another of my software – The Poultry Farm Manager) which was due to a compatibility conflict between my app (which was developed for 32 bit MS Office) and 64bit MS Office installation on his system.

I’m not sure if this might be the case with you. The attached PDF explains how to check which of the 32 or 64 bit MS Office versions you have on your PC.

However, as long as what you have on your PC is a licensed version of MS Office, the instructions in the attached PDF will easily resolve the conflict for you.

Otherwise, you may need to reinstall MS office and choose to install the 32 bit version this time around.

Full details of how you may have ended up having the 64 bit version installed for you is given in the attached PDF – based on information I compiled from the Microsoft forums.

I’ll call you once I send this email off to you.

Cheers,

Tayo
PS: Note that the PDF was prepared based on error reports sent me by Ekene, which differ from yours. I’m however not sure if they may be due to the same root cause. So I recommend you read all 3 pages carefully, then follow the -prescribed steps from pages 2 to 3.

am-64bit-shot1

=======================

BELOW: He replies to confirm my suspicion that the second possibility (regarding 64bit MS Office) turned out to be the cause of the problem he was having

=======================

 

11:42 PM (15 hours ago)

to me
Good evening I just got back home and finish reading your mail. Both the pc and the Mac are running 64 Bit operating system. I think that is the cause of the issue am having. Thanks a lot

Sent from my iPad

am-64bit-shot2

Final Words

I share the above true story to give the reader a real world relevant example of how to use the ideas I advocate – and to provide proof that I practise what I preach – so s/he can feel inspired to do the same.

[Recommended] Download The Secret to Winning at Life & Investing [Why I’m Giving You a No Cost 10 Minute eBook] – by Robert Kiyosaki

The reason I started Rich Dad was to be an educator. To develop a way for people like you to learn about finances since it wasn’t being taught in school.

When I was young, my poor dad wanted me to go to a good college and get a good job. To him, that was the path to security. To him, that was being rich. What I actually learned was that his advice would prepare me to be an employee. I had to learn how money worked so I didn’t have to spend the rest of my life working for it.

This brings me back to why I started Rich Dad, because being able to give you something that I know will play a major role in helping you reach independence is what brings me the greatest joy.

Today, I get to do just that!

Now…there’s something for you to do too.

We all have friends and family members in our lives who are struggling to reach their goals in their life because their mindset has been programmed to think like the poor or middle class.

Please share this eBook with them. It’s no cost and takes 10 minutes to read, but could change their life. Success is meant to be shared, pass it along.

Share with a Friend or Family member now >>

http://www.richdad.com/promotions/2016-The-Secret-to-Winning-at-Life-and-Investing.aspx.