OT: VBA (Excel 2000) help

["Mark Harrison \(Yahoo!\)" <mph@xxxxxxxxxxxxxxx>]

Hi all,

Here's a question for you...

I've got some fairly complex VBA at the moment, but users have issues with
the complexity of some of the functions.

I'm trying to write a form that basically does the same job as the
"function wizard".

Most of it is now working, as in I have up a form that lists all the
arguments, and gives a box into which stuff can be typed...

BUT

The thing I can't work out how to do is the "pick cells" box that
the function wizard uses at the right of each text entry box to allow the
user to go off and pick a cell/range as appropriate.

Anyone done this?


BTW - in an ideal world, I'd just use the function wizard for this, but it
has a limitation that a function can only take up to 20 arguments, and some
of them need to take more :-(

[Non-text portions of this message have been removed]