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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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