+ Reply to Thread
Results 1 to 5 of 5

userform misses data when inventory input

Hybrid View

cfinch100 userform misses data when... 03-24-2013, 02:35 PM
Norie Re: userform misses data when... 03-24-2013, 02:38 PM
cfinch100 Re: userform misses data when... 03-24-2013, 02:57 PM
cfinch100 Re: userform misses data when... 03-24-2013, 04:51 PM
cfinch100 Re: userform misses data when... 03-25-2013, 02:54 PM
  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    userform misses data when inventory input

    hi
    this inventory program works up to a point,frmissued collects from a couple of sheets1 and 2 and writes to another sheet3,frmret collects its data from sheet3
    and also adds data, all is saved to sheet3 where it is combined and posted to sheet4 if all boxes are full,my problem is frmret sometimes as you click comboboxes does not pick up some data so leaves boxes empty,for the life of me do not no why have tried all different code,for some reason misses a line and it not always the same one,have tried all day with no success at all ,can anyone help please,also use conditional for matting to look for duplicates before it posts them as one row to sheet4,is there code to combine as would like to have location from and location to ,frmret is location to but overwrites the first,any help guidance would be good
    please
    start frmissued enter name,location,click comboboxes in turn and then each command button in order,
    start frm ret enter name location is set,click each combobox in turn this is where it misses some data,
    click each command button to right them command 10,all boxes that are full will be posted to sheet4
    cheers colin
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 03-25-2013 at 02:52 PM.

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

    Re: userform misses data when inventory input

    Colin

    Which command buttons are you referring to?

    I tried them all including the 6 small buttons on the right, the only one that did anything was the Exit button.
    If posting code please use code tags, see here.

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

    Re: userform misses data when inventory input

    hi norie
    have put different names on them now ,hope this explains,looks like i have doubled up on command button names,not sure how
    frmret is the one that is not working as it should though
    cheers colin
    Attached Files Attached Files

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

    Re: userform misses data when inventory input

    hi norie
    have tried frmret again it seems that st201 in id number is the one that wont populate some of the time
    cheers colin

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

    Re: userform misses data when inventory input

    hi
    .TextBox6 = ws.Range("f" & .ComboBox1.ListIndex + 3).Value
    sorted this by changing +3 to +2 on all textboxes
    seems to work ok took plenty of time but did it myself
    cheers colin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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