How to put variables into the function with "invoke VBA"?

Learning Hub Academy Feedback
1

Hi all,

I am using the VB function to search the cell address in excel.
This is my program VBA:

image
image923×304 6.97 KB

Some function is ok like FindAddressOfActiveCell().
But when using a function that has variable values put in is not good.
I tried many times but failed.

image
image1073×551 26.2 KB

Please help me in learn.

Thank all.

1 Like
2

Try

findcelladdress – Entry Method Name

{“color”,“A1:B99”} — Entry Method Parameters (modify quotes for range)

3

Hi vvaidya,

i tried with quotes for range. It not work.
And i tried with another method.

image
image1092×501 31.4 KB

It still error.

4

Are you able to retrieve the parameters in the script. Keep a message box and check.

What is the error you are getting?

fyi…no quotes for brackets

image

5 Likes
5

Wow!.
Good. Sorry for not understand your help.
Untill now it work.
Many Thanks to you.

1 Like