+ Reply to Thread
Results 1 to 3 of 3

Private Sub cmdEdit_Click() with 14 fields (columns)

  1. #1
    Registered User
    Join Date
    04-14-2023
    Location
    Salida, California
    MS-Off Ver
    MS Office
    Posts
    1

    Private Sub cmdEdit_Click() with 14 fields (columns)

    Hello

    I need help in creating a code for userForm with 14 fields (columns) to capture. The code I created stops at the 9th column it gives me an error. What Im trying to do is select a record (row) and edit it.

    I hope this makes sense
    Thank you
    Last edited by badookiE#1; 04-14-2023 at 09:30 AM.

  2. #2
    Registered User
    Join Date
    04-10-2022
    Location
    London, England
    MS-Off Ver
    365
    Posts
    20

    Re: Private Sub cmdEdit_Click() with 14 fields (columns)

    What is the error you get? It would be helpful to see what you have done so far
    Giuseppe
    www.effinovate.com

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Private Sub cmdEdit_Click() with 14 fields (columns)

    If you are populating List/Combo box with AddItem, you can only add 9 columns.
    So, store data in an array and load it using .List or .Column property.

+ 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. [SOLVED] Columns fields to be converted as row fields
    By grkchakri in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-15-2022, 12:36 AM
  2. Combine Private Sub and Private Function VBA code
    By thanhthinh1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2018, 06:16 AM
  3. Call Private Function under Private Sub
    By thanhthinh1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-25-2018, 03:23 AM
  4. Hide fields(table columns) from Pivot table Fields
    By alexholly in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2017, 08:24 PM
  5. [SOLVED] Issue with Private sub working with some columns and not others
    By thumperjlp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2013, 06:54 PM
  6. re : Possible to run private sub macros by writing another private
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2005, 12:05 AM
  7. [SOLVED] Private Sub Running Other Private Sub Inadvertently
    By Ross Culver in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2005, 09:06 PM

Tags for this Thread

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