+ Reply to Thread
Results 1 to 6 of 6

Transfer Data from excel to userform

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Transfer Data from excel to userform

    Hello

    is it possible to select a cell (by clicking on it) and then click on the button and transfer that row's data to userform?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,214

    Re: Transfer Data from excel to userform

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,553

    Re: Transfer Data from excel to userform

    Hi,
    One way would be to use the form's Initialise event. i.e.

    Please Login or Register  to view this content.
    Depends what you are trying to achieve.
    You might like to consider instead of text boxes using List or ComboBoxes so that they contain all relevant values so that you can pick one. You can load the values by either using the .RowSource property of the control objects or the .AddItem code syntax
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: Transfer Data from excel to userform

    Quote Originally Posted by Fluff13 View Post
    How about
    Please Login or Register  to view this content.
    Thank You

  5. #5
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: Transfer Data from excel to userform

    Quote Originally Posted by Richard Buttrey View Post
    Hi,
    One way would be to use the form's Initialise event. i.e.

    Please Login or Register  to view this content.
    Depends what you are trying to achieve.
    You might like to consider instead of text boxes using List or ComboBoxes so that they contain all relevant values so that you can pick one. You can load the values by either using the .RowSource property of the control objects or the .AddItem code syntax
    Thank you
    The userform I made has multiple combobox and textbox and i'm using this for editing the table.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,214

    Re: Transfer Data from excel to userform

    Glad to help & thanks for the feedback.

+ 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. [SOLVED] Possible to transfer data from userform into excel table???
    By Kamal1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-02-2018, 08:01 PM
  2. Transfer userform data to excel sheet
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2017, 05:11 AM
  3. Transfer userform data
    By neilsy1 in forum Excel General
    Replies: 1
    Last Post: 08-27-2016, 04:26 AM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  5. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  6. Excel UserForm Transfer of data to Columns
    By rudevincy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2012, 12:43 AM
  7. [SOLVED] Userform to transfer data to another userform
    By Oeysbrei in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 04:46 PM

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