+ Reply to Thread
Results 1 to 2 of 2

User form - disable checkboxes until ready

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    User form - disable checkboxes until ready

    I have closed my previous thread and raised this one, as I felt I may not have explained myself very well last time.
    I have a User form that people must select their name from the drop down list and then select a number of check boxes.
    I wanted the Check boxes to remain disabled until a person actually selected their name from the combo box.
    The person's preferences are sent to another sheet but some people are sending preferences without their name.
    I was given a suggestion of 'CB01.Enabled = False', but could not get it to work.
    The combo Box opens with a blank field initially, so that's when I would like the Check Boxes to be greyed out.
    As soon as the person selects their name, the check boxes become enabled.
    Could somebody tell me if there is some VBA code I can attach somewhere which will do what I want?
    Thank you to anybody that can assist me.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646
    Perhaps something like this, which assumes the checkboxes have been disabled at run-time or when the userform opens.

    Please Login or Register  to view this content.
    Last edited by Norie; 05-28-2013 at 04:19 AM.
    If posting code please use code tags, see here.

+ 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