+ Reply to Thread
Results 1 to 2 of 2

How to pre-load GUI with certain settings?

Hybrid View

larryg003 How to pre-load GUI with... 11-28-2014, 12:00 PM
larryg003 Re: How to pre-load GUI with... 11-28-2014, 12:08 PM
  1. #1
    Registered User
    Join Date
    03-28-2010
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    57

    How to pre-load GUI with certain settings?

    Hi All,

    I have a very simple question. I have a command button that triggers a GUI:

    Private Sub CommandButton1_Click()
    
    TradeEntryUserForm.Show
    
    End Sub
    MY GUI automatically displays four different frames. There are four different checkboxes on the GUI such that if you select 1, frame 1 appears, if you select 2, frame1 + frame 2 appears, if you select 3, frame 1+frame2+frame3 appears.

    I want to preload my GUI such that checkbox 1 is selected and that only 1 frame appears. If I click on checkbox1 after the GUI pops up this occurs.

    I tried this but it didn't work:

    Private Sub CommandButton1_Click()
    
    TradeEntryUserForm.Show
    TradeEntryUserForm.CheckBox1 = True
    
    End Sub
    Any thoughts?

    Much appreciated,

    L

  2. #2
    Registered User
    Join Date
    03-28-2010
    Location
    New York
    MS-Off Ver
    Office 365
    Posts
    57

    Re: How to pre-load GUI with certain settings?

    Never mind - I'm retarded. I should have put the message before showing the GUI. DUMMMY!

+ 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] UserForm Load Record Function Does Not Load First Record
    By Ambassador777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 02:31 PM
  2. [SOLVED] One of the Settings in Options Trust Center Settings is Grayed out
    By zit1343 in forum Excel General
    Replies: 2
    Last Post: 06-28-2012, 09:18 AM
  3. Load! - What is this???
    By hughveal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2011, 01:52 PM
  4. load Dll
    By lisandro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2007, 04:40 PM
  5. VBA to run on load
    By RobertLees in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2006, 01:17 AM

Tags for this Thread

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