+ Reply to Thread
Results 1 to 3 of 3

How to prevent my drop down menu activating prematurely???????

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    How to prevent my drop down menu activating prematurely???????

    Hi,

    My Combobox2 has a drop down menu that when I open the userform, the drop down menu is activated. Is it possible to open the userform and not activate the drop down until
    I click on the arrow? The form works beautifully thanks to some great assistance from this forum. Here's the code:






    Please Login or Register  to view this content.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: How to prevent my drop down menu activating prematurely???????

    Good morning bralew

    Have you tried removing the line "ComboBox2.SetFocus"? Can't see that that line is needed for any other reason, other than to select that object.

    HTH

    DominicB

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How to prevent my drop down menu activating prematurely???????

    Perfect!, thank you kindly Sir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prevent Printing Unless Drop Down Menu is used
    By soranandivan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-19-2016, 03:29 PM
  2. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  3. [SOLVED] Activating hidden sheet using a drop down menu
    By mando415 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 08:40 PM
  4. Replies: 2
    Last Post: 01-08-2010, 09:11 AM
  5. Replies: 2
    Last Post: 01-30-2009, 04:23 PM
  6. Prevent delete on drop down menu
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2008, 06:29 AM
  7. Replies: 9
    Last Post: 08-04-2006, 04:35 AM

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