+ Reply to Thread
Results 1 to 4 of 4

Adding text to sheet from userform

  1. #1
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Adding text to sheet from userform

    How can I edit this command button code so that when it adds the data form the userform to the sheet, that it also adds the word 'Manual' to the corresponding E column on the same row?

    Please Login or Register  to view this content.
    I tried adding the following line, but it didn't work:
    .Cells(LR, 4).Value = "Manual"

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Adding text to sheet from userform

    4 is column D. A.....B.....C.....D.....E. E = 5.

  3. #3
    Forum Contributor
    Join Date
    09-16-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    620

    Re: Adding text to sheet from userform

    Thank you, its been along day!

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Adding text to sheet from userform

    We've all been there

+ 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] Adding new sheet to existing userform
    By darkangl640 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2013, 12:49 PM
  2. Displaying text from a sheet automatically in a userform?
    By keith_darcy1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 08:47 AM
  3. Adding text to a table via a macro or userform
    By h.maleki in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2012, 10:12 PM
  4. Adding Data from UserForm on to a table in a sheet
    By Blackrobe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2010, 01:00 AM
  5. Adding text boxes in userform
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2009, 02:23 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