+ Reply to Thread
Results 1 to 5 of 5

HELP PLEASE "copy all values in row from userform to worksheet if text boxes has value"

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    HELP PLEASE "copy all values in row from userform to worksheet if text boxes has value"

    Hi guys i'm stuck a bit,
    when i enter values in the userform textbox and press update button i need to copy whole row of data which is next to the textbox from userform to database sheet. (Copy only if data entered in the textbox).
    Basically if textbox has a value in userform row 1 and it has a value copy it to database sheet if not skip and if value is in other texbox copy other rows.

    I hope its not very confusing, the worksheet sample attached so it will help you to understand what i need.

    Thanks for your help


    http://www.ozgrid.com/forum/showthread.php?t=186316
    Attached Files Attached Files
    Last edited by intex; 02-20-2014 at 02:13 PM. Reason: not solved

  2. #2
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: copy all values in row from userform to worksheet if text boxes has value

    Hi guys, maybe somebody can let me know is it possible to copy values from labels if textbox has value if not i will try to think something else.
    Thanks for your time

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: copy all values in row from userform to worksheet if text boxes has value

    I think the first thing you should do is replace the numerous labels you are using to display the data with a multi-column listbox.

    That's going to make things a whole lot easier.

    Another thing you could do is explain what you want to do with an example.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: copy all values in row from userform to worksheet if text boxes has value

    Hi Norie i attached example sheet with pictures so it visually shows what i would like to achieve.
    You also mentioned a multi-column listbox how that works?

    I would be very thank full if you be able to help me.

    Thanks for your time
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: HELP PLEASE "copy all values in row from userform to worksheet if text boxes has value

    Anyone guys? I'm really stuck.
    Please check latest example.xlsm

+ 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] Help with code for userform text boxes, combo boxes and excel
    By innerise in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2014, 09:07 AM
  2. Copy or Cut userform text/list box values to a worksheet cell for printing
    By sumitos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 05:38 AM
  3. [SOLVED] Populate cell values into 6 named text boxes in a userform then edit if required
    By How How in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-05-2013, 05:51 AM
  4. [SOLVED] VBA to copy multiple Text boxes values to a sheet
    By sagar007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 03:45 AM
  5. Replies: 17
    Last Post: 10-14-2012, 11:15 AM

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