+ Reply to Thread
Results 1 to 7 of 7

Is It possible to get Lisbox1 windowlong ?

  1. #1
    halimnurikhwan@yahoo.com
    Guest

    Is It possible to get Lisbox1 windowlong ?

    Hi all,

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

    Anyone please reply ...
    Rgds,

    Halim


  2. #2
    NickHK
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

    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

    <halimnurikhwan@yahoo.com> wrote in message
    news:1155006500.150964.236820@m79g2000cwm.googlegroups.com...
    > Hi all,
    >
    > Is It possible to get Lisbox1 windowlong ?
    > if we use FindWindow API calls ...
    >
    > Anyone please reply ...
    > Rgds,
    >
    > Halim
    >




  3. #3
    halimnurikhwan@yahoo.com
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

    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
    >
    > <halimnurikhwan@yahoo.com> wrote in message
    > news:1155006500.150964.236820@m79g2000cwm.googlegroups.com...
    > > Hi all,
    > >
    > > Is It possible to get Lisbox1 windowlong ?
    > > if we use FindWindow API calls ...
    > >
    > > Anyone please reply ...
    > > Rgds,
    > >
    > > Halim

    >



  4. #4
    NickHK
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

    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

    <halimnurikhwan@yahoo.com> wrote in message
    news:1155028226.373049.315940@n13g2000cwa.googlegroups.com...
    > 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
    > >
    > > <halimnurikhwan@yahoo.com> wrote in message
    > > news:1155006500.150964.236820@m79g2000cwm.googlegroups.com...
    > > > Hi all,
    > > >
    > > > Is It possible to get Lisbox1 windowlong ?
    > > > if we use FindWindow API calls ...
    > > >
    > > > Anyone please reply ...
    > > > Rgds,
    > > >
    > > > Halim

    > >

    >




  5. #5
    NickHK
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

    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

    <halimnurikhwan@yahoo.com> wrote in message
    news:1155028226.373049.315940@n13g2000cwa.googlegroups.com...
    > 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
    > >
    > > <halimnurikhwan@yahoo.com> wrote in message
    > > news:1155006500.150964.236820@m79g2000cwm.googlegroups.com...
    > > > Hi all,
    > > >
    > > > Is It possible to get Lisbox1 windowlong ?
    > > > if we use FindWindow API calls ...
    > > >
    > > > Anyone please reply ...
    > > > Rgds,
    > > >
    > > > Halim

    > >

    >




  6. #6
    halimnurikhwan@yahoo.com
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

    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 ?
    > >



  7. #7
    NickHK
    Guest

    Re: Is It possible to get Lisbox1 windowlong ?

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

    NickHK

    <halimnurikhwan@yahoo.com> wrote in message
    news:1155083307.076452.82870@m73g2000cwd.googlegroups.com...
    > 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 ?
    > > >

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1