ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tree View; selecting and pasting data to cell (https://www.excelbanter.com/excel-programming/391363-tree-view%3B-selecting-pasting-data-cell.html)

MakeLei

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

NickHK

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




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