+ Reply to Thread
Results 1 to 3 of 3

Trouble calling a sub from within a User Form initialize procedure

  1. #1
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    231

    Trouble calling a sub from within a User Form initialize procedure

    Morning.

    On initializing my user form, I do the following:

    1) first populate all the comboboxes with values.
    2) Next I hide all labels and input boxes on the user form
    3) Last, and here is my problem, I want to turn labels and input boxes back on based on conditions. To accomplish this, I created a separate sub entitled "Sub Inputs" which is called from within my User Form Intialize procedure. Unfortunately, the called procedure does not execute. Any ideas?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Trouble calling a sub from within a User Form initialize procedure

    Place the file here because the code can be much simpler and faster.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,119

    Re: Trouble calling a sub from within a User Form initialize procedure

    The select case should be
    Please Login or Register  to view this content.
    (no quotes)

+ 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] Calling a halt to procedure if user cancels File-Open
    By dubcap01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2015, 03:05 AM
  2. Simple User form initialize and close
    By T 520 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2015, 02:47 PM
  3. [SOLVED] Calling User form Initialize: A way to display certain tab based on which sub called?
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 10:06 AM
  4. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  5. User Form Initialize Event Issues
    By Randy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2005, 07:30 AM
  6. [SOLVED] How to pass a variable from Form back to calling procedure
    By John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2005, 11:05 AM
  7. [SOLVED] Closing user form in Initialize macro?
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2005, 04:06 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