+ Reply to Thread
Results 1 to 2 of 2

Adding to Userform in situ

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007
    Posts
    3

    Adding to Userform in situ

    Hi everyone

    I'm creating a file to keep track of transactions so that it can be seen what items have been sold, and to whom.
    I'm now wanting to use a userform to input the data into the form instead of doing it directly.

    I have a table with all of the items for sale, and on the userform i've connected this to a combo box so that the user can choose the item if it is sold.
    Is there any way that, once an item has been chosen on the userform, it will automatically create a new combo box on the next line to choose item number 2, then item number 3... et cetera... Is there also a way to make it AUTOMATICALLY create these combo boxes with IDs such as "Item1", "Item2", so that i can use another macro to copy the data from the userform onto the transactions worksheet?

    Hopefully somebody can help
    Thanks
    Ben

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Adding to Userform in situ

    I'm assuming there isn't any maximum to the total number of items sold? How about every time an item is selected it is added to a listbox and you can reuse the same combobox to select the next item? You could then have a button to remove items from the listbox if a mistake is made or someone changes their mind.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ 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. Adding data through a userform
    By hey1000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2010, 01:45 PM
  2. Adding & Multiply various txt..value in userform
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2010, 01:22 AM
  3. Adding MsgBox to Userform
    By buckchow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2007, 12:45 AM
  4. [SOLVED] adding userform command buttons
    By borg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2006, 12:15 PM
  5. Adding controls to userform
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2005, 08:06 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