software

Hi All

I'd like to know how you can have an arguments box on a form. I need to
select a cell range directly from a spreadsheet and would like to see
them preferably entered in a text box on a form like you get when you
create formulas with the function arguments box. If anybody has got any
ideas I would like to hear them.

Cheers,
MikeLike with a macro?

Option Explicit
sub testme()
dim myRng as range
set myrng = nothing
on error resume next
set myrng = application.inputbox(prompt:=quot;Select a range with the mousequot;, _
type:=8)
on error goto 0

if myrng is nothing then
'use hit cancel
exit sub '???
end if

'do something with the range
msgbox myrng.address(external:=true)
end sub
Greshter wrote:
gt;
gt; Hi All
gt;
gt; I'd like to know how you can have an arguments box on a form. I need to
gt; select a cell range directly from a spreadsheet and would like to see
gt; them preferably entered in a text box on a form like you get when you
gt; create formulas with the function arguments box. If anybody has got any
gt; ideas I would like to hear them.
gt;
gt; Cheers,
gt; Mike

--

Dave Peterson

Again Dave that's just what I'm after ... I'll have to start sending
you a cut of my wages.

Cheers,
MikeWoohoo!!!

I'm in the money!

Greshter wrote:
gt;
gt; Again Dave that's just what I'm after ... I'll have to start sending
gt; you a cut of my wages.
gt;
gt; Cheers,
gt; Mike

--

Dave Peterson