There are a number of tasks my spreadsheet has to do that may be too complex
to use macros on its own.

I have little experience with using VB, (Only thing i have made is a web
browser program, (not linked to excel))
---------- ------------------ -----------------
------------------- ----
Does anyone know how i could learn (e.g. website etc) how to use visual
basic, not just to make programs but to also use it with excel?

How did you first learn to use it?