+ Reply to Thread
Results 1 to 2 of 2

have vba click a command button when UserForm opens

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    have vba click a command button when UserForm opens

    This should be simple, but I'm stuck with this:

    Userform3 is a listbox from which the user can select a name, then Userform2 opens, which is a multipage form with approximately 90 fields (text, dates, checkboxes, etc).
    When UserForm2 opens, the name (that was selected in Userform3) shows in the name field, but I have to click on a command button (cmdfind) to refresh all the other fields in the form with the data belonging to that name. What do I need to change or add to my UserForm3 code so that the cmdfind commandbutton is clicked in Userform2 when opened from Userform3?

    Any input/suggestion are greatly appreciated. Thank you!
    John

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Colorado, US
    MS-Off Ver
    MS Prof. 2010 and 2013 + 365
    Posts
    113

    Re: have vba click a command button when UserForm opens

    Never Mind. I was able to solve it! By changing the tab-index on the cmdfind button in UserForm2 to zero, it works fine now.

+ 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. vba to have command button click assign a number to another userform
    By lewisw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 09:12 AM
  2. Stop exit event of textbox firing when click a command button to close a userform
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2013, 09:27 AM
  3. Code a Command Button on UserForm not to close upon click - Excel VBA
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-14-2012, 02:20 PM
  4. [SOLVED] Is it possible to have a command button click event autofill a textbox within a userform?
    By Orestees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2012, 02:14 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

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