This places Text into the cell.

Sub Get Information()
Information = InputBox ("Enter Information about ")
Range ("A1") = Information

End Sub :)
--
William<"M"




"Tbram" wrote:

I just can't figure out how to create a simple input form that will put the
data into the worksheet for simple use for someone that doesn't know excel
well. Within that form i need to use drop down menus that I created using
Data Validation. I don't know why I can't figure out how to make this work,
like in Acess
Thanks