• Blog Homepage
  • Website Homepage

Magic Monk's Blog

Follow Magic Monk's Journey

Magic Monk

IT Education

VBA Excel 2016 Lesson 5 – Averaging numbers in VBA

By Magic Monk on Friday, January 31, 2020

Today we introduce you to two ways to average numbers in VBA – using numerical operators or the WorksheetFunction object.

Continue Reading
0
IT Education

VBA Excel 2016 Lesson 4 – Set Properties Of Objects

By Magic Monk on Thursday, January 30, 2020

In this lesson we talk about how to set properties of objects, such as editing the value of a cell or a range of cells, using VBA.

Continue Reading
0
IT Education

VBA Excel 2016 Lesson 3 – Objects and Methods

By Magic Monk on Wednesday, January 29, 2020

In this lesson we look at the code behind a macro. We learn that in each line the code can be broken up into objects and methods. We experiment by adding another subroutine using code only, instead of having to record a macro.

Continue Reading
0
IT Education

VBA Excel 2016 Lesson 2 – Create clear contents macro and assign it to a button

By Magic Monk on Tuesday, January 28, 2020

In this Visual Basic for Applications lesson, you will create your first Macro and assign it to a button. The macro simply clears the content in a few cells.

Continue Reading
0
IT Education

VBA Excel 2016 Lesson 1 – Enable developer tab

By Magic Monk on Monday, January 27, 2020

In the first Visual Basic for Applications (VBA) lesson, we do the first step required in order to start programming in VBA. You need to enable the developer tab. If you don’t enable developer tab, you will not see any of the buttons needed to write a VBA application. This quick tutorial shows you how.

Continue Reading
0
IT Education

Samsung Galaxy S10e part 2 – Set up fingerprint sensor

By Magic Monk on Sunday, January 26, 2020

So after after part 1, we turn on the phone and tried to get through the setup. It takes a while and there is a lot of reading. Then I spent ages trying to set up the fingerprint sensor. I will do facial recognition next time. Also I installed all of the Samsung apps – …

Continue Reading
0
IT Education

Samsung Galaxy S10e SM-G970F/DS part 1 – Unboxing, installing Sim card

By Magic Monk on Saturday, January 25, 2020

Hi! Welcome to my series of videos on exploring the Galaxy S10e. I’ve discovered that it comes with a case, 2 chargers, a USB-C cable (I didn’t know the phone doesn’t use micro USB) and some earphones. It’s a dual sim phone so I’ve put my sim cards in and turned the phone on.

Continue Reading
0
IT Education

How to retrieve photos from your Android phone via WIFI on Windows 10 (Xiaomi Redmi 6)

By Magic Monk on Friday, January 24, 2020

With the latest Windows 10 update, you can now use an app to retrieve photos from your phone wirelessly without using the USB cable! Very convenient. Try it out.

Continue Reading
0
IT Education

Google Contacts Not Syncing Fix – Xiaomi Redmi 6 MIUI – Part 4 – Enable Permissions

By Magic Monk on Thursday, January 23, 2020

Here comes the last step required to get your google contacts to Sync on your new Xiaomi Phone – Enable all permissions for the Google Contacts Service! Without this step, your google contacts will not sync! Enjoy using this phone with google contacts 🙂

Continue Reading
0
IT Education

Google Contacts Not Syncing Fix – Xiaomi Redmi 6 MIUI – Part 3 – Install Google Play

By Magic Monk on Wednesday, January 22, 2020

The third part to my series of videos on enabling google contacts for my new Xiaomi Redmi 6 phone which I got off AliExpress (Chinese version). In this tutorial I will show you how to install Google Play.

Continue Reading
0

Posts navigation

← Previous 1 … 4 5 6 7 8 … 75 Next →
Theme by Scissor Themes Proudly powered by WordPress