Results 1 to 5 of 5

event handling froma userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2008
    Location
    Oxfordshire, UK
    MS-Off Ver
    2007.
    Posts
    100

    event handling froma userform

    Hi All,

    I have a little problem with a userform commandbutton that I cannot resolve. I cannot seem to excecute a macro from a commandbutton, but if I go to the VBA project I can get it to work from there.

    The cmb just calls a macro, which in itself call 5 other macros. This is the code for the button:
    Private Sub CommandButton2_Click()
        Call Update_All 'this calls the update_all macro that updates all the figures on all tasks worksheet
        Unload UserForm3
    End Sub
    I may be missign something really simple here. As I said, if I go to the code and run it from there it opens the userform, I select a value and then click OK and it works, but it will not work if running from excel.
    Any ideas?

    JD
    Last edited by jad70; 03-10-2009 at 09:15 AM.

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