I have an Excel 2007 Add-In that displays an Actions Pane. The pane is pretty simple, two text boxes and two buttons. When I click one button I can insert the text from the boxes into the sheet. I can click the other button I can can take data out of the cells and insert it into the text boxes.
Here is my problem, when I update the my cells I want the Actions Pane to update automatically. I can not find any way from within VBA (Excel) to reference the text boxes on the pane. Is that even possible? The best I can do is set a timer on the pane to update every X seconds.
Thanks,
sabloomer
Here is my problem, when I update the my cells I want the Actions Pane to update automatically. I can not find any way from within VBA (Excel) to reference the text boxes on the pane. Is that even possible? The best I can do is set a timer on the pane to update every X seconds.
Thanks,
sabloomer