+ Reply to Thread
Results 1 to 2 of 2

add button to spreadsheet to open form

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Talking add button to spreadsheet to open form

    I have created a spreadsheet with a user form and the form opens automatically when the spreadsheet is opened. Once the user completes the form and "submits" the data the form goes away and the data is entered on the worksheet. This works great, BUT- users have asked to open the form from the worksheet so that they can add additional information. I tried to add a "button" on the sheet that would allow them to open the form- but I can't get the button to work...anyone have any suggestions?

  2. #2
    Registered User
    Join Date
    11-20-2009
    Location
    Raymond,WA
    MS-Off Ver
    Excel 2002
    Posts
    40

    Re: adding button to spreadsheet to open form

    The click event for the button should be:

    Please Login or Register  to view this content.
    Your aren't changing the size or position of the form that might be causing it to not show are you?

+ Reply to Thread

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