command button 1 creates my textbox (named textbox1 according to the
properties window). Adding - TextBox1.value = sheet2.range("j7").value
- generates run-time error '424', object required.

command button 2 = TextBox1.cut


--
by1612
------------------------------------------------------------------------
by1612's Profile: http://www.excelforum.com/member.php...fo&userid=8611
View this thread: http://www.excelforum.com/showthread...hreadid=555976