Skip to main content

Posts

Create QR Codes in Excel With VBA

Need to automate the creation of QR Codes? Excel and VBA can help with that! Here's how to do it in less than 15 lines of code. What we're looking to do is have a URL in a cell and then we're going to use a function that we create in VBA call Google APIs to create the code. Here's a video that explains the whole process of creating a user defined function in VBA that will create QR Codes: Code to create QR Codes in Excel with VBA Open up your Visual Basic editor and insert the following code and then save. To call the function, type =GETQRCODES(Cell Address) where Cell Address is the address of the cell which contains a URL that you want to send your user to. Function GETQRCODES(QRCode As String)     Dim URL As String     URL = "https://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & QRCode     ActiveSheet.Pictures.Insert(URL).Select     With Selection.ShapeRange(1)         .Name = "QR_CODE_" & QRCode...
Recent posts

How To Change Bluetooth Name On Android

This post will take you step-by-step through the process of changing the Bluetooth name of your devices on an Android phone. There are pictures as references in case you get lost along the way. Change Bluetooth Name On Android | Step-by-step 1. Unlock your Android phone and go to Settings Unlock your phone and click on the Settings Icon It goes without saying, but the first thing you need to do is unlock your phone. By default, the settings icon will be on your home page like in the picture above. If you don't have the settings icon, you can search for 'Settings' in the Android search bar. 2. In the Settings page, click on Bluetooth Click on the Bluetooth settings to open up the Bluetooth Settings menu Click on the Bluetooth settings which should be at the top of your Settings page. If it doesn't, scroll down till you find it or just search for it in the search bar at the top of the Settings page. 3. Click On Device Name To Change Your Phone's Bluetooth Name Click o...

How To Turn Bluetooth On Windows 11

  Need to connect your Bluetooth device to a Windows 11 computer? You need to turn on Bluetooth on Windows 11 first. Here are all the ways to do so in Windows 11, including the Bluetooth Network Connections and Device Manager. 1. Quick Settings Menu Quick Settings menu usually found on the bottom right of the Windows Taskbar The easiest way to turn on Bluetooth on Windows 11 is to use the Quick Settings menu. The Quick Settings menu is the group of indicators that can be found on the bottom right of the screen, next to your date and time on the taskbar. Expanded Windows 11 Quick Settings menu that shows if Bluetooth is enabled Check whether the Bluetooth icon is colored. If it is, then Bluetooth is already turned on. If it is grey, click the Bluetooth icon to turn it on. Once you have clicked the Bluetooth icon, it will be colored, to indicate that Bluetooth has been enabled on Windows 11. By default, Bluetooth should already be listed in the Quick Settings list. If you...

How To Set YouTube To Dark Mode

Did you know that YouTube has a Dark Mode that's a lot easier on the eyes? It's not well publicized and not many people know about it. Here's a step-by-step guide on how to set YouTube to Dark Mode. Set YouTube To Dark Mode Steps 1. Click on the profile icon at the top right hand corner of your YouTube page like show in the picture above. This will open up your profile options. 2. Look for the appearance: device theme option with a moon next to it and click it. 3. Click on the 'Dark theme' option to set YouTube to dark mode. And there you have it. You have now successfully set YouTube to dark mode. Take note that the changes only applies to this specific browser. If you were to log in to your YouTube account on another browser or device, you will need to make the changes again. Is The YouTube Light Theme Or Dark Theme Better? It really comes down to user preference on whether YouTube's light theme is better than the dark theme. Those who prefer dark mode claim t...

How to View YouTube Shorts in the Regular YouTube Player

YouTube's "Shorts" is YouTube’s answer to TikTok and Instagram reels but let’s be honest, the YouTube Shorts player lacks some functionality, such as the ability to fast forward and go back in the video. However, you might be surprised to know that every video that loads in the "Shorts" player is actually a regular video, and by changing the URL slightly, you can load the same video in the regular player along with all the functionality of a traditional YouTube video. Changing the URL Changing the URL is the easiest way to switch the player from a technical standpoint. It’s so easy even your grandma can do it, as long as she knows how to type an address into the address bar of a browser.   Let’s use this super popular short video about AI taking over ping pong as an example. Look in the URL bar of a video playing in the "Shorts" player, where you should see the text Shorts/. Replace that text with watch?v= and load the new URL. So in this...

Keep Your Shoes Fresh and Odor-Free: Tips and Tricks

Are you feeling conscious of the odor coming from your shoes? Say goodbye to smelly feet with these simple solutions. Tip #1 - Place a Tea Bag In Your Shoes Place a tea bag in each shoe to keep them fresh and odor-free. Tea bags don't kill bacteria that cause foot odor, but they can help to absorb the moisture that bacteria thrive on. The main cause of foot odor is bacteria on the feet 'eating' sweat and secreting a bad odor. So, the first step is to get rid of the moisture in order to keep the bacteria under control. Tip #2 - Use Zinc Oxide Powder Another tip is to use Zinc Oxide powder to keep bacteria under control. Zinc Oxide powder doesn't allow the bacteria that cause foot odor to survive, period. Rub it on your feet, between your toes, and into the sides of your nails where the bacteria can hide. Sprinkle it in your shoes, spread it around so the insides are covered. It'll take about a week but after that, you will notice much less foot odor and your shoes w...

How To Disable WordPress Comments

Tired of all the spam comments on your blog? If you're using WordPress, here's how to turn comments off. You're going to be wondering why you didn't do this sooner. 1. Disable Comments Blog-wide 1. Go to Settings on your WordPress menu and click on 'Discussion'. 2. Make sure you have unselected 'Allow people to submit comments on new posts'. Press the Save Changes button at the bottom. This will disable comments on your blog going forward but if  posts that you have already published allow comments, then you will need to disable the comment section for the posts individually. 2. Disable comment section for individual posts 1. Select the individual post that you want to disable comments for and press the edit button. 2.  Under the 'Post' tab, scroll down to the 'Discussion' section and unselect 'Allow comments'. 3. Press the Update button at the top once you're done with all the changes that you'd like to make. --- With the...