Couldnt find in search

[brownti via OfficeKB.com]

I'm guessing there is a simple way to do this, but i cant figure it out and
couldnt find anything in the search. i have a macro that fires an input box
when a button is clicked and i would for whatever is typed in the input box
to do what it is supposed to do, but to also show what is typed in a cell or
box nearby the button. thanks in advance for help...

 

[Don Guillett]

try

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

 

[brownti via OfficeKB.com]

that'll do...thanks

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...