Range("A1").Value = InputBox("What is the value for cell A1?")
--
- K Dales


"Robert_DubYa" wrote:

I good with VB in access but have never used in excel.

I would like to create a button to change cell data using an input box. I
know how to use the input box but I don't know how to make the cell = to the
variable

please help

thanks,
Robert