+ Reply to Thread
Results 1 to 1 of 1

Enabling/disabling dynamically generated control via another dynamically generated control

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    6

    Enabling/disabling dynamically generated control via another dynamically generated control

    I have a userform that creates a new multipage with each press of a button.
    Each multipage will contain a number of dynamically created controls (textboxes, optionbuttons comboboxes etc)
    Some of these dynamic controls must be Enabled/disabled via the selection or input values from other dynamically created controls.

    So far here is my code for the project is as follows;

    Please Login or Register  to view this content.
    Problem
    The iteration of x through the project and the use of integer x in the naming of the dynamically generated controls have me at a loss as to how to create code to affect the dynamically generated controls or even how to properly name the declarations for a Sub.

    For instance

    Please Login or Register  to view this content.
    OR

    Please Login or Register  to view this content.
    do not seem to work of have any effect on the controls I want to enable/disable.

    I suspect this issue may be solved by the use of a Class but I frankly need help in understanding classes and their use in vba.

    Any help on this would be appreciated.
    Attached Files Attached Files

+ 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. Macro to click on a dynamically generated hyperlink
    By Wonderingaboutmacros in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2017, 09:15 AM
  2. Dynamically generated Shell command
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2016, 02:31 PM
  3. How to Create Dynamically Generated Word List
    By GoodManRob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2014, 11:24 AM
  4. Dynamically Generated Form And Their Click Events
    By fenilbhoot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 10:13 AM
  5. [SOLVED] Use VBA to download a dynamically generated image from the web.
    By nponoBegHuk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2012, 09:51 AM
  6. Setting up a dynamically generated range reference
    By cveetan in forum Excel General
    Replies: 8
    Last Post: 02-22-2012, 07:37 AM
  7. [SOLVED] Dynamically Generated Range using Macro
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2006, 03:15 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