+ Reply to Thread
Results 1 to 20 of 20

Updating userform based upon input cell - Issues moving reworked code

Hybrid View

Chardo Updating userform based upon... 02-16-2014, 03:19 PM
Chardo Re: Updating userform based... 02-16-2014, 07:13 PM
jaslake Re: Updating userform based... 02-16-2014, 07:36 PM
Chardo Re: Updating userform based... 02-16-2014, 07:37 PM
jaslake Re: Updating userform based... 02-16-2014, 08:51 PM
Chardo Re: Updating userform based... 02-16-2014, 09:15 PM
Chardo Re: Updating userform based... 02-17-2014, 04:51 PM
  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Exclamation Updating userform based upon input cell - Issues moving reworked code

    I was able to get it all working. Just a silly mistake of missing some code.

    Hong Kong 730PM.xlsm

    Thank you for any help!


    **Tons of thanks to John for the support he has provided to this point.**
    Last edited by Chardo; 02-17-2014 at 11:58 PM. Reason: Changes have been made. Almost a complete spreadsheet.

  2. #2
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Updating userform based upon input cell

    Does anyone have any suggestions?

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Updating userform based upon input cell

    Hi Chardo

    Looking at it...
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Updating userform based upon input cell

    Quote Originally Posted by jaslake View Post
    Hi Chardo

    Looking at it...
    Thank you. I'm brand new to VBA and have been burning my brain out all weekend long trying to figure out how to do different things for this file.

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Updating userform based upon input cell

    Hi Chardo

    Try the Code in the attached...let me know of issues...
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Updating userform based upon input cell

    Quote Originally Posted by jaslake View Post
    Hi Chardo

    Try the Code in the attached...let me know of issues...
    This works great! Now that I'm looking at the code though I have a few questions in regards to making this a little more realistic.

    1.) Is there a way to make it so credit card info doesn't show up but it ONLY updates the cells if someone types in it?
    --I tried deleting the references to pull the data up which worked but then if you hit the update button it will paste the blank info into the database.

    2.) Is there anyway to not show/have the combo box on the employee search form? I'm guessing not since you added it.

    Again, thank you soo much for the help. I was so lost.

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Updating userform based upon input cell

    Hi Chardo

    Sure, this can be dealt with
    Is there a way to make it so credit card info doesn't show up but it ONLY updates the cells if someone types in it?
    This can also be dealt with if you wish the User to type in the entire Employee ID as in your original User Form. There will be no Type Ahead feature and, consequently, no Drop Down List to choose from.
    Is there anyway to not show/have the combo box on the employee search form?
    I'll work on this in the AM...not major changes...Code will be much simpler if this is what you wish.

  8. #8
    Registered User
    Join Date
    02-13-2014
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Updating userform based upon input cell

    I'm also trying to import this code into my actual final spreadsheet and it's getting hung up on the:

    Private Sub CommandButton1_Click()
    Call Find_Me
    End Sub

    --I've been trying to locate the Find_Me coding but I'm being highly unsuccessful. In the process of googling this right now to try and find a solution on my own.

+ 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. Userform Screen Updating - stop disappearing between each data input
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-24-2013, 01:42 AM
  2. [SOLVED] code for updating rows based on a userform combobox selection
    By raluk_ro22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2013, 11:09 AM
  3. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  4. Updating value in table based on user input
    By danresnick.dr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2010, 07:16 PM
  5. Writing a Formula based on UserForm input
    By MichelleW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2009, 11:15 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