Results 1 to 9 of 9

Unable to launch userform from button on worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2015
    Location
    arizona
    MS-Off Ver
    2007
    Posts
    4

    Unable to launch userform from button on worksheet

    Hey guys,

    Trying to launch a form from a button on a worksheet but unable to do it, I already have the userform setup where it automatically launches when i open a workbook, however if the userform is closed the users have to then launch it though the developer tab which a lot of them dont know how..So i decided to put a button on the wrksheet to launch it but it does not launch, get a debug error...

    this workbook has a code

    Private Sub Workbook_Open()
    UserForm1.Show
    End Sub


    And in my main user for i have this code

    Private Sub UserForm_Initialize()
    With Sheets("Database").Range("A3", Cells(Rows.Count, "A").End(xlUp))
    partner = Application.Transpose(.Value2)
    End With

    Me.ComboBox1.List = partner

    End Sub

    Help
    Last edited by savferns01; 01-14-2016 at 03:53 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] userform button is depressed and unable to get it to go back to normal.
    By CtrlAltDelete in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2014, 12:17 PM
  2. Launch application by command button on excel vba userform
    By Benjamin2008 in forum Excel General
    Replies: 1
    Last Post: 12-20-2013, 05:15 PM
  3. Unable to launch VSTO add-in
    By cb366374 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2013, 09:08 PM
  4. [SOLVED] EXCEL USERFORM- Unable to print spreadsheet using command button
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-19-2013, 10:26 AM
  5. [SOLVED] Launch a userform from toolbar instead of command button
    By Clare Smyth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 12:17 PM
  6. How to launch macro or other userform after command button.
    By Karkas in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-06-2009, 08:49 PM
  7. Macro launch - Button vs Manual launch , has different results.
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 08: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