Changing texbox of an inactive worksheet from active worksheet

[go-fish]

Hi

I want to write a code for changing Excel textbox value in an inactive worksheet based on value of cell A1 in the active sheet. Both active and inactive worksheet are in the same workbook. Activesheet is Sheet1 and inactivesheet is Sheet2. Code has to be in written in sheet1 module.

Can anyone please suggest a simple code?

Thanks