+ Reply to Thread
Results 1 to 4 of 4

On current Userform, click OK Command Button to open new Window

  1. #1
    Registered User
    Join Date
    04-21-2016
    Location
    Pittsburgh, PA
    MS-Off Ver
    2010
    Posts
    5

    On current Userform, click OK Command Button to open new Window

    Currently, I have a userform where I have workers fill out all their data, and when they click OK the window closes and the information is sent to the excel sheet. Is there any way now when they click the OK command button, another window can appear with a text box for them to fill out and that data will be sent to a separate excel sheet? If you need a better explanation or more info let me know! Thanks guys

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: On current Userform, click OK Command Button to open new Window

    If there is other data required, to be sent to a different worksheet than the other data in the user form, it would be best to just add a text box to the existing user form. Your WriteToSheet routine would be modified to send the entry from this text box to the correct sheet.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: On current Userform, click OK Command Button to open new Window

    eclairez7:

    See attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-21-2016
    Location
    Pittsburgh, PA
    MS-Off Ver
    2010
    Posts
    5

    Re: On current Userform, click OK Command Button to open new Window

    Thanks so much!

+ 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] have vba click a command button when UserForm opens
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2015, 04:48 PM
  2. [SOLVED] Using command button in userform to update current row
    By puffo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2014, 03:32 PM
  3. [SOLVED] Click the button and open the file in a separate Excel window
    By LewisM in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2014, 11:04 AM
  4. Run command button click event on open
    By slmi1313 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2010, 12:19 PM
  5. UserForm, update after command button click
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2010, 01:05 PM
  6. Open a Help window if click on a button
    By royinfo in forum Excel General
    Replies: 3
    Last Post: 11-19-2009, 03:55 PM
  7. command button to open a window
    By slmi1313 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2008, 12:38 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