Include function arguments (like range finder) in Add-in

R

royend

Hi.
Is it possible to include the range finder (found for instance as a function
arguments in Excel) in your own custom Add-ins?

I am using Visual Studio 2008 and programming for Excel 2003.

Looking forward to your reply.
 
H

Hansueli

Hi,

With (EXCEL)
Application.InputBox(Prompt,Title,Default,Left,Top,HelpFile,HelpContexId,Type)
where Type=8 allows you to select a range from the active sheet.

Rgds
 
Top