Posts

Showing posts from September, 2013

VBA Introduction - Excel

Image
Hi Everybody, today i'm gonna teach you how to code in Excel, Word, PowerPoint, etc. But you should ask you: Is that possible? Yes it is, with VBA or Visual Basic for Application. In fact you can code in any program that belongs to Microsoft Office to make your life easier using Macros. Everybody can create macros using the recorder, but this option limits a lot, because the steps that you recorder are just the ones that always the Macro is going to execute I mean is to static, but what happens if you want to make it a little bit more dynamic, well that's where VBA appear. This time we are going to create a Macro in Excel and with this we are going to learn: Format options Conditional Sentences With Use Ok fisrt of all we need to Open Excel and activate the Developer Tab: Go to File Click on Options Click on Customize Ribbon Select Developer in the Main Tabs bucket Click Ok Now once we have the developer Tab, to create a Macro we have to c...

A little bit of JS (JavaScript)

Image
Hi Everybody today i'm going to show you how to create a simple calculator, with this we are going to learn: How to combine Js with HTML How to manage the attributes of a Form through Js Conditional Sentences with Js Global Variables with Js Parsing values in Js And what we need is: Notepad Internet browser First of all we need to undertand how JavaScript works, JavaScript(JS) does not need a compiler, it needs an interpreter(there is a huge difference between those things) and the interpreter will be the browser, any browser supports JS, so IE(Internet Explorer) will work. JS does not work just by itself, it needs an structure of HTML that call it to work, so we can say that JS + HTML = Great Web Page, you can add some CSS if you want to create a beatiful Web Page. Is correct! JS is a lenguage use in HTML to improve the performance of the Web Pages due to the validations or some operations that does not need an interaction with DB can be performed by an JS file. Ok ...