Excel Range Edit Box

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

Excel Range Edit Box
Need a way to select a range from an Excel Pane and store as address 
Henrik Danford-Klein




Posts: 19
Joined: 2008-07-22
I have just started using Excel panes. Any suggestions on how to create an Excel Range Edit box in VCL? Am I missing something obvious?

The post below shows such a box (called Insertion range in the example). But then this appears to be .Net version of the Adduin Express.

https://www.add-in-express.com/creating-addins-blog/2013/10/08/creating-custom-task-panes-excel/

Thanks!
Posted 10 May, 2023 06:44:04 Top
Henrik Danford-Klein




Posts: 19
Joined: 2008-07-22
Changed my search slightly and may have found the answer

https://www.add-in-express.com/forum/read.php?FID=1&TID=12636

Any other suggestions would be appreciated...

Sorry about the double post - can't figure out how to delete the second one...
Posted 10 May, 2023 07:42:03 Top
Andrei Smolin


Add-in Express team


Posts: 18782
Joined: 2006-05-11
Hello Henrik,

No suggestions, sorry. You can google for newer ideas.

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 11 May, 2023 13:25:15 Top
Henrik Danford-Klein




Posts: 19
Joined: 2008-07-22
Thanks Andrei - did some searching but found nothing new since your older post.

Right now I have a temp solution where I have a speed button next to an edit box. When you click the speed button I grab the address of the current selection if more than one cell, and otherwise it pops up the Excel Input box type 8. Not great but seems to work well enough for now.

I can probably capture changes to the selection if I am in the edit box, and update the address accordingly, but haven't tried that yet.
Posted 11 May, 2023 13:56:28 Top
Andrei Smolin


Add-in Express team


Posts: 18782
Joined: 2006-05-11
Thank you!

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 12 May, 2023 04:09:42 Top