Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Tree View functionality..... [email protected] Excel Programming 1 March 29th 07 11:51 AM
tree view Stewart Rogers Excel Programming 1 July 22nd 04 12:58 PM
tree view control Duraiswamy Lingappan Excel Programming 1 July 20th 04 09:14 PM
tree view control Harald Staff Excel Programming 0 June 10th 04 04:07 PM
tree view control julio Excel Programming 0 June 10th 04 03:04 PM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"