Introduction

Lennart vanB

Forums

Hi,
 
I am an business controller, not a programmer,- so forgive me this question -  but I feel the use of idea will have more strength using dialogue boxes.
the video on dialogue boxes expects a general/ basic understanding of writing code.
 
What would be a good starting point to get this understanding?
 
thanks!
 
 

Brian Element Mon, 07/14/2014 - 10:13

Hello Lennart and welcome to the site.

The code that is used in IDEAScript is Visual Basic for Applications which is the same macro language used for Excel, Word, etc.

I use a lot of dialog boxes in my scripts so you can look through the scripts and see what I have done.  Also if I have an idea of what you might be looking for I could put together an example that you could use as a starting point.

Brian

Lennart vanB Tue, 07/15/2014 - 02:15

Thanks Brian, I already feel welcome :)
VBA, ok. I tried to avoid that for a long time....
The idea is really simple. For my sales ledger lines I would like to have a dialogue asking for the month (numeric) and whether cumulative or per month. perhaps a dropbox with the month and a button to choose from "=" or "=<" 
I'll dive into the code too.
Thanks and regards from Holland.
Lennart

Brian Element Tue, 07/15/2014 - 07:38

Sorry, Lennart, if you want to learn IDEAScripting to its potential you are now going to have to dive into learning VBA, no choice there.

Let me know if you need any help creating the dialog or if you want to try something and post that would be great.

Thanks

Brian

Bibin Tue, 02/16/2016 - 23:07

Hey Brian,
Is there a way that we can calculate the running total/ Cumulative total based on one amount column?
If not, Can we develop a macro to run the same?
Thanks,
Bibin

Brian Element Wed, 02/17/2016 - 07:42

Hi Bibin,

I know there is a script like that already exists at IDEA but I can't seem to find it right now.  It is not a hard script to create so when I have a few minutes I will put one together.

Brian