Results 1 to 3 of 3

UserForm, update after command button click

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    UserForm, update after command button click

    Hi, I have a user form with 1 ComboBox and 1 CommandButton on it.
    You make a choice in the combo and then the button becomes visible.
    When you click the button, the only code is Call GetProjects

    In GetProjects, the beginning code is:

    Application.StatusBar = "Macro running, please wait....."
    
    'modify form view
        frmInput.Frame1.Visible = False
        frmInput.frmButton1.Visible = False
        frmInput.lblMacroRunning.Visible = True
    The status bar does change, but nothing else on the form changes.
    Also had this code in the button click event and it didn't work there either (except for status bar).
    Can anyone tell me why it doesn't work? When I step through it, it does work.
    Thanks.
    Last edited by ker9; 11-01-2010 at 01:06 PM.

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