formula to VBA Code

[jessica0007]

My greetings to all the experts,
I need to convert table and formula to VBA. I do not know much about VBA, I will not be able to explain properly but after seeing Excel you will understand.

[mehmetcik]

The simplest way is to use the Macro recorder.

Start the recorder

select every cell in turn and select the formula bar and press enter.

Once you have done this for all cells stop the macro recorder

Then tidy up your recorded macro.

[jessica0007]

Need to change the whole formula with VBA code, I already know that it is possible with small code like ex. Range("H3").Formula = "=
But I do not want that.

[mehmetcik]

Hi Jessica.

Your thread Title threw me.

Your title should have been something like: Convert Index/Match formula into a User Defined Function.

Administrative Note:


Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)


If you paste the following code into a macro module. then the formula =test(640,606) 0r =test(f3, g3) will return your value. [ I hope ].

Please Login or Register  to view this content.

[jessica0007]

I'm impressed!! it works perfectly!
thank you very much!

[jessica0007]

mehmetcik,

I will focus on my thread title next time as well as I will request expert instead of Demand. Forgive me for my words.

thank you