Results 1 to 8 of 8

TextBox to display value in existing cell then update it

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    TextBox to display value in existing cell then update it

    Hello!

    I've been trying to figure this out for a couple of days- no luck. I built a UserForm that populates an Excel sheet based on some simple choices and data entry.

    First, the user must choose 2 values from 2 dropdown menus:
    1. Month
    2. Facility

    Then they are to enter 2 numbers into 2 text boxes: TextBox1 and TextBox2. These numbers are recorded on the spreadsheet in columns D and E, respectively. The target row depends on the Month and Facility selected.

    Now here's the problem: When the user initializes the UserForm, then picks Month and Facility, I'd like TextBox1 to display the current value in the corresponding D cell. The user can then choose to keep the shown value or update it then hit Enter to populate the spreadsheet.

    I'm loosing my mind over this! I feel like it's probably a very simple one-line code, but for some reason I just can't get it right!

    Thank you!
    Last edited by vceh; 07-14-2011 at 06:47 PM.

Thread Information

Users Browsing this Thread

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

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