Asking array as input in UDF
up vote
0
down vote
favorite
I am new to VBA and I want to create as user defined function using few parameters which are:
an array having 1 row and n column
an array having n rows and m columns * N & M are variables ranging from 0 to say 32
an integer value
And function multiplies all three to give an output
Function VArray( Aarray() as variant, Barray() as variant, C as long) as Variant
I want to know syntax for asking input for the two arrays from users so that function may be executed.
vba excel-vba
add a comment |
up vote
0
down vote
favorite
I am new to VBA and I want to create as user defined function using few parameters which are:
an array having 1 row and n column
an array having n rows and m columns * N & M are variables ranging from 0 to say 32
an integer value
And function multiplies all three to give an output
Function VArray( Aarray() as variant, Barray() as variant, C as long) as Variant
I want to know syntax for asking input for the two arrays from users so that function may be executed.
vba excel-vba
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am new to VBA and I want to create as user defined function using few parameters which are:
an array having 1 row and n column
an array having n rows and m columns * N & M are variables ranging from 0 to say 32
an integer value
And function multiplies all three to give an output
Function VArray( Aarray() as variant, Barray() as variant, C as long) as Variant
I want to know syntax for asking input for the two arrays from users so that function may be executed.
vba excel-vba
I am new to VBA and I want to create as user defined function using few parameters which are:
an array having 1 row and n column
an array having n rows and m columns * N & M are variables ranging from 0 to say 32
an integer value
And function multiplies all three to give an output
Function VArray( Aarray() as variant, Barray() as variant, C as long) as Variant
I want to know syntax for asking input for the two arrays from users so that function may be executed.
vba excel-vba
vba excel-vba
edited Nov 8 at 4:52
K.Dᴀᴠɪs
6,176112140
6,176112140
asked Nov 8 at 4:49
Kumar Atul
12
12
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53
add a comment |
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53201707%2fasking-array-as-input-in-udf%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did you investigate something yourself?
– Jeroen Heier
Nov 8 at 4:54
Seems like it would be simplest to ask your users to select ranges on a worksheet as inputs
– Tim Williams
Nov 8 at 5:03
Any links where I could find some material on same
– Kumar Atul
Nov 8 at 5:54
Create your UDF and the user can call it from a worksheet - just like any other Excel function.
– Tim Williams
Nov 8 at 6:53