Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi group, this is my first time here. I'll get right away to the
point. I'm trying to re-write a piece of software on Excel using the builted- in Visual Basic engine (VBA) in order to communicate to GPIB devices (instruments like spectrum analyzers and power meters). I'm trying to create my own programming language on Excel; I'll explain. On each cell, I should be able to write: A1 =gini() A2 =gfind(abc) A3 =gout(abc, "GPIB command", B3) =g* are all functions, and none of them return nothing. These functions should NOT run when I enter them on any cells (on pressing the ENTER key). Instead, it should not appear 0 (because the function was executed and returned 0), but the function name like, for example, .gini() and .gfind(abc) (note the dot). This way, I can see the commands on the worksheet, instead of the result, and the functions are not runned. Then, on the current ActiveCell, if I press ALT+(left arrow), only the function on that cell should run, and if I pressed ALT+(down arrow), it should run all commands on all cells below. Note, on the function bar I can see =gini(), but on the cell itself I should see .gini(). Pressing ALT+(left arrow), =gini() (the gini() function) should run. I'm over this problem for almost a week, and I feel frustrated with my results. Can anyone point me good directions on how to solve this efficiently? Best regards, and thank to you all in advance for reading, Marco Ferra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Excel is written in which programming language ? | Excel Discussion (Misc queries) | |||
Which language will be suitable for excel programming | Excel Programming | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) |