Author Archives: Al

How to find engaging tweets on twitter using Tweetdeck

If you use Twitter and you’re looking for engaging content to retweet (ie, steal) you can use Tweetdeck with advanced search operators and Hashtagify to find what you need.

If you haven’t visited Tweetdeck, the site is part of Twitter and can be reached by visiting http://tweetdeck.twitter.com/ and logging in with your normal account. Tweetdeck allows you to build up various columns of tweets which may be of interest to you and is a very powerful tool to keep on top of important tweets.

For example, I have an account on Twitter which only posts pictures and videos of cute animals. A simple strategy for myself is to do the following:

Continue reading

Partially underlining text in an excel cell to give the appearance it’s a hyperlink.

I came across a problem recently where I had certain cells within an excel spreadsheet which updated a graph when they were double clicked on via a macro. The problem was that it was unintuitive to the end user that clicking on these links would update the graph.

After discussion with the customer, we decided that if they where to look hyperlinks it would be more intuitive that they actually did something when clicked on. “Simple!” said I, “I’ll have that fixed up before we next meet. I’ll just change their style to look like hyperlinks… colour them blue, underline them… easy peasy!” 

So I had a play around with the formatting in Excel, googled frantically for 20 minutes and discovered this is not so simple. The problem was the entire cell was being underlined, not just the text. This is the best that I could come up with.

Not sure why this happened as I’m sure excel is supposed to allow partial underlining of a cell. There is a solution however and it involves a bit of VBA.

  1. Click Alt-F11 to go into the VBA screen.
  2. Double click on the sheet you’re working on as we’ll store the VBA code there.

3. Paste the following code into the sheet.

4. Ensure the immediate window is displayed – CTRL + G

5. Run the sub by typing the following into the immediate window (assuming you stored the code in Sheet1)

sheet1.Hyperlink_Months(true) – To turn on the partial formatting of the text (making it look like hyplinks in this case)

or

sheet1.Hyperlink_Months(false) – To turn them off again.

6. Your life is now complete!  😉 

What is the easiest way to remote into a computer?

I have a reputation amongst my friends and family as the technical person, which quite often means that when a cellphone, computer or any electronic gadget for that matter is misbehaving, I’m the first person they call. With computers, I try to determine the problem over the phone to figure out if there is an easy fix. If I can not determine the problem over the phone, or the fix is too complicated to explain, I simply pay them a visit so I can fix it for them.

Up until a year ago I had known about gaining remote access into peoples computers, but had never actually tried it. Basically you and your friend with the computer problem both download some software. You can then gain full control of their computer, mouse and keyboard, and diagnose and repair the problem from your home. It’s as if you are sitting right in front of their computer, without actually being there.

I tried out a number of different software solutions to do this, but unfortunately they all required a monthly subscription, except for one. That software was called “Team Viewer” Continue reading

How do I add youtube videos to my PhpBB3 board?

The problem

A client who owns the message board at http://www.electrofreaks.com/ wanted to allow his users to embed youtube videos within their messages. Currently people are able to link to youtube videos, but are not able to embed videos within their posts.

The Solution

Within phpBB3 there is a feature which allows you to create custom BBCodes. This means that it is possible to embed anything into your phpBB3 message board, so long as embedding is supported on the site which contains the content you wish to embed. Here are the steps:-

Continue reading