Category: Just Tricks

All the other languages.

Format and Color Text in Excel Cell with VBA

Formatting a substring of a string in an Excel Cell is actually quite a challenging task. There are two ways to do it – select part of the substring that you wish to format and change its color. Then make

Tagged with: , ,

SQL – Make XML from a SQL database

Some time ago I have decided to go a little deeper into SQL. And by some time ago I probably mean some years. Anyhow, in this article I will present the ways I know to make XML out of SQL

Google Chrome Extension – Building a simple extension for VitoshAcademy.Com

In this article I will simply let you know, that vitoshacademy.com has its own google extension now – it simply shows you  the last 10 articles in the site and it lets you know if there is a new one.

Tagged with:

JavaScript – Make a RegEx Text Tool

Plenty of Regular Expressions tools are available in the net. Most of them are free and quite quick. I have actually never thought that building such a tool can be done rather quickly, as far as the RegEx is part

Tagged with: ,

JavaScript – A function returning a function returning a function

Working with JS may be difficult for a beginner. Or for someone like me, who dares to think of himself as a … let’s call it not a beginner. 🙂 One of the strangest staff there, if you are coming from the

Tagged with: , ,

jQuery – Forms And Automatic Selectors

Although VitoshAcademy is not an  Academy, there should be some educational stuff. Thus, in this article I have decided to put something educational. 🙂 Let’s see how to make a simple selector in jQuery, which updates below some text, based

Tagged with: , , ,

jQuery, JS – Build a Probability Simulator

Some time ago a king needed money. So he gathered his advisors and told them to think of a new task. One of them offered to tax stupidity. The king asked one question – how. The guy came up with a

Tagged with: , , , ,

jQuery Events – Trigger vs TriggerHandler

Let’s start from the very beginning in jQuery. Somewhere in the beginning there are events and buttons. So, I will start from there, explaining how to Trigger events and what is the difference between trigger and triggerHandler. Trigger triggers the event completely

Tagged with: , , ,

jQuery Mobile – Make a simple mobile web site

Building web sites is for at least 20 years a thing. Even I am able to build one, using WordPress without some advanced IT skills. Lately, I was into jQuery and thus I found something really meaningful and well written

Tagged with: , ,

JavaScript – Create Ul and LI elements with JS (With chained function)

When you code in JS, there is always some time that you need to create some html list with JS from array or list or something else. I knew the trivial way with a simple for loop, but when I put myself

Tagged with:

JavaScript – Some code for inheritance in JavaScript

The last month I am writing mainly small pieces of code for JavaScript, because I think I start to like the language somehow (and I took 3 books for review in JS and so far I have only reviewed one).

Tagged with: ,

JavaScript – How to make a module in JS

Making a module in JS is kind of interesting. Especially, if you expect something like a class like in VBA or C#. Well, it has nothing to do with it, it is just a function, assigned to a variable. In

Tagged with:

JavaScript – Some ways to build functions in JavaScript

There are plenty of ways to make functions in JS. However, the nicest ones are to assign the function to a variable and to call the variable. Why this is the nicest one? Well, probably because I cannot make something

Tagged with:

JS – OOP in JS, made simple

JavaScript seems to be the language for me for December. Although I am really working with VBA only, JS has really a lot to show. Thus, today I will simply write some easy OOP samples, that I can use later

Tagged with: ,

JS – Another To Do App

There is something about these todo apps. Probably the reason that I put so much attention on them is that they are the easiest to be built and you may always try something new on them. This is probably the

Tagged with:

JS – Another simple js game with counters and click events

Recently I have started to read a little more about JS, in order to make the reviews of some JS books. Thus, this December would be JS December (or at least the first part of it! 🙂 ). So, lets

Tagged with: , ,

Maths – VAT Calculation Formula

If your VAT is 20% and you want to calculate how much VAT should you pay for 100 EUR: (0.2*100)/(1+0.2) = 16.67 EUR This is how to calculate how much is the sum without VAT of 100 EUR with VAT:

Tagged with: ,

VB .Net – Notifications for Windows Taskbar

Every user of Windows has seen the notifications on the Windows Taskbar. They are somehow not pleasant, but sometimes useful with the information they provide. If you want to make use of those in VB .Net, this article would show you how to

Tagged with: ,

HTA – HTML Application with Basic!

Today I found out that there is a possibility to build nice applications with Visual Basic, using HTML and CSS in them. The technology is called HTA – HTML Application and it looks pretty much as an exe file with

Tagged with: , , , ,

VB – XML Generator with Visual Basic

So, while I am really working with VBA for the latest months, I have decided to upgrade a little and to take a look what can be done with VB .Net, hoping that some better ideas would come and I would be

Tagged with: , ,

MySQL for MS Excel

Yes, it exists! Today, I somehow managed to install it from here. This is how it looks like: Just a small icon in the Excel data tab. Once you click, you are asked to make the connection with the DB. Due

Tagged with: , ,

Angular JS – Just Another To-Do App

In the last year, I have made quite enough To-Do apps – just in VitoshAcademy.com I have published one with PHP with login functionality,  and I had quite a big project (about 3 days of coding from 3 coders ) here

Tagged with: , ,

AngularJS – Make a scope function with Angular

In the current article, I would simply make a scope function with Angular JS. This is always useful to have in your toolbox:   Yup! The code is simple and the idea came from this app here, but mine is

Tagged with: ,

ASP.NET Hello World with VB.NET

ASP.Net is one of the technologies, which I have not mentioned in my site. Thus, I will start mentioning it, because it is probably amongst the very few, which use still use VB. And due to some weird reason, I

Tagged with:

JavaScript – A simple calculator with lots Bootstrap

Have you ever dreamt of making the simplest application for calculating two numbers? Nope? Me also. But anyhow, I have started to make it only with JavaScript, without jQuery and it turned out to be fun after some time. That is

Tagged with: , , ,

XML with PHP – make links easily

I really did not think to make a post about it, but as far  as I have lost about 15 minutes in research how to do it, it is obviously that spending some 10 minutes more would be valuable. The

Tagged with: , ,

AJAX – JQuery – PHP – JSON – Get data from DB with AJAX

Some time ago I have made a simple ToDo list with PHP here. Today, using its database and one function from the list, I have decided to make the todo list with Ajax. This means, that you should not refresh

Tagged with: , , ,

jQuery – Build a background with changing pictures with jQuery

So, animation in jQuery is a powerful thing! 🙂 Indeed. In the current article, I will show you the code, which I have used to produce the following beautiful video. It is just a few seconds, but you may still

Tagged with: , ,

JQuery – A simple game with JQuery events

Working with JQuery becomes interesting, after you get some ideas what to do and you see how easy it is to build it. Although the code below can be made about 8 times less, I have really enjoyed copying and

Tagged with: , , ,

JQuery – DOM – InsertBefore, PrependTo and other examples

So I have tried to learn a little about jQuery and its DOM functions and this is what I have managed to do today – an example with “insertBefore”, “prependTo”, “insertAfter” and “appendTo”. Pretty much that is what the example

Tagged with: , , ,
Top