+ 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
    MS-Off Ver
    Excel 2016 and 2019

    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
    London England
    MS-Off Ver
    MS 365 Office Suite.

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


    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.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


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