View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default window to enter a number

Use an Inputbox

"steven" wrote:

Hello, again an easy one.

Instead of having this code ActiveCell.FormulaR1C1 = "2" (that enters 2 in
a cell) how to I have a box (ie window ) pop up that askes me each time which
number to enter?

thank you.

Steven.