VLOOKUP formula converted to VBA formula

[jimmisavage]

Hey everyone.
I have a conversion table and a formula working to give me a conversion rate based on dropdown lists. This formula was always intended to work on a userform but i wanted to test my formula before trying it in the userform.

=VLOOKUP(Conversions!F19,Conversions!A2:H8,MATCH(Conversions!E19,Conversions!A1:H1,0),0)*Conversions!G20

I have changed the formula to represent what is needed in the userform. The formula outcome would be shown in TextBox50

=VLOOKUP(ComboBox61,Conversions!A2:H8,MATCH(ComboBox62,Conversions!A1:H1,0),0)*TextBox68

How do I fully convert this formula to work inside a userform

 

[MisterProzilla]

To use worksheet formulae within VBA, use this layout, replacing the Arg1/2/3 with the vlookup syntax

Application.WorksheetFunction.VLOOKUP([Arg1],[Arg2],[Arg3])

so for your ComboBoxes and TextBoxes you may need to specify that it's their .value property that you're referring to, and I think you'll need to enter application.worksheetfunction. before the MATCH function too.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1216222-formula-to-vba.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.