+ Reply to Thread
Results 1 to 4 of 4

Results depending upon selection from listbox

  1. #1
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    236

    Results depending upon selection from listbox

    Hi,

    Thanks for looking at my post.

    I am kind of stuck with vba code (Actually need help with creating vba code please)

    I have listbox1,Textbox1 and Textbox2.

    Depending upon number of items selected in listbox1 is there any way to get Textbox2 = Textbox1 X number of items selected from listbox1 ?

    Example: If there are 5 items in listbox1, no. of items selected is 2, and Textbox1 = 10 and therefore Textbox2= 10 X 2 = 20

    Any idea guys?

    Much appreciated for your time

  2. #2
    Forum Contributor
    Join Date
    01-21-2021
    Location
    Leeds
    MS-Off Ver
    2016
    Posts
    236

    Re: Results depending upon selection from listbox

    Any idea guys?

    Thanks

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,344

    Re: Results depending upon selection from listbox

    This one works with a CommandButton.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: Results depending upon selection from listbox

    sorry, if I am mistaken to get what you mean

    Please Login or Register  to view this content.
    2021-08-16_17-39-01.gif
    Last edited by karmapala; 08-16-2021 at 05:50 AM.

+ 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. Value depending upon selection of Listbox data
    By jimpatel1993 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-13-2021, 06:25 AM
  2. Populate (ca 200) Txtboxes depending on listbox selection, live-filter for listbox &1 more
    By InternInNeed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2016, 09:56 AM
  3. Show dynamic data depending on selection of item from listbox.
    By MOHAMMESALMAN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2015, 02:21 AM
  4. Userform ListBox depending on a previous Listbox selection
    By Figolu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2015, 04:31 PM
  5. Userform ListBox depending on a previous Listbox selection
    By Figolu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2015, 02:08 PM
  6. [SOLVED] Indexing proper range in listbox depending on selection in previous listbox
    By bloodmeat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 02:31 PM
  7. Action depending on Listbox Selection
    By audioboxer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2012, 02:51 PM

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