VBA Multiply Function & Sub Procedure to Show Result

I have Created a Function to Multiply & a Sub to Show Result In MsgBox

Please Login or Register  to view this content.

It works fine when I State N1 as 132 & N2 as 456.

However i want N1 & N2 to be extracted from the Worksheet named Prices in a Workbook Named "Basic Beginers Codes".

Where N1 lies in Cell A2 & N2 Lies in Cell A3.

What changes should I make to the code?

Hi, Deep,

Please Login or Register  to view this content.

I assumed the extension for the workbook to be xlsm, alter if needed. If itīs the workbook with the code it may be referenced to as ThisWorkbook.

Ciao,
Holger

I am unable to execute the code yet.

Can you precisely tell me where to add the code?

Or can you please state the whole code that i can copy?

Hi, Deep,

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

although I wonder why anybody would need an UDF for multiplying.

Please Login or Register  to view this content.

Ciao,
Holger

Hey!!

I replaced as Instructed, but it still isnt working -

Below is the new code -

Please Login or Register  to view this content.

Hi, Deep,

but it still isnt working

Workbook not open, code not started from the VBE by eiter F8 or F5, any error message, not in a normal module? If you post just that information itīs very hard to find the reason for the "not working".

Ciao,
Holger

@Holger

I am attaching the Workbook for better understanding.

Hi, Deep,

we humans can calculate and evaluate on Letters but if you advice Excel to work with Doubles there will be no match if you assign Letters unless you convert them to Doubles.

Where N1 lies in Cell A2 & N2 Lies in Cell A3

A2 is A, A3 is B, the prices are listed in Column B so you should change the code to reference Column B instead of A:

Please Login or Register  to view this content.

Ciao,
Holger

Problem Solved!

Thank You For the Help!

Marking the thread as Solved!