View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Couldnt find in search

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