How do I get this to place information onto a work sheet called committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub


Thanks
Greg