Is It possible to get Lisbox1 windowlong ?

[[email protected]]

Hi all,

Is It possible to get Lisbox1 windowlong ?
if we use FindWindow API calls ...

Anyone please reply ...
Rgds,

Halim

[NickHK]

I assume you mean it HWnd.
If it is on a worksheet then no, as it is windowless AFAIK.
On a userform then yes. Use Spy++ to get its class.

NickHK

<[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> Is It possible to get Lisbox1 windowlong ?
> if we use FindWindow API calls ...
>
> Anyone please reply ...
> Rgds,
>
> Halim
>

[[email protected]]

Hi Nick,

Thanks for your relply ,,,,,

The classname refer to "F3 Server 60000000" nice help Nick
I've just used this one:
hWndFrm = FindWindow("ThunderDFrame", Me.Caption)
hwndtextbox = FindWindowEx(hWndXL, 0, "F3 Server 60000000",
vbNullString)

is that right?
....
Many Thanks,,
halim



NickHK menuliskan:
> I assume you mean it HWnd.
> If it is on a worksheet then no, as it is windowless AFAIK.
> On a userform then yes. Use Spy++ to get its class.
>
> NickHK
>
> <[email protected]> wrote in message
> news:[email protected]...
> > Hi all,
> >
> > Is It possible to get Lisbox1 windowlong ?
> > if we use FindWindow API calls ...
> >
> > Anyone please reply ...
> > Rgds,
> >
> > Halim
>

[NickHK]

I'm no expert when it comes to this, especially as it seems Office forms
behave differently to "normal" windows.
However, if it really is a textbox that you trying to find, Spy++ cannot
pick it up on a userform, so I'm not sure what your "F3 Server 60000000"
class is referring to.

Why do need to do this in VBA ?

NickHK

<[email protected]> wrote in message
news:[email protected]...
> Hi Nick,
>
> Thanks for your relply ,,,,,
>
> The classname refer to "F3 Server 60000000" nice help Nick
> I've just used this one:
> hWndFrm = FindWindow("ThunderDFrame", Me.Caption)
> hwndtextbox = FindWindowEx(hWndXL, 0, "F3 Server 60000000",
> vbNullString)
>
> is that right?
> ...
> Many Thanks,,
> halim
>
>
>
> NickHK menuliskan:
> > I assume you mean it HWnd.
> > If it is on a worksheet then no, as it is windowless AFAIK.
> > On a userform then yes. Use Spy++ to get its class.
> >
> > NickHK
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi all,
> > >
> > > Is It possible to get Lisbox1 windowlong ?
> > > if we use FindWindow API calls ...
> > >
> > > Anyone please reply ...
> > > Rgds,
> > >
> > > Halim
> >
>

[NickHK]

I'm no expert when it comes to this, especially as it seems Office forms
behave differently to "normal" windows.
However, if it really is a textbox that you trying to find, Spy++ cannot
pick it up on a userform, so I'm not sure what your "F3 Server 60000000"
class is referring to.

Why do need to do this in VBA ?

NickHK

<[email protected]> wrote in message
news:[email protected]...
> Hi Nick,
>
> Thanks for your relply ,,,,,
>
> The classname refer to "F3 Server 60000000" nice help Nick
> I've just used this one:
> hWndFrm = FindWindow("ThunderDFrame", Me.Caption)
> hwndtextbox = FindWindowEx(hWndXL, 0, "F3 Server 60000000",
> vbNullString)
>
> is that right?
> ...
> Many Thanks,,
> halim
>
>
>
> NickHK menuliskan:
> > I assume you mean it HWnd.
> > If it is on a worksheet then no, as it is windowless AFAIK.
> > On a userform then yes. Use Spy++ to get its class.
> >
> > NickHK
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi all,
> > >
> > > Is It possible to get Lisbox1 windowlong ?
> > > if we use FindWindow API calls ...
> > >
> > > Anyone please reply ...
> > > Rgds,
> > >
> > > Halim
> >
>

[[email protected]]

Hi Nick,

I need to repositioning my Workbook window to the textbox posittion by
using WinRect perhaps!, so I need the way to make the WB window look
like pasted on the form ...

do you have a better idea ???

Rgds,
halim


NickHK menuliskan:
> I'm no expert when it comes to this, especially as it seems Office forms
> behave differently to "normal" windows.
> However, if it really is a textbox that you trying to find, Spy++ cannot
> pick it up on a userform, so I'm not sure what your "F3 Server 60000000"
> class is referring to.
>
> Why do need to do this in VBA ?
> >

[NickHK]

There's a SpreadSheet control that I have that can hold a WB on a userform,
MSOWC.DLL .

NickHK

<[email protected]> wrote in message
news:[email protected]...
> Hi Nick,
>
> I need to repositioning my Workbook window to the textbox posittion by
> using WinRect perhaps!, so I need the way to make the WB window look
> like pasted on the form ...
>
> do you have a better idea ???
>
> Rgds,
> halim
>
>
> NickHK menuliskan:
> > I'm no expert when it comes to this, especially as it seems Office forms
> > behave differently to "normal" windows.
> > However, if it really is a textbox that you trying to find, Spy++ cannot
> > pick it up on a userform, so I'm not sure what your "F3 Server 60000000"
> > class is referring to.
> >
> > Why do need to do this in VBA ?
> > >
>