RefEdit control by 3rd party or other option?

[T. Erkson]

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.aspx?scid=kb;en-us;281542

Suggestions/recommendations on obtaining this functionality another way?

Toby Erkson
Windows XP, Excel 2003

 

[Tom Ogilvy]

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)

 

[T. Erkson]

Thanks Tom!

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)