+ Reply to Thread
Results 1 to 2 of 2

VBA User Form Issues - Check boxes greyed out after running macro

  1. #1
    Registered User
    Join Date
    09-06-2019
    Location
    Not Applicable
    MS-Off Ver
    365 ProPlus
    Posts
    1

    Question VBA User Form Issues - Check boxes greyed out after running macro

    Hello everyone,

    I am new at learning VBA and was working with a pre written code from a coworker. I needed to change some of the code to reflect the change in some of our column names. We created a form that would pop up so we could select what columns we wanted our code to pick up to generate the file that the code was meant for. Has anyone ever created a userform and selected certain items and then when you run the macro, some of the check boxes grey out and the data does not populate?

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: VBA User Form Issues - Check boxes greyed out after running macro

    Not really.

    It all depends on how your code is written so posting it would be helpfull. An example workbook with userform and code in it would be even better.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. User Form Check Boxes
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2017, 07:11 PM
  2. User Form Check Boxes
    By nwb in forum Excel General
    Replies: 5
    Last Post: 01-13-2017, 03:09 AM
  3. User Form - Color all Boxes without (mandatory) Value - Macro Shortening Possible
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2016, 12:58 PM
  4. [SOLVED] User form: with check boxes how do i allow MULTIPLE auto filters to run at the same time
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2016, 09:13 AM
  5. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  6. How to use an excel user form with check boxes that will hide columns when selected.
    By FANNINGT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2015, 06:53 PM
  7. User Form During Macro Running
    By mido609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 06:17 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