+ Reply to Thread
Results 1 to 22 of 22

add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

  1. #1
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Hi guys
    first I want to populate values for textboxes for two columns based on one of the optionbutton is selected
    if I select combobox1 will populate values in (combobox2,3,4 & textbox1),if I select combobox5 will populate values in (combobox6,7,8 & textbox2),if I select combobox9 will populate values in (combobox10,11,12 & textbox3)based on column F. now I want if I select optionbutton1(COST ) and if I select combobox1 ,combobox5,combobox9 will populate values in others comboboxes , textboxes based on column F, if I select optionbutton2(SALES) and if I select combobox1 ,combobox5,combobox9 will populate values in others comboboxes , textboxes based on column G with using array & dictionary for big data
    note: should show the currency , format number into textboxes
    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    thank, but I think need fixing because when select optionutton Sales just populate values into textboxes based on column F I have to select optionbutton Cost and return select optionbutton Sales to populate values based on column G how can I fix this problem,please?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Please Login or Register  to view this content.
    Clear Text/OptionButtons when COMBOBOX selected.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Mussa-A,
    Do you really need so many comboboxes?

    Heres with list box.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @JohnTopley thanks

  7. #7
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @AliGW still doesn't work when I try to reply for mr.jindon

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    It does - you have just posted!!! So what exactly are you trying to do?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  9. #9
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    it doesn't work .I will send you in PM what I try to post it

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    You won't be able to post it in a PM, either, if the forum thinks that it is HTML code.

    I suggest you attach a .txt file containing your code.

  11. #11
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    OMG!!! even PM doesn't accept my message . so I will capture the picture .

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Please see my last post.

    It will be something that the forum software thinks is malicious HTML code. It's a security measure.

  13. #13
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @jindon thanks
    actually I wish doing by many comboboxes but after I see your file I like it . can you make it populate the others comboboxes without choose from me .I mean if I choose combobox1 based on column B should fill items in combobox2,3,4 without I choose for each combobox 2,3,4 individually
    it doesn't work I will send you in PM what I try to post it
    Last edited by Mussa-A; 08-07-2022 at 05:14 AM.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Try changing the word 'select' to 'choose' - see if that works.

  15. #15
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    See the attached.
    Attached Files Attached Files

  16. #16
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @jindon thanks very much

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Please try what I suggested just so that I can eliminate this as a problem. Thanks.

  18. #18
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @AliGW sorry I don't note it
    I edited th post#13 and works

  19. #19
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @jindon can I copy data from listbox to specific sheet is name DATA and start from row2
    thanks again

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    Thank you - very helpful.

  21. #21
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    1) add a worksheet and name it as Sheet2.
    2) Add one CommandButton and name it as cmdSend.
    Please Login or Register  to view this content.

  22. #22
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: add array & dictionary to multiple comboboxes,optionbutton to populate textboxes

    @jindon thanks so much for every thing

+ 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. [SOLVED] populate values into multiple textboxes based on optionbutton & combobox
    By Alaa-A in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2022, 04:56 AM
  2. [SOLVED] can use this code by dictionary to interlinked 3 comboboxes
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2021, 12:21 PM
  3. Replies: 18
    Last Post: 10-24-2018, 07:39 AM
  4. Populate texbox from multiple comboboxes
    By Andelousiano in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2017, 01:33 PM
  5. Fill multiple comboboxes (10) from one source (sheet) and textboxes accordingly
    By djemy1975* in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-10-2016, 04:37 AM
  6. Cant get data to populate in VBA code from array & scripting dictionary
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2015, 04:38 AM
  7. UserForm with Multiple ComboBoxes Populate
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-27-2006, 01: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