Results 1 to 7 of 7

Thread: OK! How about some information?

  1. Jul 26th, 2000, 05:05 PM #1
    Nitro
    Nitro is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Nitro
    Posts
    633

    Question

    Does anyone know the API equivalent to SCALEX function?

    Please provide an example if possible!

    Thanks.
    Chemically Formulated As:
    Dr. Nitro
    Reply With Quote Reply With Quote
  2. Jul 26th, 2000, 05:13 PM #2
    kedaman
    kedaman is offline
    transcendental analytic kedaman's Avatar
    Join Date
    Mar 2000
    Location
    0x002F2EA8
    Posts
    7,221
    Why would you need that? AFAIK All screen related stuff in API are specified in pixels
    Use
    writing software in C++ is like driving rivets into steel beam with a toothpick.
    writing haskell makes your life easier:
    reverse (p (6*9)) where p x|x==0=""|True=chr (48+z): p y where (y,z)=divMod x 13
    To throw away OOP for low level languages is myopia, to keep OOP is hyperopia. To throw away OOP for a high level language is insight.
    Reply With Quote Reply With Quote
  3. Jul 26th, 2000, 05:15 PM #3
    Nitro
    Nitro is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Nitro
    Posts
    633
    I am using Excel and trying to make one of the userform to be the size of the screen width. How might you suggest me attacking this problem?

    I am using the Move method to position and size at the same time. Userform has no maximaze state.
    Chemically Formulated As:
    Dr. Nitro
    Reply With Quote Reply With Quote
  4. Jul 26th, 2000, 05:36 PM #4
    Nitro
    Nitro is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Nitro
    Posts
    633
    Here is actually a better question. In Excel, the userform is similar to a VB form but does not have some functionality. It does not have hDC or hWnd. How can I obtain hDC or hWnd for the userform in Excel?

    Because once having one of this, I will just use the SetWindowPos API.

    Thanks
    Chemically Formulated As:
    Dr. Nitro
    Reply With Quote Reply With Quote
  6. Jul 26th, 2000, 05:37 PM #5
    kedaman
    kedaman is offline
    transcendental analytic kedaman's Avatar
    Join Date
    Mar 2000
    Location
    0x002F2EA8
    Posts
    7,221
    Dunno much about programming Excel apps, but
    Do you have something like Screen.TwipsperpixelX?

    Since you can get the screen size by
    Code:
    Screen.Width/Screen.TwipsperpixelX
Screen.Height/Screen.TwipsperpixelY
    Use
    writing software in C++ is like driving rivets into steel beam with a toothpick.
    writing haskell makes your life easier:
    reverse (p (6*9)) where p x|x==0=""|True=chr (48+z): p y where (y,z)=divMod x 13
    To throw away OOP for low level languages is myopia, to keep OOP is hyperopia. To throw away OOP for a high level language is insight.
    Reply With Quote Reply With Quote
  7. Jul 26th, 2000, 05:41 PM #6
    kedaman
    kedaman is offline
    transcendental analytic kedaman's Avatar
    Join Date
    Mar 2000
    Location
    0x002F2EA8
    Posts
    7,221
    You can use Findwindow API to find the userform in Excel, You just need to find out the classname of it.
    Use
    writing software in C++ is like driving rivets into steel beam with a toothpick.
    writing haskell makes your life easier:
    reverse (p (6*9)) where p x|x==0=""|True=chr (48+z): p y where (y,z)=divMod x 13
    To throw away OOP for low level languages is myopia, to keep OOP is hyperopia. To throw away OOP for a high level language is insight.
    Reply With Quote Reply With Quote
  8. Jul 26th, 2000, 05:50 PM #7
    Nitro
    Nitro is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jan 2000
    Location
    Nitro
    Posts
    633
    Originally posted by kedaman
    Dunno much about programming Excel apps, but
    Do you have something like Screen.TwipsperpixelX?

    Since you can get the screen size by
    Code:
    Screen.Width/Screen.TwipsperpixelX
Screen.Height/Screen.TwipsperpixelY
    No such thing in Excel!

    That is right, I forgot all about FindWindow!

    Thanks Ked!
    Chemically Formulated As:
    Dr. Nitro
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width