Results 1 to 1 of 1

sheet not returning data as should

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    sheet not returning data as should

    hi
    have been having problems recalling all data from (sheet1)
    userform 4 is supposed to write data to (sheet1) and sheet( repairs),it does write to sheet1 but not (repairs), if I go to userform 4 and type in combobox say s120 only some data is recalled not quite sure what ive done wrong has anyone any ideas please
    ws.Range("K" & c.Row).Value = Me.TextBox3.Value    'OVERHAULED DATE
                ws.Range("I" & c.Row).Value = Me.TextBox4.Value    'SCRAPPED DATE
                ws.Range("l" & c.Row).Value = Me.TextBox1.Value
                ws.Range("m" & c.Row).Value = Me.TextBox7.Value
    these lines send data to sheet1 but only the top 2 are recalled
    to open there is a commandbutton on userform 1 under goods issued
    cheers colin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Returning filtered data to a new sheet in a multiline cell
    By yankeesrus07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2016, 04:21 PM
  2. [SOLVED] returning data from different sheet
    By tspevak in forum Excel General
    Replies: 26
    Last Post: 06-15-2015, 12:25 PM
  3. Returning data from a different sheet dependent on two conditions
    By rockp3nguin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2013, 06:16 AM
  4. Need Formula for returning data from another sheet
    By RDMRDM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2009, 07:51 AM
  5. Replies: 5
    Last Post: 04-13-2007, 06:58 PM
  6. Returning data from another sheet
    By Talbot in forum Excel General
    Replies: 2
    Last Post: 04-02-2007, 10:23 AM
  7. Returning data to Excel sheet from MS query
    By SNB in forum Excel General
    Replies: 0
    Last Post: 04-26-2005, 09:06 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