View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Input Box within a macro

This does not validate the input but if you need validation just reply back...

Range("A1").Value = InputBox("Enter Something")
--
HTH...

Jim Thomlinson


"McCloudK" wrote:

I would like a box to pop up while running a macro that will prompt the user
for a date or number and then take that date or number entered and place in a
specific cell on the spreadsheet.