Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UserForm and Text Box (Excel 2000)

    Good Morning,

    Here I am once again needing help from the Pro's.

    I have a User Form with 3 text boxes, Name, Relationship and Date.

    I have a worksheet named "DisInfo" with 3 fields. A1 Name, A2 Relationship and A3 Date. B1, B2 and B3 should hold the information.

    Once the user enters the information in the text boxes, I would like the information to update DisInfo. into the respective cells, i.e. B1, B2 and B3 and then close the User Form.

    Could someone please provide me with insight on how to accomplish this. In Access it would be something like: AfterUpdate etc. not sure what it would be in Excel.

    Thanks in advance.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UserForm and Text Box (Excel 2000)

    Set the ControlSource property of the text boxes to the cells they should populate, in the form DisInfo!B1
    Put a command button on the useform to hide it (Me.Hide) or unload it (Unload Me)

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm and Text Box (Excel 2000)

    Thanks so much....u r a great help!!
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •