+ Reply to Thread
Results 1 to 2 of 2

Using a UserForm to call different sheets and input the data upon a selection.

  1. #1
    Registered User
    Join Date
    04-27-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    6

    Using a UserForm to call different sheets and input the data upon a selection.

    Hello,

    I am trying to see if I can get a macro to open up a UserForm when I select a name that is inputted into column A. When the cell is selected I what it to open my UserForm named Address which calls on the address tab and inputs the information that matches the name selected. Also on the Address Form I can select a button that calls up a different sheet that has assignment scores and inputs that data into the new form, etc, etc. I tried to do some of the script from what I have read on my google searches. I also have a find and replace userform that I have absolutely no idea how to code it to find a name and list the address and then save it to that row. I have a crude example and any help would be much appreciated. Example.xlsm

  2. #2
    Registered User
    Join Date
    04-27-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Using a UserForm to call different sheets and input the data upon a selection.

    I believe I got the buttons to call a different sheet by setting the range = .Find(Selection, LookIn:=xlValues). I still need help with having my userform for the database sheet be able to find the name, bring up all the information associated with it and then replacewhat information I change to the giving cells it belongs to.

+ 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