Using an Inputbox

[NathanW]

I've used inputboxes in the past and I do not know why I am having so much trouble now, but here is what I have:

Public StartCell As Variant
StartCell = Application.InputBox(Msg, "Select a Cell", Type:=8)
Range(StartCell).Activate

I am getting the error Run-time error '1004': Method 'Range' of object '_Global' failed.

Someone please help me!

 

[JoeMo]

That made it work! Thank you guys so much for your help and persistence. Any idea why it took all that error handling to make it work? I don't understand why this had to be so complicated =P

Did you try removing Msg from this line?
InputBox(Msg, "Select a cell", type:= 8)

Btw : the error handling is one way to deal with a user who clicks cancel when the input box appears. Without it, Application.InputBox will throw an error.

 

[NathanW]

I actually was able to leave Msg in the InputBox code, the error handling resolved the problem. Thank you again!