All posts by Tayo Solagbade
[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>
[TRIBUTE] Muhammad Ali: Builder of People & Bridges Between People!
This article is based on excerpts from a message I recently sent to a friend, in which I shared my feelings about how Muhammad Ali influenced me. It’s a short piece – especially by my standards – but it’s just right for the personal tribute I’ve been meaning to publish on this blog in commemoration his recent passing 
<H3>Like many people around the world who’ve watched the video of the popular “15 Rounds” tribute done by Billy Crystal 36 years ago to Muhammad Ali, I also found it very moving and inspirational.</H3>
<a href=”http://www.sportingnews.com/other-sports/news/muhammad-ali-billy-crystal-impression-15-rounds-retirement-ceremony-1979/164ofgktedjhf133vv24zxcf06″ target=”blank”>Click here to read one of several articles featuring the video version of that tribute</a>.
Like many have noted since his burial, that tribute (which Billy Crystal released on social media after Ali’s death was announced) reflected, among other things, the fact that Ali brought out the best in everbody – regardless of their differences.
He was a builder of people and bridges between people.
Ali didn’t stop at just being good at what he did. Instead he went further to act as a Social Change Agent against problems he identified in his society.
<H3>Politics did not interest him. So being politically correct was never something he tried to be </H3>
Instead he said whatever he felt needed to be said, no matter whose Ox was gored. And he neither played favourites, nor allowed narrow or irrational sentiments to influence his expressed views.
Quite often Ali was practical and realistic in making his points on issues.
Racial discrimination was one subject he really spoke passionately about. His personal experience of getting thrown out of a white owned restaurant (where they told him “we don’t serve blacks here”) in his home town of Louisville just after he returned from winning the gold medal in boxing at the 1960 Rome Olympics, fueled his drive and passion to influence a change in society!
There is no doubt that because of the way he used his fame to speak against racial discrimination in the USA for instance, changes in segregation practices happened faster in that society than they would have, if he’d chosen to keep quiet and focus on the profession at which he was exceptionally gifted and successful.
<H3>I’ve long followed Ali as he spoke against racism etc despite the risks/pains it cost him. </H3>
His life story is a testimony to the power of faith and self-belief. Despite being just one man, he succeeded in unifying people across racial, religious, language and other socio-cultural barriers.
The Muhammad Ali Centre he founded has helped many thousands of disadvantaged people while he lived, and continues to do so.
Incidentally that centre was setup to fulfil the dream he described when he answered a little boy’s question: “What will you do when you retire from boxing?”
See <a href=”http://m.youtube.com/watch?v=2QE9XBovMk0″ target=”blank”>the video in which he gives his answer to that question – click here</a>.
That video and the one for the earlier mentioned tribute, as well as those in which he spoke in interviews against racism and his views of how society should be run without discrimination, are why I made him one of my role models in life.
<b>Muhammad Ali set a great example for how to excel professionally/personally and then use one’s success to make a useful impact socially in people’s lives.</b>
Our respective societies will be much better off if we can EACH emulate this man’s wonderful qualities in the way we live our lives and relate with one another.
Rest In Peace Champ: You are truly the Greatest Of All Time!
Tomorrow (25/6/16), UK Based Business Coach Hosts Entrepreneurship Conference in Sapele, Where He Once Hawked Groceries As a Teenager! [Invitation to Potential Partners]
Having flown in from the UK early this past Tuesday, Efe Ohwofasa, who once paid his way through secondary school by hawking garri, plantain and other groceries on the streets of Sapele, will host the maiden edition of his entrepreneurship empowerment event in that same city!
Below is a formal letter that members of Efe’s LSB (Life Style Business) event marketing team have been sending out to potential partners.
<h3>I share it here as my own contribution to this project. If you’d like to partner with Efe’s Lifestyle Business Academy, use the information provided below.</h3>
<Blockquote>
Dear Sir,
We write to propose what we hope will interest your organisation enough to result in direct contact being made with Efe Ohwofasa, regarding the work he’s doing via his Lifestyle Business Academy Conference.
We propose that yoz consider exploring opportunities for partnering with UK based Nigerian born Business Growth Coach, Professional Speaker and Marketing Consultant – Efe Ohwofasa.
Tomorrow, Efe will roll out the maiden edition of his “Launch Your Lifestyle Business” Conference with the theme: “Make Money Doing What You Love”
Date: Saturday 25th June 2016
Time: 10am – 4pm
Venue: Peemos Place, Sapele-Delta state, Nigeria.
The page below offers full details about it:
http://efeohwofasa.com/lsb/
Download the print-ready PRESS RELEASE! published for this event, which we’re sending out to media houses and journalists from;
<a href=”http://www.efeohwofasa.com/wp-content/uploads/2016/06/efe-pr.png” target=”blank”>http://www.efeohwofasa.com/wp-content/uploads/2016/06/efe-pr.png</a>.
To this end, he arrived Nigeria this past Tuesday, bringing with him a wealth of world class expertise to share with attendees of his Lifestyle Business Conference.
Just last week – 16th June 2016 – to be specific, he (in response to an invitation by Bournemouth University’s Institute of Directors,UK) delivered a presentation titled…”Passion 2 Profits”- How To Discover Your Entrepreneurial Potential And Achieve Your Career Success” at Bournemouth University, UK (See
<a href=”>http://www.efeohwofasa.com/uploads/efe-lsb2.JPG” target=”blank”> http://www.efeohwofasa.com/uploads/efe-lsb2.JPG</a>)
Efe is rolling out the Lifestyle Business Conference as a way of giving back to society, to help others discover their purpose and succeed in life, inspite of their circumstances – just like he rose from hawking groceries on the streets of Sapele to become a respected Business Coach in the UK.
Initial plans are being worked on by his contacts in Sapele, to roll out the conference. But the vision is to continue across 7 Nigerian states, and ultimately the entire country.
We believe that collaborating with organisations like yours can enable us reach out to larger number of people who can benefit from exposure to valuable learning of this kind – hence the decision to reach out to you.
There is additional information about Efe, and what he does on
http://www.efeohwofasa.com (content updates in progress).
The LSB Team – <a href=”http://www.efeohwofasa.com” target=”blank”>www.efeohwofasa.com</a>.
</Blockquote>
To Achieve Massive Self-Marketing Impact, You Need Google Plus [Hint: Save Time/Effort by Auto-Publishing New Client Attracting Posts On It]
If you’re a self-marketing professional, a Google+ profile can help you get noticed and ultimately attract paying clients to you.
I say this as one who has reaped such benefits from using it for self-marketing.
For some strange reason, many business persons I’ve checked out often stop at creating a Google+ profile, but never progress beyond putting in few basic details about themselves into it.
The result is that they unknowingly deny themselves potentially valuable opportunities for high quality zero cost marketing exposure via the Google search engine!
<I>[NB: Apart from a “Personal Google+ Profile” there is also “Google Plus for business” through which you can setup and utilize company pages to promote your business <a href=”https://blog.hootsuite.com/create-a-google-plus-page/“ target=”blank”>Click here to read an article by Hootsuite</a> about how to do that]</I>
<b>I decided to write this piece after I accidentally stumbled on the Google+ profile for a recent prospect with whom I had preliminary interactions. </b>
The very bare appearance of his page shocked me – especially given the fact that as a real estate sales professional, a platform of this kind offered him ample opportunity for self-marketing.
So I went out of my way to send him a message via email with links to references, followed by a 4 minute Whatsapp audio suggesting simple ideas for updating the “About” page as well as the “Posts” on his Google+ profile.
<h3>What I proposed to him was based on what I did to set mine up (see link below) – and what I do to keep it updated/alive, in a way that periodically generates sales leads for me</h3>
<a href=”https://plus.google.com/app/basic/+TayoSolagbade“ target=”blank”>Click here to view my profile</a>.
The “About” page’s fields have been filled with descriptive content written in a way that communicates the solutions I offer.
Like I always tell my Web Marketing System (WMS) clients, it’s very important to visibly display references to your key offerings and contact details in as many different formats (text, image, video etc) as possible.
That was why I made sure to design and upload a banner (in the space provided at the top of the profile page) featuring highlights of my flagship URL, and products, alongside my headshot and email address.
Most important however, is the fact that I setup my profile page to be “alive”, so that it never gets stale, and is therefore able to do its job of attracting potential clients to contact or at least connect with me.
Indeed, a review of my posts will reveal that some persons in the past published enquiries about my products/services upon reading them. Today, a number of those enquirers have become my clients.
Yet this happen(ed) despite the fact that I never had/have to sit in or stay on my Google+ profile to create updates. Instead the posted updates happen automatically from my blog at www.tayosolagbade.com/sdnuggets – so it’s not like I have to come there and make entries.
<h3>Having said the above, note that you need to creatively populate your blog and profile with useful content that can make you get found – due to the interest it generates in the minds of your target audience.</h3>
It goes without saying that doing THAT is not easy. Compared to putting in your “About” page details, it’s a lot of hard work.
But if you do it right, it will work for you.
Among other benefits, when people search Google using your name, a more comprehenive Google+ profile page, complete with visuals you’ve put up will appear in the results page. And that has a way of boosting your credibility in the minds of those who see it.
By the time they click to learn more, the quailty of information and education they encounter will further draw them closer to taking action to contact you, or at least add you to their circles – both of which get you nearer to your intended goal of selling to them!
If you’d like to have those benefits, I recommend you work on your profile asap so it can start working for you – like mine does for me.
To attract more clients at zero cost, you need to leverage your Google+ profile – and other zero cost self/business promotion platforms to boost the marketing reach and impact of solutions you offer.
<h3>The link below leads to my personal Google+ profile, which I setup in line with recommendations made by experts whose work I follow. </h3>
<a href=”https://plus.google.com/app/basic/+TayoSolagbade“ target=”blank”>Click here to view my profile</a>
It is however instructive to note that I’ve gone further to incorporate intelligent automated content updating systems on my website, that auto-publish my new content updates from this blog to my Google+ profile.
I do the above for my Web Marketing System (WMS) clients, and also coach them to do what I do for them, by themselves, over time – as members of my Web Marketing for Farm CEOs (WM4CEOs) club.
If you need help making use of the ideas I’ve shared here, consider joining my WM4CEOs club – <a href=”http://tayosolagbade.com” target=”blank”>click here to read my special offer of 12 months Web Marketing Support for business owners</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 November 2008 on http://EzineArticles.com
[RECOMMENDED] 5 Steps To Get The Best Eggs Possible (from www.hobbyfarms.com)
<I>[Tayo Solagbade’s note to reader: Every week I search the web for potentially useful articles on farm business management. This write up by HobbyFarms.com offers practical wisdom that any poultry farmer looking to boost farm performance profitably will appreciate. By “TLC” the author of this article means “Tender Loving Care”]</i>
Treating your layer hens to a little TLC will mean delicious, golden-yolked eggs for your morning breakfast.
Back in the days before my layer flock came to enliven life on our farm, I would have picked the egg for sure—or maybe the egg carton. After all, the runny, pale-yolked eggs I cooked came from cartons sold at the grocery store, not from any chickens that I could see. My perspective changed, however, when I brought home our first fuzzy chicks, watched them grow into gawky pullets and waited—and waited—with bated breath for our first farm-fresh eggs to magically appear.
I eventually learned that not only did you first need chickens to have eggs (obviously), but to start getting eggs, you also needed your pullets to reach about 20 weeks of age. And to get an ongoing supply of good eggs, your chickens needed the right food, clean nest boxes, sufficient daylight and more. In other words, because an egg’s quality reflects the care and management the hen receives, getting good eggs takes some work—and not just on the chicken’s part. Take it from anyone who has ever kept a layer flock, the delicious results are well worth the effort.
<a href=”http://www.hobbyfarms.com/5-steps-to-get-the-best-eggs-possible-4/” target=”blank”>Continue reading</a>
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
Monday 20th June 2016
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.
**********
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.
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) 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. ====
|
Protected: THE FARM CEO (Issue 50): Articles Based Compilation of Over 100 New Farm Business Ideas [Hint: Especially for Young People]
[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.