+ Reply to Thread
Results 1 to 10 of 10

Combox Save Index Column PROBLEM

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Combox Save Index Column PROBLEM

    Hello.
    I am try to make a save from a combox that have 7 combox, this will be the causes from a stop machine.
    On this particulary case i can choose from 1 to 7 causes from a stop, and in the End i want Save it.
    I make this code but i have a problem, with this code i dont save nothing, its because the index column, but i dont know how to solve that.
    See more details on the CODE


    Please Login or Register  to view this content.
    Last edited by nunocabete; 06-15-2016 at 06:59 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Combox Save Index Column PROBLEM

    Hi,

    You need to change the '3' indicating column C. e.g.

    Please Login or Register  to view this content.
    ..etc...
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Combox Save Index Column PROBLEM

    I now that the problem its the code where goes to see where its the first empty cell.

    Please Login or Register  to view this content.
    Because my intencion its record several in the same column.
    Baseclly if i have values in cbobox1 record it at B2 if i have values on Cbobox1 a Cbobox2 record it on "Plan17"B2 and B3 .....

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Combox Save Index Column PROBLEM

    ...Sorry but I don't understand what you are asking for.

    As a minimum you'll need to upload the workbook and tell us how you use it.

    You'll need to tell us what you do and give us a schedule of inputs you make and what the results should be and where they should appear.

  5. #5
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Combox Save Index Column PROBLEM

    I dont know how to put in attachmente . dont work.

    But send the link to the file.


    https://www.dropbox.com/s/v5m0y8lz0w...0box.xlsm?dl=0

    I want that if i have more then one reason for stop , in this case choose several reason all from the same column in this case Plan16 and we record it all in the same column in the Plan17
    Last edited by nunocabete; 06-15-2016 at 04:26 AM.

  6. #6
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Combox Save Index Column PROBLEM

    What i want its save multiple combobox values i one column

  7. #7
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Combox Save Index Column PROBLEM

    Hope the atttchent be ok
    Attached Files Attached Files

  8. #8
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Combox Save Index Column PROBLEM

    Hi,
    Your OP mentioned 7 combo boxes. The file you uploaded has 6. Please clarify.

    When you enter a value in each one where do you want the entry to appear. Please clearly indicate the sheet and the cell addresses.

    The next time the userform combo boxes are used, where should the next entries be recorded?

  9. #9
    Registered User
    Join Date
    05-30-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    37

    Re: Combox Save Index Column PROBLEM

    Already corrected
    I send one part of the sheet because i have 29 forms and each are directed for one machine from the asembly.
    All this work just to give reasons for the loosing performance
    Insted of what i said before,can i save all the combobox values in the same sheet but in the same cell and the values became separed by "-" for example.

  10. #10
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Combox Save Index Column PROBLEM

    You really need to offer some specific examples in a workbook. At the moment I can only guess at how you expect this to look.

    Map out a schedule of entries that you make that clearly identify the value you enter, where you enter them where the results end up and manually add the results in the workbook.

+ 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. Combox problem
    By nunocabete in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2016, 08:46 AM
  2. [SOLVED] Search by cell value index-match save problem
    By kunkka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2016, 10:14 AM
  3. [SOLVED] Converting Hlookup to Index Match with variable column index number
    By SimonLock in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2015, 09:14 AM
  4. Update Combox with Slicer items - getting error on Combox.listcount
    By Bigkx06 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 02:47 PM
  5. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  6. [SOLVED] Conditional Combox Result to textbox problem
    By bigfoot007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2012, 09:04 AM
  7. INDEX and 2 column MATCH problem
    By 5foot9 in forum Excel General
    Replies: 0
    Last Post: 07-24-2011, 11:59 AM

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