Category Archives: Career Development

NEW FRAUD. PLS BEWARE!! [Phony Kidnappers Playing Mind Games Over The Phone to Get Money]

Last week I heard the audio of a truly audacious 419 fraudster trying to impersonate an online banking support officer over the phone (click link below to listen).

419 over the phone. What an embarrassment to Nigeria! – YouTube

Since then I’ve become convinced that anything is possible in today’s Nigeria.

That’s why I share this on my blog – better safe than sorry as they say.

NEW FRAUD. PLS BEWARE!!

Given below is what happened to someone & he has narrated this in his own words:

” I received a call from someone claiming that he was from my mobile Service provider and he asked me to shutdown my phone for 2 hours for 3G update to take place. As I was rushing for a meeting,I did not question, but just shut down my cell phone. After 45 minutes I felt very suspicious since the caller did not even introduce his name.

I quickly turned on my cell phone and saw several missed calls from my family members and the others were from the number that had called me earlier –I called my parents and I was shocked that they sounded very worried asking me whether I am safe.

My parents told me that they had received a call from someone claiming that they had me with them and asking for money to let me free. The call was so real and my parents even heard ‘my voice’ crying out loud asking for help.

My father was at the bank waiting for next call to proceed for money transfer. I told my parents that I am safe and asked them to lodge a police report .Right after that I received another call from the guy asking me to shutdown my cell phone for another 1 hour which I refused to do and hung up.

They kept calling my cell phone until the battery had run down. I myself lodged a police report and I was informed by the officer that there were many such scams reported. MOST of the cases reported that the victim had already transferred the money! And it is impossible to get back the money.

Be careful as this kind of scam might happen to any of us!!!Those guys are so professional and very convincing during calls. If you are asked to shut down your cell phone for updates by the service provider, ASK AROUND!

Your family or friends might receive the same call. “Be Safe and Stay Alert!Please pass around to your family and friends !!!v
DONT JUST READ, SHARE WITH OTHERS
1 min ·
Pri
Source: Click here.

[Power Point Slideshow Explanation & Exercise Tip] How to Open a Website from MS Excel using ExcelVB code

<I>[NB: This tutorial note was sent to members of my Excel Heaven Visual Basic Automation Club earlier today]</i>

As promised, this week I send you an explanation of the Excel-VB code in last week’s example workbook, on “How to Open a Website from MS Excel using ExcelVB code”.

On the last slide, I appended the following exercise tip to give you some practice:

EXERCISE: Try opening a blank MS Excel Workbook and creating a replica of the worksheet containing the range named “Site2Visit” and then typing the above ExcelVB subroutine in the VBE.

See your email inbox for the PowerPoint Slideshow containing the explanation.

xlexample1

xlexample2

Act On Your Instincts/Intuition to Achieve Success [True Story: How I Won a Paid Speaking Invitation At First Contact, With No Prior Planning, and at Zero Cost]

 

As the true story I share in this article illustrates, sometimes you need to follow your instincts/intuition, and take action to get what you want, without procrastinating, if you want to achieve important breakthroughs in life.

 

Napoleon Hill and W. Clement Stone in the classic Self-Help book titled “Success Through A Positive Mental Attitude” repeatedly emphasized to the reader, the importance of applying what they called the “Self-Starter”: DO IT NOW!

 

<h3>Here’s a quote from their book, that explains:</h3>

 

<blockquote>”…Now what is the secret of getting things done and what is the self-starter that forces you to use this great secret? The secret of getting things done is to act. The self-starter is the self-motivator: DO IT NOW!

 

As long as you live, never say to yourself, “DO IT NOW!” Unless you follow through with desirable action.

 

…Many persons have the habit of procrastination. Because of it, they may miss a train, be late for work, or even more important – miss an opportunity that could change the whole course of their lives for the better. History has recorded how battles have been lost because someone put off taking desirable action.

 

…Memorize the self-starter DO IT NOW!

 

DO IT NOW! can affect every phase of your life. It can help you do the thing you should do, but don’t feel like doing. It can keep you from procrastinating when an unpleasant duty faces you.” </blockquote>

 

<h3>True Story: How I Won a Paid Speaking Invitation At First Contact, With No Prior Planning, and at Zero Cost</h3>

 

One morning in 2012, before I relocated to Benin Republic, I was driving past the premises of a popular higher institution in Lagos, when – acting on impulse – as the thought flashed through my mind, I turned into the compound and drove down to the Centre for Entrepreneurship Development on campus.

 

I’d once read about the centre on the institution’s website and often wondered about opportunities for collaboration to be had there.

 

With no specific plan of what I wanted to say in mind, and carrying no promotional materials – not even business/call cards (which I stopped using in 2004) – I walked into the office of the centre’s director, having been shown the way by students I met outside the building, on the campus grounds.

 

<h3>I told the secretary in the front office my name and added that I had a suggestion that would help the director add more tangible real-world relevant value to content served students being taught entrepreneurship there.</h3>

 

What I said, the serious tone with which I said it, and the confident manner I carried myself, looking directly into her eyes, undoubtedly made an impression.

 

I say this because she promptly asked me to wait, then went in to announce my presence to the director, returning to usher me in within minutes.

 

I walked in while quickly thinking of possible topics to present as a basis for discussion that would capture the director’s interest. By the time we’d exchanged pleasantries, I still had not settled on anything specific.

 

So, once again, I followed my intuition.

 

I told her that I believed the unique socioeconomic environment in which entrepreneurs have to function in Nigeria is one that nothing in our classrooms can adequately prepare us for.

 

She nodded in agreement to that, and continued doing so as I gave personal examples of how I’d learnt that truth the hard way after I quit paid employment to venture into entrepreneurship as a Nigerian living in Nigeria.

 

<h3>I then made my pitch by saying her centre’s learners needed someone who had been through it, to share with them useful tips and insights towards minimizing trial and error to reach their respective goals</h3>

 

This, I added, was important in light of the need for them to make the most of limited time and resources they have access to – otherwise many would likely be discouraged and even quit due to the hardships lack of such know-how would visit upon them!

 

<b>Long story short, she responded by saying I’d come in at a time when she was musing over how to identify and invite a guest speaker for the annual entrepreneurial lecture due to take place in a month’s time.</b>

 

She asked for my business card and I told her I used none.

 

“Then what do you use?” she asked in surprise.

 

I replied that it was just my website, and that it had all the information she would need about me and what I offerred..

 

She promptly handed me a piece of paper on which I wrote the website address and gave to her.

 

She then gave me her complimentary card, promising that she would review the website and if satisfied, would recommend to the board that I be invited as guest speaker for the event.

 

<h3>Less than 2 weeks later, after I’d sent in the draft talk outline in response to her emailed request, I got an email from her, bearing a scanned version of the formal invitation on letterheaded paper advising that the board had approved my selection as guest speaker.</h3>

 

In the 2 weeks that followed, I gave the talk to an audience in a packed auditorium with students/top officers of the institution present and the print/TV/Radio media covering the event.

 

Everything went well, and I even got interviewed after the event. The icing on the cake was that I got paid – even though my offer had been to give a FREE talk!

 

Looking back, there is no doubt in my mind that applying the “DO IT NOW!” self-starter was the key to my achievement of that breakthrough.

 

Having said that however, it is instructive to note that if I had not had an Effective Online Presence (EOP) that did what it was meant to do (which was to get visitors convinced that I’m the person they need) that self-starter would not have worked for me.

 

In case you wonder what I had that produced such an effect, I call it a Web Marketing System (WMS) – <a href=”http://tayosolagbade.com/smclub-nonfarm.html” target=”blank”>click here to learn more about it</a>

[Featured Article] Getting Started with VBA in Excel 2010 – from msdn.microsoft.com

[NB: The promised diagrammatic explanation (from last week’s tutorial) of the ExcelVB code for launching a URL in a browser will be sent to you during the week]

 

This week I feature an article published by Microsoft to introduce ExcelVB. Note that even though the title specifies Excel 2010, most of what is discussed applies to Excel 2007 upwards.

 

I encourage you to read it from start to end and print it out if you can – because it provides a useful foundation of understanding on which you can build your ExcelVB expertise over time.

 

<h3>Getting Started with VBA in Excel 2010 | Office 2010</h3>

 

Summary:

 

Introduces Visual Basic for Applications (VBA) in Excel 2010 to the Excel power user who is not yet a programmer.

 

This article includes an overview of the VBA language, instructions on how to access VBA in Excel 2010, a detailed explanation of a solution to a real-world Excel VBA programming problem, and tips on programming and debugging. (14 printed pages)

 

Last modified: December 11, 2009

 

Ben Chinowsky, SDK Bridge

 

In this article:

 

1. Why Use VBA in Excel 2010?

 

2. VBA Programming 101

 

3. Macros and the Visual Basic Editor

 

4. A Real-World Example

 

5. Modifying the Recorded Code

 

6. More Things that You Can Do with VBA

 

7. What’s Next?

 

<a href=”https://msdn.microsoft.com/en-us/library/office/ee814737(v=office.14).aspx” target=”blank”>Continue reading</a>

 

Those Who Make False Claims About Their Abilities Frequently Reap Failure in Return [Do Your Achievements Confirm What YOU Claim You Can Do?]

Many adults know the “joke” about parents (especially fathers) who tell their kids that they (the parent) always came first in class (even when they did not) during their schooling days. They then use that “claim” to demand that their kids deliver similar performances.

The irony is however often that the achievements of most of such parents in real-life, post-school, tend not to justify the claims they make, and some of their kids, who are perceptive enough, readily notice that.

Some people seem to feel a need to impress others by making false claims about their abilities and/or past accomplishments. The point I am making is that adults, often taking a cue from prevailing societal preferences and values, sometimes feel pressured to present themselves in a manner that will win them approval from a larger audience.

That is not bad in itself, IF the person then takes steps to ACQUIRE the knowledge/competencies that will confer on him/her the ABILITY to achieve at the level of proficiency s/he wishes to be acknowledged for.

The problem however is that some of these people are NOT prepared to work that hard to get such results. They prefer instead to take shortcuts that win them the rewards they seek without the PAINS.

So they LIE.

That’s when a job applicant states military experience in his resume dating back to before he was born! Or an interviewee presents samples of past completed works, which turn out – by a twist of fate – to have actually been those done by his INTERVIEWER!!

It would interest you to know that the examples I just gave are REAL and were obtained from the published results of a recent survey conducted in the US titled “Who lies more on resumes?”. Visit the link below to read the full report.

http://blogs.techrepublic.com.com/career/?p=381&tag=nl.e101.

People who get ahead by using these dishonest methods are often quite adept at generating excuses for the subsequent poor performance they inevitably deliver. It’s either they were not told on time, that the task or assignment was urgent/time bound. Or a power glitch damaged their PC/flash drive just at the moment they wanted to email the finished work or print it out. :-)

Also, these people will usually be the first to kick against attempts to define roles/responsibilities clearly for proper accountability in their teams. This is because they know their survival depends on ensuring they stay hidden from scrutiny, while they ride on the efforts of other members.

No one is (and no one can be) perfect, but in order to continually function at our best, it is good to strive perpetually towards perfection. I suggest ways to avoid falling into the trap of feeling the need to claim you CAN when you KNOW you do not have the competence to DO SO.

1. Learn to speak TRUTH. A lie is a lie. When you prevaricate, it is still a lie! Learn to say exactly what you can do, and DON’T put any icing on it. If you can build simple spreadsheets with formulas, don’t claim you can also use VBA code, with Windows API calls to create top end custom Excel-VB driven spreadsheet software like those you saw on a website last month! You never know who will remember what you said, and come calling some time in the future to ask you to do something THAT advanced for them.

2. Know What You Want. When you acquire skills and knowledge related to what you WANT to do, you will usually need no push or prodding from others to keep doing so on a consistent basis. By implication, you will easily stay on the cutting edge of latest developments in your field. Telling others you can do something in relation to that area, will therefore not pose any risk to you or your integrity.

3. Believe In Yourself. You must develop your self-esteem to the point that you KNOW, and are thoroughly convinced that it is not what others say (or how they feel about you, or act towards you), that determines if you are good or not good at what you do. Learn to feel good about yourself regardless of what happens outside of you.

This is something that is very hard for a lot of people to do. Yet, working hard at it will actually end up making you come across as self-confident, assertive and at ease with yourself. The foregoing are all qualities that most people are attracted to – meaning you still end up winning not just the approval of others, but also their respect and admiration. In essence, you would have achieved the same end result, BUT without having to use dishonest methods.

In life, the people who end up succeeding with integrity, are those who are true to themselves EVERY day. Make a point of ALWAYS ensuring that you say ONLY what you can do, and DO what you say you will do. Doing so will earn you a reputation that will make others believe in, and respect you EVERYWHERE you go.

NB: This article was first published online on in on http://EzineArticles.com

PII 019: Success is NOT Hereditary – and There is NO Gene Associated With Poverty [Hint: That’s Why This Former Street Hawker Turned International Business Coach Is Launching an Academy to Help Others Succeed!]

“Empty pockets never held anyone back. Only empty heads and empty hearts can do that.” – Norman Vincent Peale (NVP)

Life is not a bed of roses. Good fortune does not just fall into people’s laps.

As many who have succeeded authentically in this world will tell you, it takes work, often a lot of hard work, to make it in life.

It does not matter how talented, gifted, intelligent or connected you are. If you’re going to make a memorable impact in any area of endeavour you venture in life, you WILL have to push yourself to do more than the average person does or will do. That is what it takes to stand out and excel.

The above is why the kids of many rich and wealthy people do not always go on to be successful in their own right. Many end up squandering the wealth and resources, even the goodwill built by their parents over the years, once the latter pass on. I’m sure you can point to one or two examples you know in your society – or indeed your neighbourhood.

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 June 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 019: Success is NOT Hereditary – and There is NO Gene Associated With Poverty [Hint: That’s Why This Former Street Hawker Turned International Business Coach Is Launching an Academy to Help Others Succeed!]

 

“Empty pockets never held anyone back. Only empty heads and empty hearts can do that.” – Norman Vincent Peale (NVP)

 

Life is not a bed of roses. Good fortune does not just fall into people’s laps.

As many who have succeeded authentically in this world will tell you, it takes work, often a lot of hard work, to make it in life.

It does not matter how talented, gifted, intelligent or connected you are. If you’re going to make a memorable impact in any area of endeavour you venture in life, you WILL have to push yourself to do more than the average person does or will do. That is what it takes to stand out and excel.

The above is why the kids of many rich and wealthy people do not always go on to be successful in their own right. Many end up squandering the wealth and resources, even the goodwill built by their parents over the years, once the latter pass on. I’m sure you can point to one or two examples you know in your society – or indeed your neighbourhood.

So, success is not hereditary. We cannot pass it from parent to offspring. In the same way, there is no scientific evidence to indicate that there is a gene associated with poverty.

This explains why some people become stupendously rich in their adult lives, despite having been raised in conditions of near crippling poverty.

In essence therefore, what I am saying is that success is not something that can be predetermined or prevented for any person. The individual determines whether or not s/he will succeed. To paraphrase the famous saying: S/he is the master of her fate – the captain of her soul.

Whatever you become in life will be the result of the efforts you were willing to make to achieve your God-given potential. Nothing outside of you can stop you from manifesting your fullest potential and accomplishing any goals you set for yourself.

The key to leveraging the foregoing truths is however your ability to THINK the right way to attract the success you seek, and to BELIEVE that you can bring your thoughts to manifest the reality you desire.

That was what NVP meant in his quote that I began this piece with.

So, if you want to succeed in spite of any obstacles you may ever encounter in life, there are 2 main things you must do at all time:

 

  • Don’t Have/Keep an Empty Head

 

This means you need to be a thinker. The book “Think and Grow Rich” has been read by many millions and counting. It has made most who applied what they read in it, to achieve success beyond their wildest dreams. The testimonials cut across societies, cultures, and races.

 

You need to know how to take control of your thoughts and channel them in a way that attracts what you want to you, while repelling what you do not want from you.

 

Get that book and read it. I read it over 20 times from cover to cover, until I internalised most parts of it to the point that I could recall them as needed for inspiration. The result was that I developed the ability to progress no matter what. Read that book. You will thank me later!

 

  • Don’t Have an Empty Heart

 

Having an empty heart means lacking passion. When you do not do what you love, you will not be able to put what we call your “heart and soul” into it. When you cannot do that, it will often be difficult to continue doing that activity that you are engaged in.

 

This is the nature of the human being. We need passion to be able to persevere in doing something – especially during the inevitable difficult times!

 

So, if you want success, you must invest quality thinking time to identify what your heart tells you is your PASSION. That will be something that you enjoy and WILL enjoy doing, no matter how bad things may ever get for you. No matter what you lack, or what you lose, you will REMAIN ever so passionate about doing it.

 

Only this way will you be sure of keeping yourself HUNGRY to succeed in any area of endeavour you choose to venture.

 

No matter how badly life treats you, doing the 2 things mentioned above CAN – and WILL – help you turn your fortunes around for the better, IF you do them right.

There are so many successful people who have told their life stories that confirm the accuracy of the above statement.

You can come up with a few names yourself I’m sure. Both in your country and out of it. It goes without saying that I know a good number myself, and have studied many of them to build my own success despite the severe visitations of prolonged adversity I encountered, especially over the past 14 years in self-employment.

However, every now and then I come across a true story of someone who applied the above steps to succeed, and the details of the experience he had really impress me.

One such person is UK based Business Coach, Professional Speaker and Marketing Consultant – Efe Ohwofasa.

Efe is a client whose work I’m promoting, because I believe in his brand.

Photo of Efe's Lifestyle Business Conference Flyer - Click to view larger image and download/print

We’ve never met in the flesh since he reached out to me in 2013. I’ve now worked remotely with him now for about 8 months on 2 projects.

 

His amazing rag to riches success story has really touched me, and when he told me about his project to give back in Africa, I decided to go the extra mile to do my bit to help out.

Below is a message I’ve been sending out.

If you can spare the time from your busy schedule – help spread the word if you know any persons or groups/associations/­organisations in the Benin – Delta area that may be interested.

There are plans to roll out in Lagos, Abuja and other cities. So we’ve been trying to connect with partners.

=Message Starts=

If you’re In Nigeria’s Delta State or Environs, DO NOT Miss This Life Changing Learning Event (on Sat 25th June 2016) Hosted by Efe Ohwofasa – Who Once Hawked Garri, Yams and Plantain On the Streets of Sapele, to Pay His School Fees, But is Today a Respected International Business Coach Serving CEOs in the UK and beyond!

Get full details, including a downloadable press release at www.efeohwofasa.com/lsb [Even if you can’t go, tell others who can!]

.

SDN Blog™

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

[True Story – PDF] I Started My Piggery Business As a Penniless Novice, But Now Supply “Low Fat Lean Meat” to Bulk Buyers [Hint: Subtitle: Why Smart Feed Formulation & Low Costs Is Crucial for Pig Farming Success] – By Wale Ibidunni

[Saturday]:

[Example MS ExcelVB Workbook] How to Open a Website from MS Excel using ExcelVB code

 

[Sunday]:

Protected: THE FARM CEO (Issue 50): Articles Based Compilation of Over 100 New Farm Business Ideas [Hint: Especially for Young People]

 

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

 

[Example MS ExcelVB Workbook] How to Open a Website from MS Excel using ExcelVB code

<I>[This is a tutorial note for members of my ExcelVB club]</I>

This week I’ve prepared an example MS ExcelVB driven workbook with code that enables you click a button I linked to it on a worksheet, to open a website of your choice in a new browser window.

 

In order to allow you fully test it with web addresses of your choice, I’ve setup a table in the worksheet in which you can type a list of website names (e.g Yahoomail, Google, Tayosolagbade etc) in one column, and their corresponding TLDs (Top Level Domains e.g com, net, biz etc) in the next column.

 

Once you do the above, your entries become available in the 2 in-cell drop menus I’ve setup next to the website list table.

 

Next simply click in the yellow coloured cells to use the in-cell drop menus to choose the website name and TLD you want.

 

Notice how the compound formula in the cell between the above 2 uses the selections you make from the drop menu to build a full URL.

 

Once that happens, click the command button labelled “Visit Website” and watch as the ExcelVb code opens a new browser window and loads the URL you built in it.

 

See my instructions in the example workbook (emailed to you). I’ve also inserted tips in form of in-cell comments in the yellow coloured cells.

 

During the week, I’ll send you detailed explanations of how the code works, and how to build the workbook from scratch, PLUS potential uses to which you can put this kind of ExcelVB driven workbook solution.

 

 

[PRESS RELEASE] UK Based Coach Who Once Hawked Groceries to Survive Launches Life Changing Lifestyle Business Conference in Nigeria

EFE OHWOFASA [FOCUS GURU™]’s Lifestyle Business Academy

FOR IMMEDIATE RELEASE
June 2016

Contact: Efe Ohwofasa
Phone: +447944426005
Email: efe at efeohwofasa dot com
Web: www.efeohwofasa.com

Life Changing One Day Lifestyle Business Conference Debuts in Nigeria’s Sapele

Bournemouth UK based business coach,
professional speaker and marketing consultant, who grew up in Sapele hawking garri, yam, pure water, plantain etc, to pay his way through school, launches his Lifestyle Business Conference.

BOURNEMOUTH, UK – All is now set for the maiden edition of Efe Ohwofasa’s Lifestyle Business Conference, with the theme “Make Money Doing What You Love”.

This event will give job seekers, career persons, the self-employed and even retirees an exciting opportunity to learn how to make their dreams come true, by learning from a man whose life story has touched many for years within and outside the UK.

Efe, whose new book “UNLEASH YOURSELF” tells his amazing rags to riches story of going from hawking groceries for years as a teenager in his home country of Nigeria, to become a respected international business coach in the UK, will be launching this event across 7 different Nigerian cities, in line with a vision to help many find their own purpose in life.

“The question is: what steps are you taking to ensure that for the rest of your life, you do not die in poverty, or unfulfilled, BUT end your journey as an accomplished personality getting highly paid for doing what you love and making a difference in the world?” – Efe Ohwofasa, Focus Guru™

The maiden Lifestyle Business Conference will hold as follows:

Date: Saturday 25th June 2016

Time: 10am – 4pm

Venue: Peemos Place, Sapele-Delta state, Nigeria.

To learn more about the event and how to attend, or to partner with Efe’s Lifestyle Business Academy in the roll out, go to http://efeohwofasa.com/lsb/ to read a special message and signup to watch the video.

Protected: Think Like a “Problem Solver” and NOT a “Programmer”, to Make Money With Your ExcelVB Coding Skills [Hint: Meet The Man Whose World Class Web Based Learning Resources Helped Me Take My Problem Solving Excel-VB Solutions Development to the Next Level!]

This content is password protected. To view it please enter your password below: