that'll do...thanks



Don Guillett wrote:
try

Sub msgboxincell()
ans = InputBox("enter data")
Range("d14").Value = ans
End Sub

I'm guessing there is a simple way to do this, but i cant figure it out
and
[quoted text clipped - 5 lines]
or
box nearby the button. thanks in advance for help...

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1