Not just 100% sure just what you want this input box for. Is it supposed to
place a value into a cell or just what. Input boxes are a VB thing but excel
does have some different forms you can launch without code.

Try Data - Form for inputting tabular data that copies formuals down with
the entries.

Otherwise Data - validation can allow you to add context to a cell which
tells the user what type of data to eneter and then validate that data.

HTH

"jon & Rudy" wrote:

How do you create an inputbox without writing VBA code. We are searching for
a dialog box.