de nada

Bloody news readers always leaving things out<g


Gord

On Tue, 04 Nov 2008 17:31:47 -0600, Dave Peterson
wrote:

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)