Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Properties

I have added an ImageList and Treeview to a userform. I would normally right click on the ImageList to access the custom properties page and add the required icons. However, when I right click on the control the Custom Properties menu is not displayed. Does anyone know why this is occurring?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Custom Properties

David,

did you check there's a valid reference to the control's library..?
.. depending on version the ref s/b like
Microsoft Windows Common Controls 6.0 (SP6)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

I have added an ImageList and Treeview to a userform. I would normally
right click on the ImageList to access the custom properties page and
add the required icons. However, when I right click on the control the
Custom Properties menu is not displayed. Does anyone know why this is
occurring?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Custom Properties

hmm...

you're not confusing VB6 with VBA?

in VB6 you go straight to the properties bag.
in VBA you need to click (Custom) in the Properties pane.


keepITcool


?B?RGF2aWRX?= wrote:

Hi,

Yes, the library Microsoft Windows Common Controls 6.0 is referenced.
To make sure, I've also re-registered the library in \\System32.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Custom Properties

as i said..

in VBA you should get the Properties option in the context popup.

if you click that if sets the focus to the properties window and selects
the control. (and opens the prop window it necessary)

then in the properties window ..
select the line with (custom)
double click THAT.

FAIK that's how it's always worked in VBA...
(still think your confused with VB6)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

No that's just the problem, when I right click I should have the
'Custom' option but I only have the generic 'Properties' option. All
very odd!

"keepITcool" wrote:

hmm...

you're not confusing VB6 with VBA?

in VB6 you go straight to the properties bag.
in VBA you need to click (Custom) in the Properties pane.


keepITcool


?B?RGF2aWRX?= wrote:

Hi,

Yes, the library Microsoft Windows Common Controls 6.0 is
referenced. To make sure, I've also re-registered the library in
\\System32.




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Properties

How embarrasing! You're right, got it now! Thank you very much for your help!!!

"keepITcool" wrote:

as i said..

in VBA you should get the Properties option in the context popup.

if you click that if sets the focus to the properties window and selects
the control. (and opens the prop window it necessary)

then in the properties window ..
select the line with (custom)
double click THAT.

FAIK that's how it's always worked in VBA...
(still think your confused with VB6)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

No that's just the problem, when I right click I should have the
'Custom' option but I only have the generic 'Properties' option. All
very odd!

"keepITcool" wrote:

hmm...

you're not confusing VB6 with VBA?

in VB6 you go straight to the properties bag.
in VBA you need to click (Custom) in the Properties pane.


keepITcool


?B?RGF2aWRX?= wrote:

Hi,

Yes, the library Microsoft Windows Common Controls 6.0 is
referenced. To make sure, I've also re-registered the library in
\\System32.







  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Properties

Just one other question...........! Now that I've populated my ImageList I want to bind it to my TreeView control, however, when I access the ImageList combo on the Property page for the TreeView my ImageList is not listed, it has only one entry in the combo, the default <None?!


"DavidW" wrote:

How embarrasing! You're right, got it now! Thank you very much for your help!!!

"keepITcool" wrote:

as i said..

in VBA you should get the Properties option in the context popup.

if you click that if sets the focus to the properties window and selects
the control. (and opens the prop window it necessary)

then in the properties window ..
select the line with (custom)
double click THAT.

FAIK that's how it's always worked in VBA...
(still think your confused with VB6)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

No that's just the problem, when I right click I should have the
'Custom' option but I only have the generic 'Properties' option. All
very odd!

"keepITcool" wrote:

hmm...

you're not confusing VB6 with VBA?

in VB6 you go straight to the properties bag.
in VBA you need to click (Custom) in the Properties pane.


keepITcool


?B?RGF2aWRX?= wrote:

Hi,

Yes, the library Microsoft Windows Common Controls 6.0 is
referenced. To make sure, I've also re-registered the library in
\\System32.





  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Properties

Just one other question...........! Now that I've populated my ImageList I want to bind it to my TreeView control, however, when I access the ImageList combo on the Property page for the TreeView my ImageList is not listed, it has only one entry in the combo, the default <None?!



"keepITcool" wrote:

as i said..

in VBA you should get the Properties option in the context popup.

if you click that if sets the focus to the properties window and selects
the control. (and opens the prop window it necessary)

then in the properties window ..
select the line with (custom)
double click THAT.

FAIK that's how it's always worked in VBA...
(still think your confused with VB6)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

No that's just the problem, when I right click I should have the
'Custom' option but I only have the generic 'Properties' option. All
very odd!

"keepITcool" wrote:

hmm...

you're not confusing VB6 with VBA?

in VB6 you go straight to the properties bag.
in VBA you need to click (Custom) in the Properties pane.


keepITcool


?B?RGF2aWRX?= wrote:

Hi,

Yes, the library Microsoft Windows Common Controls 6.0 is
referenced. To make sure, I've also re-registered the library in
\\System32.





  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Custom Properties

David, you'll have to bind at runtime

assuming the listimage contains an image with the key "logo"
this works for me:

Private Sub UserForm_Initialize()
With TreeView1
Set .ImageList = Me.ImageList1
.Nodes.Add , , "node1", "oops", "logo"
End With
End Sub



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:


Just one other question...........! Now that I've populated my
ImageList I want to bind it to my TreeView control, however, when I
access the ImageList combo on the Property page for the TreeView my
ImageList is not listed, it has only one entry in the combo, the
default <None?!


  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Custom Properties

Guess what....I'm now getting an 'Invalid Object' error message! Here's the code I've added:

With trvMain
Set .ImageList = Me.ImageList1
End With

Help!!?!!

"keepITcool" wrote:

David, you'll have to bind at runtime

assuming the listimage contains an image with the key "logo"
this works for me:

Private Sub UserForm_Initialize()
With TreeView1
Set .ImageList = Me.ImageList1
.Nodes.Add , , "node1", "oops", "logo"
End With
End Sub



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:


Just one other question...........! Now that I've populated my
ImageList I want to bind it to my TreeView control, however, when I
access the ImageList combo on the Property page for the TreeView my
ImageList is not listed, it has only one entry in the combo, the
default <None?!



  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Custom Properties

the ME keyword will only work in object modules.
(sheet code, userform etc)

so it's important to know WHERE your code is located

does trvMain exist?
is it a variable or a control?
does imageList1 exist?

if it's in a userform.. WHEN do you load it?
e.g. in which event..
has the form been initialized
has the form been activated
has the treeview been populated ??


hard to debug.. from a 3 line snippet :(


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:

Guess what....I'm now getting an 'Invalid Object' error message!
Here's the code I've added:

With trvMain
Set .ImageList = Me.ImageList1
End With

Help!!?!!

"keepITcool" wrote:

David, you'll have to bind at runtime

assuming the listimage contains an image with the key "logo"
this works for me:

Private Sub UserForm_Initialize()
With TreeView1
Set .ImageList = Me.ImageList1
.Nodes.Add , , "node1", "oops", "logo"
End With
End Sub



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGF2aWRX?= wrote:


Just one other question...........! Now that I've populated my
ImageList I want to bind it to my TreeView control, however, when I
access the ImageList combo on the Property page for the TreeView my
ImageList is not listed, it has only one entry in the combo, the
default <None?!





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
Custom Spreadsheet Properties Rod Excel Worksheet Functions 0 February 23rd 10 07:08 PM
Custom File Properties Ade Hodgetts Excel Discussion (Misc queries) 2 April 2nd 08 10:34 PM
Custom File Properties jujuwillis Excel Discussion (Misc queries) 1 August 1st 05 04:18 PM
Spell Checking Custom Properties Jezebel[_2_] Excel Programming 0 June 15th 04 12:47 PM
Accessing custom document properties Tim Haley Excel Programming 2 September 6th 03 02:34 AM


All times are GMT +1. The time now is 10:31 AM.

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

About Us

"It's about Microsoft Excel"