Inputbox and pass values to a formula in an another Workbook

[stakar]

At first, i want to create this in a cell e.g. 'D3'

IF($A3="";"";IF(OR(C3=1;C3=12;C3=18;C3=40);1;0))
The formula is locating in the cell D3, workbook A, worksheet 1

But
i want the cell values to be inserted from the user using an inputbox, that he must insert something like this

14.5.12.45.1 etc

The inputbox will appears when a command_button clicks
and it is lockated in workbook B, worksheet 1

So
The above values would be the values for each 'C3=' for the formula
So, using the inserted by the user values, the formula would be

IF($A3="";"";IF(OR(C3=14;C3=5;C3=12;C3=45;C3=1);1;0))

Hope you understand
Thanks in advance
Stathis

[kskinne]

why not just return the values you enter in your input box to cells in Workbook B, and then reference those same cells in your formula in Workbook A?


kevin

[stakar]

Ok
I find the solutiion!!

Thanks for your replay