Results 1 to 3 of 3

Thread: Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...

  1. #1
    Neophyte Mich's Avatar
    Join Date
    Jan 2012
    Location
    Brandon, FL (USA)
    Posts
    1
    Articles
    0

    Question Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello:

    My name is Mich and I'm new to the group and I'm having an issue wth a userform that I created that needs to feed data to an Excel spreadsheet within the same woorkbook.

    I have a user form that requires our engineering team to submit to my department when they are chaning a process router. I have the userform set up, and the code written (incorrectly obviously). What I need it to do is once the engineer enters the data and presses "OK" the form should take the fields and fill out the corresponding Tracking form, with the data from the userform. For some reason, I cannot get it to work.

    Any help that can be given would be greatly appreciated.

    BTW, I am VERY new to VBA!

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    335
    Articles
    0
    You need to add your attachment again as thats corrupt, but you haven't told us what the issue is, here's a bit of code that might help you fathom it out
    Code:
    Private Sub CommandButton1()
    Sheets("Tracking Form").Range("A1")= Me.Textbox1.value
    Sheets("Tracking Form").Range("A" & rows.count).end(xlup).row)= Me.Textbox2.value
    Sheets("Tracking Form").Range("A" & rows.count).end(xlup).Offset(0,2)=Me.Textbox3.value
    Sheets("Tracking Form").Range("A" & rows.count).end(xlup).Offset(1,3)=Me.Combobox1.value
    End Sub
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,209
    Articles
    57
    Blog Entries
    14
    Hi Mich,

    I've deleted the attachment. If you could reply by clicking on "Go Advanced", you can re-upload there.

    I'd be curious as to what steps you used to attach that file previously though... If we can reproduce the issue that allowed you to create an invalid upload link, we may be able to prevent the issue from re-occuring for others.

    Thanks!
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •