![]() |
Tree View; selecting and pasting data to cell
Hi,
I have built 2 macrosets to create 2 separate TreeViews. With first one I am able to select cell within the sheet and paste selected info from TreeView1. After that I added second TreeView and now I am able to open both of them, BUT I am not able to select any cells within the sheet. What do I need to do to enable cell selection? It works with the first one and I have not made any changes to that form neither to macros. BR MakeLei |
Tree View; selecting and pasting data to cell
The treeviews are on the worksheet ?
If on userforms, are the userforms shown with vbModeless ? NickHK "MakeLei" wrote in message ... Hi, I have built 2 macrosets to create 2 separate TreeViews. With first one I am able to select cell within the sheet and paste selected info from TreeView1. After that I added second TreeView and now I am able to open both of them, BUT I am not able to select any cells within the sheet. What do I need to do to enable cell selection? It works with the first one and I have not made any changes to that form neither to macros. BR MakeLei |
Tree View; selecting and pasting data to cell
Hi NickHK,
Thanks for your fast reply! This resolved my proplem and saved a LOT of my time - thanks. BR MakeLei "NickHK" wrote: The treeviews are on the worksheet ? If on userforms, are the userforms shown with vbModeless ? NickHK "MakeLei" wrote in message ... Hi, I have built 2 macrosets to create 2 separate TreeViews. With first one I am able to select cell within the sheet and paste selected info from TreeView1. After that I added second TreeView and now I am able to open both of them, BUT I am not able to select any cells within the sheet. What do I need to do to enable cell selection? It works with the first one and I have not made any changes to that form neither to macros. BR MakeLei |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com