Yet another basic problem
Hi,
I have a very basic question concerning the VBA code in excel. I would like to know how can I decide into which cell does the excel enter the answer of my function? For example, if my function goes as follows, function test(s+b) test=s+b end function so how can i tell the program that the result of the function should be shown automatically in cell e.g "C2"? Regards, Vepa |
Yet another basic problem
Vepa,
First, to write your function, you need to separate the arguments: Public function test (arg1 as range, arg2 as range) ....etc Then you have to enter the function and arguments in cell C2. =test(A1,C14) same as you do for any other Excel WS formula. NickHK "Vepa" wrote in message ... Hi, I have a very basic question concerning the VBA code in excel. I would like to know how can I decide into which cell does the excel enter the answer of my function? For example, if my function goes as follows, function test(s+b) test=s+b end function so how can i tell the program that the result of the function should be shown automatically in cell e.g "C2"? Regards, Vepa |
Yet another basic problem
So is it impossible for me to do, for example, a result table where all the
results of calculations involved in the function could be shown automatically? With this I mean that I donÂīt have to do everything manually by using normal excel functions. "NickHK" kirjoitti: Vepa, First, to write your function, you need to separate the arguments: Public function test (arg1 as range, arg2 as range) ....etc Then you have to enter the function and arguments in cell C2. =test(A1,C14) same as you do for any other Excel WS formula. NickHK "Vepa" wrote in message ... Hi, I have a very basic question concerning the VBA code in excel. I would like to know how can I decide into which cell does the excel enter the answer of my function? For example, if my function goes as follows, function test(s+b) test=s+b end function so how can i tell the program that the result of the function should be shown automatically in cell e.g "C2"? Regards, Vepa |
Yet another basic problem
<to do, for example, a result table
Look at the DataTable command Or try to explain a bit more clearly what you are trying to achieve, so we can suggest alternative ways to do that. -- Kind regards, Niek Otten "Vepa" wrote in message ... So is it impossible for me to do, for example, a result table where all the results of calculations involved in the function could be shown automatically? With this I mean that I donīt have to do everything manually by using normal excel functions. "NickHK" kirjoitti: Vepa, First, to write your function, you need to separate the arguments: Public function test (arg1 as range, arg2 as range) ....etc Then you have to enter the function and arguments in cell C2. =test(A1,C14) same as you do for any other Excel WS formula. NickHK "Vepa" wrote in message ... Hi, I have a very basic question concerning the VBA code in excel. I would like to know how can I decide into which cell does the excel enter the answer of my function? For example, if my function goes as follows, function test(s+b) test=s+b end function so how can i tell the program that the result of the function should be shown automatically in cell e.g "C2"? Regards, Vepa |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com