Userfrom to Start Show in a Particular Cell

Dear Experts,

Would need your suggestion on my subjected Query!

I have created a Userfrom named as “CC_DE_Form”

When this from Initialize, By default I want this to be startup in “MM_Input” worksheet; Cell I2 Position (Top, Left).

Could you please help me with coding which meets above request?

Thanks & Regards,
Rajeshkumar R

You want the userform to be launched when cliking or changing cell I2 in sheet “MM_Input” or you want the cell I2 to be selected when the form has been launched ??

Clear, to do that you have to put in the code to show the userform at the end

Please Login or Register  to view this content.

Put the code sent AT THE END

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Does the sheet "MM_Input" the active one, the one shown ??
Finally you want the Userform to be placed in sheet "MM_Input" and the left top corner of the form to be in I2 ...is it ?

You can do it the difficult way like http://www.cpearson.com/Excel/FormPosition.htm

or you can use this and play around with the numbers until you get the correct position.

Please Login or Register  to view this content.

Rajeshkumar,
I was using the same code as the one proposed by bakerman2 but I got some concern when using different zoom ratio:
Just For information
PCI