Results 1 to 4 of 4

Thread: I need help writing VBA code

  1. #1
    Junior Member
    Join Date
    Aug 2015
    Posts
    3
    Rep Power
    0

    I need help writing VBA code

    I am new to writing VBA code and would like some help please. I have manage to use a small amount of code and also created a userform and a sheet where data is to be transferred.

    Where i need help is once the userform is populated, i select the transfer button and it then transfers the data to a sheet called records.The entries just find the last row beneath the last entered entries.

    All 3 combobox`s and textbox must have entries before the data can be transferred.

    Is this a possibility?

    Thank you

    Chris
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Aug 2015
    Posts
    3
    Rep Power
    0
    I have since added some code but it places down the first column instead of across the sheet. What changes do i need to make to get the entry to go across the columns in the same row?

    Thank you
    Attached Files Attached Files

  3. #3
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    See in attach.

    I renamed ComboBox and buttons and I put a code to retrieve data from ComboBox in table.
    Hope it help.
    Attached Files Attached Files
    Last edited by Ingolf; 08-05-2015 at 06:26 PM.

  4. #4
    Junior Member
    Join Date
    Aug 2015
    Posts
    3
    Rep Power
    0
    Ingolf, yes thank you for help

Similar Threads

  1. Replies: 2
    Last Post: 01-27-2015, 08:29 PM
  2. Replies: 0
    Last Post: 01-24-2015, 03:50 PM
  3. Re writing a code?
    By justme1052 in forum Excel Help
    Replies: 2
    Last Post: 01-23-2014, 09:21 PM
  4. Replies: 1
    Last Post: 08-23-2013, 06:33 PM
  5. Shorten VBA Code By Removing Redundant Superfluous Code
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 08-15-2013, 09:09 PM

Posting Permissions

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