+ Reply to Thread
Results 1 to 6 of 6

auto fill userform from cell

  1. #1
    Registered User
    Join Date
    09-04-2018
    Location
    Western Australia
    MS-Off Ver
    365
    Posts
    3

    auto fill userform from cell

    Hi all I was after information on a user form that will pop up with the information from the relevant cell that is clicked the clickable row would be in coloum A

    I can get the form to pop up but for the life of me cannot work out how to have it fill in the data from rows ie row 6 A to T

    Thanks for any help

    Mike

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: auto fill userform from cell

    Hi Mike and welcome.

    It will be easier for us to assist if you could attach the file so we can see the issue in context.

    To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: auto fill userform from cell

    Not sure what you want but I understood like this

    Please Login or Register  to view this content.
    Teach me Excel VBA

  4. #4
    Registered User
    Join Date
    09-04-2018
    Location
    Western Australia
    MS-Off Ver
    365
    Posts
    3

    Re: auto fill userform from cell

    Hi BadlySpelledBuoy I think i have attached it

    in it you will see coloum a i want to click it to open a userform with the details from that row
    Attached Files Attached Files

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: auto fill userform from cell

    There's no form... or code to make it show when you you click column A.
    Your first post made me think you'd sorted all that already. Is that not the case?

    If not then we're going to need a little more info on what you want this form to look like / contain.

    BSB

  6. #6
    Registered User
    Join Date
    09-04-2018
    Location
    Western Australia
    MS-Off Ver
    365
    Posts
    3

    Re: auto fill userform from cell

    Sorry wrong book Please see correct one
    Last edited by majic; 09-14-2018 at 09:02 PM.

+ 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. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  2. Userform auto fill dates in between
    By hep in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2013, 02:35 PM
  3. [SOLVED] UserForm in Excel- need to write code to auto fill a text field
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2013, 10:58 AM
  4. auto fill a spreadsheet on a userform based on a textbox value
    By cyclone77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2012, 11:38 PM
  5. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  6. Auto fill & auto blank cell
    By sushant.gore in forum Excel General
    Replies: 1
    Last Post: 10-07-2010, 01:06 PM
  7. Auto fill a UserForm ComboBox
    By ZIXILPLIX in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2010, 12:12 AM
  8. Auto fill specific cells from userform
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2009, 02:57 PM

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