VB Code to put formula in cell if changes in certain cell

[rizmomin]

Hello:

Please refer to attached file.

I have a dropdownlist is cell A1.
I need VB Code to do the following.

Once i complete selecting the value in cell A1 then need formula in cll D3 = C3

Let me know if you have any questions.
Thanks.
Riz

[Glenn Kennedy]

Why use VBA???

Try this:

=IF(B3="","",$A$1)

i removed the code as it seemed to be faulty (as well as unnecessary).

[rizmomin]

Hello Glenn:

I think there is misunderstanding.
I need formula in cell once i change the selection from cell A1.
D3 "= C3"
D4 "= C4"

My above requirement is for some special purpose in my project.

Please let me know if you have any questions.
Thanks.

Riz

[Glenn Kennedy]

Sorry, but I haven't a clue what you want!!

[sintek]

Is this what you are wanting to achieve???

In sheet module...

Please Login or Register  to view this content.