Thanks for the correction, Gord.

Gord Dibben wrote:

Try adding a missed parenthesis at end

myNum = CLng(Application.InputBox(Prompt:="enter a number", Type:=1))

Works for me.

Gord Dibben MS Excel MVP

On Tue, 04 Nov 2008 16:25:04 -0600, Dave Peterson
wrote:

myNum = clng(application.inputbox(Prompt:="enter a number", type:=1)

--

Dave Peterson