Thread: Call popup box with pre-programmed input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Call popup box with pre-programmed input
newnum = InputBox("Lowest allowed?", "Variation", 0)


Gord Dibben MS Excel MVP

On Sat, 12 Sep 2009 15:15:11 +0100, Colin Hayes
wrote:


HI

I use this line in my macro to display a popup

newnum = InputBox("Lowest allowed?", "Variation")


This waits for input with a flashing cursor.

Is it possible to change the code so that a zero is displayed while it
waits for input?

Grateful for any assistance.


Reply With QuoteReply With Quote