Hi,

I have a userform call frmGraph, and currently in my excel application I am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll, and this
particular line is giving me the error object not found. Preceding it with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Have a look at the following article:

http://support.microsoft.com/default...;en-us;Q194611

Regards,

Alasdair Stirling

"Mangesh Yadav" wrote:

Hi,

I have a userform call frmGraph, and currently in my excel application I am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll, and this
particular line is giving me the error object not found. Preceding it with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Hi Alasdair,

Thanks for the response.

Infact my problem does not relate much to the VB dll. Its rather basic. I
want to know what is the parent of UserForm1.UserForm_Initialize

or starting from ThisWorkbook and using intellisense, how can one arrive at
UserForm1.UserForm_Initialize

Something like:
ThisWorkbook.SOMETHING.SOMETHING.UserForm1.UserFor m_Initialize



Mangesh


"Alasdair Stirling" wrote in
message ...
Have a look at the following article:

http://support.microsoft.com/default...;en-us;Q194611

Regards,

Alasdair Stirling

"Mangesh Yadav" wrote:

Hi,

I have a userform call frmGraph, and currently in my excel application I
am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll, and this
particular line is giving me the error object not found. Preceding it
with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Anyone on this yet....

Mangesh





"Mangesh Yadav" wrote in message
...
Hi Alasdair,

Thanks for the response.

Infact my problem does not relate much to the VB dll. Its rather basic. I
want to know what is the parent of UserForm1.UserForm_Initialize

or starting from ThisWorkbook and using intellisense, how can one arrive
at
UserForm1.UserForm_Initialize

Something like:
ThisWorkbook.SOMETHING.SOMETHING.UserForm1.UserFor m_Initialize



Mangesh


"Alasdair Stirling" wrote in
message ...
Have a look at the following article:

http://support.microsoft.com/default...;en-us;Q194611

Regards,

Alasdair Stirling

"Mangesh Yadav" wrote:

Hi,

I have a userform call frmGraph, and currently in my excel application
I
am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll, and
this
particular line is giving me the error object not found. Preceding it
with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Hi Mangesh,

Referring to your original question - you say you are converting everything
to a vb6 dll, so why are you trying to call a vba userform from your dll. Is
that indeed what you are trying to do?

I don't follow why you want to call UserForm_Initialize(). This event, and
code within, will run automatically as soon as you make the first reference
to the Userform. Typically that might be Load or Show, but could be any sort
of ref.

Regards,
Peter T

"Mangesh Yadav" wrote in message
...
Anyone on this yet....

Mangesh





"Mangesh Yadav" wrote in message
...
Hi Alasdair,

Thanks for the response.

Infact my problem does not relate much to the VB dll. Its rather basic.
I
want to know what is the parent of UserForm1.UserForm_Initialize

or starting from ThisWorkbook and using intellisense, how can one arrive
at
UserForm1.UserForm_Initialize

Something like:
ThisWorkbook.SOMETHING.SOMETHING.UserForm1.UserFor m_Initialize



Mangesh


"Alasdair Stirling" wrote
in
message ...
Have a look at the following article:

http://support.microsoft.com/default...;en-us;Q194611

Regards,

Alasdair Stirling

"Mangesh Yadav" wrote:

Hi,

I have a userform call frmGraph, and currently in my excel
application
I
am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll, and
this
particular line is giving me the error object not found. Preceding
it
with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does
not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Hi Peter,

Thanks for your response.

Basically I have an established excel application. And now I am turning some
of the excel macros into VB dll. The line
call UserForm1.UserForm_Initialize
runs well in excel, but it gives an error in the dll. So my question was
starting with ThisWorkbook, how do you arrive at UserForm1 using
intellisense.

For some reason, I want to run the Initialize event without an actual LOAD
Form call.


Mangesh




"Peter T" <peter_t@discussions wrote in message
...
Hi Mangesh,

Referring to your original question - you say you are converting
everything
to a vb6 dll, so why are you trying to call a vba userform from your dll.
Is
that indeed what you are trying to do?

I don't follow why you want to call UserForm_Initialize(). This event, and
code within, will run automatically as soon as you make the first
reference
to the Userform. Typically that might be Load or Show, but could be any
sort
of ref.

Regards,
Peter T

"Mangesh Yadav" wrote in message
...
Anyone on this yet....

Mangesh





"Mangesh Yadav" wrote in message
...
Hi Alasdair,

Thanks for the response.

Infact my problem does not relate much to the VB dll. Its rather
basic.
I
want to know what is the parent of UserForm1.UserForm_Initialize

or starting from ThisWorkbook and using intellisense, how can one
arrive
at
UserForm1.UserForm_Initialize

Something like:
ThisWorkbook.SOMETHING.SOMETHING.UserForm1.UserFor m_Initialize



Mangesh


"Alasdair Stirling" wrote
in
message ...
Have a look at the following article:

http://support.microsoft.com/default...;en-us;Q194611

Regards,

Alasdair Stirling

"Mangesh Yadav" wrote:

Hi,

I have a userform call frmGraph, and currently in my excel
application
I
am
calling its initialise event something like this:
frmGraph.UserForm_Initialize

Now my problem is that, I am converting everything to a VB dll,
and
this
particular line is giving me the error object not found. Preceding
it
with
ThisWorkbook e.g.
ThisWorkbook.frmGraph.UserForm_Initialize
still does not solve the problem and gives the error "object does
not
support this property" which is ofcourse expected.

How do I call this sub through my dll....?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP