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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocomplete Custom Functions and functions arguments 1
arguments not working with function 5
connetct own help file in excelVBA function addina 0
add-in not showing in function list in Excel 2
select function arguments in runtime 1
Excel Add in - VSTO on Pocket PC/Windows CE 0
How do you document a function (like built in functions) in VBA? 1
Include help for a user defined function written in C# 4

Top