Excel Task Pane: Capturing a Range for Wizard

Add-in Express™ Support Service
That's what is more important than anything else

Excel Task Pane: Capturing a Range for Wizard
How do I capture a selection range for a wizard? 
George Spears




Posts: 79
 Joined: 2010-05-06
Hello,

Delphi XE6. For Excel, I am writing a wizard which will run in a task pane for Excel. The user will choose an option in my wizard, and then I will ask "What is the column or row or range of data?" depending on the option they want in the wizard. My wizard will have an Edit box which will show what they have selected. How do I fill it in?

For example, they choose a Radio button which says "Process Range". Below that, there will be an edit box which shows the range they will be processing. They could type in B7:C30, or they could go to the spreadsheet and just select that Range. What is the proper way to capture that selection? (Keep in mind, at times it may be a row, a column, or a selection). As soon as they select it, I need to fill in the edit box in my Wizard.

Thanks
George S
Posted 28 Aug, 2014 15:22:21 Top
Andrei Smolin


Add-in Express team


Posts: 18828
 Joined: 2006-05-11
Hello George,

You can google for "refedit replacement". This returns .NET code mostly; you can translate it to Delphi:
- http://blogs.msdn.com/b/gabhan_berry/archive/2008/06/12/net-refedit-control.aspx
- http://www.codeproject.com/KB/selection/RefEditControl.aspx
- http://www.codeproject.com/Articles/34425/VS-NET-Excel-Addin-Refedit-Control

See also http://stackoverflow.com/questions/101673/alternative-to-excels-refedit-control-that-can-be-used-outside-of-vba.


Andrei Smolin
Add-in Express Team Leader
Posted 29 Aug, 2014 01:35:14 Top