[i] loop in VBA

Hello All,

I want to write a macro in Excel where i have two sheets:
Sheet 1 = Source
Sheet 2 = Form

Sheets("Source").range("B27") is the source range for other formulas.

the full macro details are as below (which i need to know where i missed)

((this macro keeps on looping and does not give the correct value))

##

Please Login or Register  to view this content.

##
Thank you all in advance.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi Shiblie and welcome to the forum (now that you have put code tags around your code)

Read http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

You should put your code in a Module instead of behind a worksheet. Behind a worksheet, it is Private.

See if this code in a module as discribed in the link above does what you want.

Please Login or Register  to view this content.

Perhaps this will work.
Keep the event behind the worksheet but the working macro in a module like the below?

Please Login or Register  to view this content.