MontySharpei
09-18-2008, 05:18 AM
Hello,
attached is a sheet that when button 1 is pressed a userform is brought up. When text is added and submit is pressed the text is copied to cell A1. When the cancel button is pressed the userform is closed.
Now the bit where i'm stuck!
I want to press the remove button on the userform and what this will do is remove button 1 from the sheet, leaving any text that was previously submitted still there ?
anybody any ideas on the code required to do this ??
Thanks in advance....
attached is a sheet that when button 1 is pressed a userform is brought up. When text is added and submit is pressed the text is copied to cell A1. When the cancel button is pressed the userform is closed.
Now the bit where i'm stuck!
I want to press the remove button on the userform and what this will do is remove button 1 from the sheet, leaving any text that was previously submitted still there ?
anybody any ideas on the code required to do this ??
Thanks in advance....