Vba learning

[snjpverma]

below is my code which stops at the red word and gives compile error as shown below.

[Sub inputbox()
Dim myvalue As Variant
myvalue = [COLOR=#FF0000]inputbox[/COLOR]("Give me some input")
Range("a1").Value = myvalue
End Sub
/CODE]
[B]
Compile error: Wrong number of arguments or invalid property assignment[/B]

 

[FormR]

Hi, don't use "InputBox" for the name of your sub, or any other VBA keywords.

Use "Sub MyInputBox" for example instead.

 

[snjpverma]

wow, you nailed it FormR..

your suggestion did the trick