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

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

try

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

--
Don Guillett
SalesAid Software

"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6d8cef72692e2@uwe...
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...

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

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