+ Reply to Thread
Results 1 to 4 of 4

Userform problem

Hybrid View

  1. #1
    Andrew B
    Guest

    Userform problem

    Hi
    I have created a simple userform which gives the user a choice between
    three option buttons. When the userform first appears, the text for the
    first option button is enclosed in a dotted rectangle. How do I remove
    this rectangle so that it doesn't appear to be the preferred option ?

    I tried this but it didn't change anything.

    Private Sub OptionButton1_Click()
    GotFocus = False
    end sub

    TIA

    Andrew B

  2. #2
    Gert-Jan
    Guest

    Re: Userform problem

    May the Tab-index? You can also set TabStop to "No"

    "Andrew B" <ajtbzz@iinet.et.au> schreef in bericht
    news:444e9f7a$0$30714$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
    > Hi
    > I have created a simple userform which gives the user a choice between
    > three option buttons. When the userform first appears, the text for the
    > first option button is enclosed in a dotted rectangle. How do I remove
    > this rectangle so that it doesn't appear to be the preferred option ?
    >
    > I tried this but it didn't change anything.
    >
    > Private Sub OptionButton1_Click()
    > GotFocus = False
    > end sub
    >
    > TIA
    >
    > Andrew B




  3. #3
    Die_Another_Day
    Guest

    Re: Userform problem

    On Userform1_Initialize try this

    OptionButton2.SetFocus 'Change out Button2 for whichever button you
    want to have focus

    Die_Another_Day


  4. #4
    Andrew B
    Guest

    Re: Userform problem

    The TabStop thing worked - thanks.

+ 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