Pass through Query - prompt for parameter?

[Scotbot]

Hi, I have this pass through query:

USE Raptor
DECLARE     @return_value int
DECLARE @ActivityNumber int
EXEC dbo.SWANSTAResults @ActivityNumber = '140040014'

Which works fine.

I would like it to prompt for the value of @ActivityNumber but I'm not sure how to achieve this - is there any way to do it without VBA?

I can use VBA if I absolutely must but would like to find out if it's possible without first...

Thanks, Scott.