RefEdit control by 3rd party or other option?

I'm working with a developer and we need to use the RefEdit control (.NET
application) but it seems that it's not supported in the COM Add-In:
http://support.microsoft.com/default...b;en-us;281542

Suggestions/recommendations on obtaining this functionality another way?

Toby Erkson
Windows XP, Excel 2003

If there is a 3rd party control that does that, I am not aware of one.

within excel you can use

Dim rng as Range
On Error Resume Next
set rng = Application.InputBox("Select cell with mouse",type:=8)
On Error goto 0
if rng is nothing then
msgbox "You clicked cancel"
exit sub
end if

msgbox "range selected is " & rng.Address(0,0,,true)

--
Regards,
Tom Ogilvy

"T. Erkson" <[email protected]> wrote in message
news:ODCGE%[email protected]...
> I'm working with a developer and we need to use the RefEdit control (.NET
> application) but it seems that it's not supported in the COM Add-In:
> http://support.microsoft.com/default...b;en-us;281542
>
> Suggestions/recommendations on obtaining this functionality another way?
>
> Toby Erkson
> Windows XP, Excel 2003
>
>

Thanks Tom!

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> If there is a 3rd party control that does that, I am not aware of one.
>
> within excel you can use
>
> Dim rng as Range
> On Error Resume Next
> set rng = Application.InputBox("Select cell with mouse",type:=8)
> On Error goto 0
> if rng is nothing then
> msgbox "You clicked cancel"
> exit sub
> end if
>
> msgbox "range selected is " & rng.Address(0,0,,true)
>
> --
> Regards,
> Tom Ogilvy
>
> "T. Erkson" <[email protected]> wrote in message
> news:ODCGE%[email protected]...
> > I'm working with a developer and we need to use the RefEdit control
(.NET
> > application) but it seems that it's not supported in the COM Add-In:
> > http://support.microsoft.com/default...b;en-us;281542
> >
> > Suggestions/recommendations on obtaining this functionality another way?
> >
> > Toby Erkson
> > Windows XP, Excel 2003
> >
> >
>
>