+ Reply to Thread
Results 1 to 4 of 4

How to enable userform

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    62

    How to enable userform

    Hello please could someone help me.

    I have 6 userforms, the first 5 work fine. However, when I move onto the final userform the curser is set in the first textbox but everything on the userform is disabled. I wont let me click on any of the command buttons or type anything in the textbox. In order to exit out of the userfom/excel I have to right click the tab at the bottom. Does anyone have any ideas as to why this may be happening?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to enable userform

    Whether the Enabled Property of the controls is set to True?
    Is there any code exists on Userform Initialize?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-04-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: How to enable userform

    SixthSense I feel like such an idiot, the userform enable was set to false-should have been the first thing I checked! Thankyou for your help, time for a break from VBA for an hour i think ha.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to enable userform

    Ha ha ha it happens to all unknowingly...

    Yeah taking break gives more refreshment to the brain carry on...

+ 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. IF statement to enable/disable a checkbox in userform?
    By cameronyoung in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2013, 12:18 PM
  2. [SOLVED] How to enable Userform with optionbutton checked?
    By meprad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2013, 07:06 AM
  3. Enable backspace key in combobox on Userform
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2011, 05:35 PM
  4. Enable ComboBox - userform
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2008, 02:17 PM
  5. Enable controls in userform
    By WhiteKelso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2007, 04:49 PM

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