Results 1 to 10 of 10

Thread: [RESOLVED] Display Excel Userform in 'unfocused' state

Threaded View

  1. Feb 16th, 2006, 09:46 PM #1
    VBAhack
    VBAhack is offline

    Thread Starter
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    [RESOLVED] Display Excel Userform in 'unfocused' state

    Is it possible to display an Excel Userform such that is appears initially in a de-highlighted state? I'm not sure, but I think the term is 'focus'

    I currently show a modeless userform triggered from the workbook open event but it always appears in a highlighted state.

    VB Code:
    1. Private Sub Workbook_Open()

    2.     OptionList.Show vbModeless  'appears in highlighted state

    3. End Sub
    Last edited by VBAhack; Feb 18th, 2006 at 09:08 PM.
    VBAhack
    (Links: Cubic Spline Tutorial, Parametric Cubic Spline Tutorial, VB Numerical Routines    )

    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