-
I am sure you can do this, in fact I have done it before... But its monday morning and the brain is not working...
How do you configure the input box so that the user can drag over cells and the range is returned within the input box.
I am sure that you just set one of the input boxes arguments to 7 but can't quite remember
Can anyone boost my monday morning blues
Cheers
Steve
-
Got it !!
O.k., Brain is starting to function...
Forgot to put application in front and its 8 not 7 i.e.
Code:
Myrange = application.inputbox("Message","Title",Type:=8)
Just in case anyone else has the same probs
Steve
