Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

How to use listview control in userform? I can't add listview control in
toolbox. Help me. Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview control in
toolbox. Help me. Thanks


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview control in
toolbox. Help me. Thanks



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx, which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview control
in
toolbox. Help me. Thanks




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx, which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview control
in
toolbox. Help me. Thanks






  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx, which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks





  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

My computer's Windows version is M. Windows XP professional version 2002 SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx, which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks






  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

What is the project called with the form?
Have the form visible (right-click the form, view object), load the control
toolbox and right-click in the bottom bit (the empty bit) of the toolbox and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version 2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks







  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the control
toolbox and right-click in the bottom bit (the empty bit) of the toolbox and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version 2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks








  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

OK, I should have said what it the project with the form called.
Try 2 things:
In the VBE: Debug, Compile
Does that go OK, or does it fail?
If it fails then fix that first.
Also try after saving the project.

RBS


"palo" wrote in message
...
what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the
control
toolbox and right-click in the bottom bit (the empty bit) of the toolbox
and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version
2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the
list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have
set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to
C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control
toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks











  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

I have tried to debug, compile but it fail, I have tried but don't know
what's wrong with it. Do you know what I need to do to make it work?


"RB Smissaert" wrote:

OK, I should have said what it the project with the form called.
Try 2 things:
In the VBE: Debug, Compile
Does that go OK, or does it fail?
If it fails then fix that first.
Also try after saving the project.

RBS


"palo" wrote in message
...
what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the
control
toolbox and right-click in the bottom bit (the empty bit) of the toolbox
and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version
2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in the
list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have
set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to
C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control
toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add listview
control
in
toolbox. Help me. Thanks










  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

When you do Debug, Compile and it fails then normally it will tell you
what the problem is. Wasn't there any message about what made the
compile fail? Or are you saying it compiled fine, but the toolbox still
didn't do additional controls?

RBS


"palo" wrote in message
...
I have tried to debug, compile but it fail, I have tried but don't know
what's wrong with it. Do you know what I need to do to make it work?


"RB Smissaert" wrote:

OK, I should have said what it the project with the form called.
Try 2 things:
In the VBE: Debug, Compile
Does that go OK, or does it fail?
If it fails then fix that first.
Also try after saving the project.

RBS


"palo" wrote in message
...
what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the
control
toolbox and right-click in the bottom bit (the empty bit) of the
toolbox
and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version
2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in
the
list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is
MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have
set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to
C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control
toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add
listview
control
in
toolbox. Help me. Thanks











  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default About Lisview control

Compilation is fine, but the toolbox still does not do any additional
controls. Do I need to reinstall the Microsoft office?


"RB Smissaert" wrote:

When you do Debug, Compile and it fails then normally it will tell you
what the problem is. Wasn't there any message about what made the
compile fail? Or are you saying it compiled fine, but the toolbox still
didn't do additional controls?

RBS


"palo" wrote in message
...
I have tried to debug, compile but it fail, I have tried but don't know
what's wrong with it. Do you know what I need to do to make it work?


"RB Smissaert" wrote:

OK, I should have said what it the project with the form called.
Try 2 things:
In the VBE: Debug, Compile
Does that go OK, or does it fail?
If it fails then fix that first.
Also try after saving the project.

RBS


"palo" wrote in message
...
what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the
control
toolbox and right-click in the bottom bit (the empty bit) of the
toolbox
and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional version
2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in
the
list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is
MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I have
set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to
C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control
toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add
listview
control
in
toolbox. Help me. Thanks












  #14   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default About Lisview control

Are you in the VBE and is there a form in the project?
Make sure to have the form visible in the VBE and then launch the toolbox.
If you did all that then yes maybe re-install Office.

RBS


"palo" wrote in message
...
Compilation is fine, but the toolbox still does not do any additional
controls. Do I need to reinstall the Microsoft office?


"RB Smissaert" wrote:

When you do Debug, Compile and it fails then normally it will tell you
what the problem is. Wasn't there any message about what made the
compile fail? Or are you saying it compiled fine, but the toolbox still
didn't do additional controls?

RBS


"palo" wrote in message
...
I have tried to debug, compile but it fail, I have tried but don't know
what's wrong with it. Do you know what I need to do to make it work?


"RB Smissaert" wrote:

OK, I should have said what it the project with the form called.
Try 2 things:
In the VBE: Debug, Compile
Does that go OK, or does it fail?
If it fails then fix that first.
Also try after saving the project.

RBS


"palo" wrote in message
...
what do you mean by project called with this form?
if you rasking about project's, it's book1
I right-click in the bottom bit (the empty bit) of the toolbox and
click Additional controls but nothing happens.



"RB Smissaert" wrote:

What is the project called with the form?
Have the form visible (right-click the form, view object), load the
control
toolbox and right-click in the bottom bit (the empty bit) of the
toolbox
and
do
Additional controls, tick Microsoft Listview Control, version 6.0

RBS


"palo" wrote in message
...
My computer's Windows version is M. Windows XP professional
version
2002
SP2.
The MSComctl.ocx is M. Windows Common Control 6.0.
I add the reference in References-VBAProject box. And when I
click
Additional Controls in menu Tools, nothing happens.

"RB Smissaert" wrote:

Did you add the reference to the right project?
When you say: not work, do you mean the listview doesn't show in
the
list
of controls to add?
What Windows version are you on?
What is the version of the file MSComctl.ocx?

RBS


"palo" wrote in message
...
I have set a reference to MSComctl.oxc. But menu
Tools/Additionnal
Controls...not work.

"RB Smissaert" wrote:

Sorry, I posted wrong, it should be:
C:\Windows\System32\MSComctl.ocx
So, set a reference to that one and un-tick the other one.

Don't think there is a MSComctl32.ocx, but there is
MSComct2.ocx,
which
I think holds the Monthview control.

RBS


"palo" wrote in message
...
Thanks you!
In my system32, only has MSCOMCTL.OCX and COMCTL32.OCX. I
have
set
references this files, however, it's still not working.


"RB Smissaert" wrote:

You need to set a reference by doing in the VBE:
Tools, References and browse to
C:\Windows\System32\MSComctl32.ocx
The path could be different if you are not on Win XP.
After that the Listview will be available in the control
toolbox.

RBS


"palo" wrote in message
...
How to use listview control in userform? I can't add
listview
control
in
toolbox. Help me. Thanks













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
Process control chart for quality control in exel? Kara Charts and Charting in Excel 2 May 11th 10 05:45 PM
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Control disappeared problem - specifically, the Calendar Control JMMach[_2_] Excel Programming 0 December 16th 05 01:53 AM
Programatically control picture property of Image control Brassman[_5_] Excel Programming 5 May 24th 05 09:32 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM


All times are GMT +1. The time now is 01:54 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"