hi.
i've one excel file with a lot of sheet and data on them. they are structured like that:
i've list box with list of items there ( sectors) and checkbox with amount. i want to choose sector name from list box and amount from checkbox. how can i define so that,when this Sector and this checkbox selected show on B2:L2 row information from "S1" sheet's B4:L4?
Something like this:
If listbox item index 2 selected and checkbox 6 checked , then show info from row B4:L4 in row B2:L2 .
You will receive an answer much faster if you can provide a workbook with an example instead of describing all details in words.
1. Reply to thread and inform if suggestion was helpful or not
2. Click on the star (=Add Reputation) if you think someone helped you
3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")
you are right.Book1.xlsx
In this file please see, if you select Sector from list and amount show data from specific row.
For example if Sector A and 1000 amount selected, show on E11:G11 A A A
I have attached an example in subsequent file:
ListboxesAndOptionbuttons.xlsm
Thank you so much!Originally Posted by Joakim N
i try to adapt this to my sheet,but it shows an error. can you please tell me what is wrong?
can you please help to adapt it to my sheet? i thought i can do this - but error appears.
when First item on listbox and first radio button cliecket it should show the information from Salaried clients sheet A5:M5
risk_framework.xlsx
I have adapted so 'Business Clients' works. I see that you have more sheets but I have not adpted them.
I have used ActiveX controls instead of Form controls in 'Sheet1'.
In your sheet 'Buzniess clients':
- Most left cell above each range must be Yellow background & Unmerged. Yellow because I use this color as a reference to identify the ranges. You can use another color than Yellow. However, the color must be unique and you must update the VBA code.
risk_framework.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks