Hi,
i have an excel file with me with 2 drop down list, currently i would like to use VBA to change the drop down list to such that user will not see all of the drop down list based on the selection they have make
currently is my example excel file that i have highlight and instruction on what to do and be seems, can anyone expert here help me out
thanks
Click in 'A2' - combobox appears - select then appropriate selections appear in combobox in 'B2'
This is all contained within the table confines - to expand type a single character in 'A3' - click to 'B3' and back to 'A3' - your table has expanded ready to repeat selections.
There are no on-sheet formula nor data validation nor formatting everything is contained in the worksheet code module.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hi i just download ur file however i dont see any drop down appear when i select A2
I changed the order of your asset category...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
tested it work perfectlyOriginally Posted by sintek
I changed the order of your asset category...
Please Login or Register to view this content.
what this mean ?
xlBetween, Formula1:="=Sheet2!E" & Rw & ":E" & Rw + 2 & ""
and
Rw = IIf(Indx < 8, 2, 5)
this is row and cell with 8, 2, 5 ?
sorry i need to apply this to my main where the row and sheet maybe different
Check the position of the selected value in the Asset Category List
Check start row on Method of Disposal List for other dropdown data row 2 or row 5Please Login or Register to view this content.
Populates other dropdown with list i.e. E2:E4 OR E5:E7Please Login or Register to view this content.
Thanks for rep +Please Login or Register to view this content.
Last edited by sintek; 04-26-2023 at 06:03 AM.
Sir i need ur help to add on if i want my Column C to be back to E2:E7 in a dropdown when i delete my Column A value how can i do it ?Check the position of the selected value in the Asset Category List
Check start row on Method of Disposal List for other dropdown data row 2 or row 5Please Login or Register to view this content.
Populates other dropdown with list i.e. E2:E4 OR E5:E7Please Login or Register to view this content.
Thanks for rep +Please Login or Register to view this content.
Firstly...No need to quote entire posts...It just clutters the thread...
Replace this...
With...Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you sir, it work as what i wan
as i wan If I choose 3G, 4A, 4B, 4C, 4H, 4K, 4P, I will only be able to see Sale (Default), Dumping/Destruction, Donation to Charity
is there a way where in above statement i can see "Sale (Default) selected in my drop down list on column C ?
Answered in other thread hereis there a way where in above statement i can see "Sale (Default) selected in my drop down list on column C ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks