+ Reply to Thread
Results 1 to 3 of 3

Values not posting to cells using form

  1. #1
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Values not posting to cells using form

    Hello. I used chatgpt to get the following code which is posted in the Forms section under "TruckLoanForm". The form opens, i put in values, i hit the enter button, but it does not post the values. The values should be posted to the following cells:

    FE5, FF5, FG5, FH5, FJ5, FL5, FM5 on the "Tables" sheet.

    I'm also trying to make it so that every time the button that activates the macro is pressed, it will add a new entry series to the next row (in this case 6, 7, 8, and so on).



    Please Login or Register  to view this content.

  2. #2
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Re: Values not posting to cells using form

    This is the code I have in the module:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Values not posting to cells using form

    see big yellow banner - how to upload your workbook - far easier to then give you an in-context solution.
    that seems a lot of code to achieve nothing,
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Form Data Posting Outside of Table
    By TRH79 in forum Excel General
    Replies: 1
    Last Post: 01-07-2022, 12:50 AM
  2. [SOLVED] Take values from user form to cells in a certain row
    By Victor-J in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2017, 09:35 AM
  3. Replies: 4
    Last Post: 12-27-2013, 04:30 AM
  4. [SOLVED] User Form not posting in the first row, but will not post in the next row
    By johna2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 01:26 AM
  5. User Form Data Posting to a single cell
    By aad401 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 07:21 PM
  6. posting textbox data from a form into a worksheet
    By cH3wY in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2007, 06:22 AM
  7. [SOLVED] Is there way to enter multiple values into excel cells w/ a form?
    By grassfed in forum Excel General
    Replies: 1
    Last Post: 06-22-2005, 04:05 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