Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Search worksheet using userform then populate userform with matching data

  1. #1
    Join Date
    28th June 2010
    Posts
    2

    Search worksheet using userform then populate userform with matching data

    I have userforms created that people can input data into. I would like to place a command button on the userforms that would allow users to search data say as a form number as a reference which is used in the userforms. Then populate the userforms with data from the corresponding row. The userforms use text boxes, combobox, and option bottons.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Search worksheet using userform then populate userform with matching data

    See these links on using the Find Method

    How to Use Find in Excel VBA Macros
    Find Matching Criteria - a download example is available.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

  3. #3
    Join Date
    28th June 2010
    Posts
    2

    Re: Search worksheet using userform then populate userform with matching data

    How would I fill in comboboxes and option buttons in a userform? I want to show the userform completed to a second user just as it appear to the first user that completed the form.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    9th August 2012
    Posts
    11

    Re: Search worksheet using userform then populate userform with matching data

    This is what I was looking for myself, I recall doing it in college but I can't remember for the life of me how I did it, plus that was some what 6 years ago and I'm using 2010 now.

    check out my problem in this thread maybe if you/I get an answer we can help each other?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Populate UserForm ComboBox With Worksheet Table Data
    By Xjoutsider in forum EXCEL HELP
    Replies: 2
    Last Post: April 19th, 2010, 21:09
  2. Populate Userform With Search Results
    By Mentor in forum EXCEL HELP
    Replies: 17
    Last Post: September 21st, 2007, 08:08
  3. Populate Userform With Data From Worksheet
    By nu@this in forum EXCEL HELP
    Replies: 3
    Last Post: August 2nd, 2007, 02:06
  4. Populate UserForm Controls With Worksheet Data
    By jimapos in forum EXCEL HELP
    Replies: 2
    Last Post: September 28th, 2006, 10:35
  5. Populate worksheet from userform
    By Eclipse in forum EXCEL HELP
    Replies: 31
    Last Post: February 16th, 2006, 03:53

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
  •  
porno