+ Reply to Thread
Results 1 to 2 of 2

How do I add a selected range of value from combobox in userform?

  1. #1
    Registered User
    Join Date
    10-11-2019
    Location
    USA
    MS-Off Ver
    Excel 2016 and 2019
    Posts
    1

    How do I add a selected range of value from combobox in userform?

    Hi everyone,

    I am trying to add a range value together but i cant seem to figure out how to do it.

    The idea is that the user will select from which Item ID to which Item ID he/she wants in the userform ComboBox1 and ComboBox2, then after pressing "OK" the coding should be able display the selected Item ID range and the addition of "Price of 1" , "Price of 2" and "Price of 3" for the selected range individually in sheet 2.

    I also cant figure out how to put the Item ID name into the ComboBox1 and ComboBox2 as the quantity of Item ID and pricing will increase over time therefore, i cannot use the .AddItem.

    It is possible to do it? Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How do I add a selected range of value from combobox in userform?

    Hi

    Welcome to the Forum.

    I will look at this for you:

    Your requirement is not very clear.

    I have created something to get you started:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-12-2019 at 07:28 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. Setting the selected row in a 2-column combobox on a userform
    By DougieJLockhart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2019, 05:11 AM
  2. [SOLVED] How to recall last selected item in a userform combobox?
    By thedefense in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2014, 10:09 AM
  3. [SOLVED] Pass Value of combobox selected in Userform as input to textbox of other userform
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 10:32 AM
  4. Edit a selected Combobox with another userform
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2013, 04:20 AM
  5. [SOLVED] Goto cell selected from userform combobox
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 05:28 PM
  6. display images on the userform when something out of a combobox is selected
    By Ghosty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 06:07 AM
  7. Determine Selected Item in a (Userform’s) ComboBox
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2012, 09:07 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