Dependent Dropdown list through VBA
Hello Friends,
I want enter data in a table through dependent dropdown list. It should work purely on vba code. It will be helpful if code use cell ranges instead of giving names of respective items in code. If any value in the cell range/reference changes, it should be changed automatically in the both dropdown list. It means code should automatically get updated with the change in the text in given reference. For reference sample sheet is attached.
Thank you in advance....
give the attached a trial - the table will extend by placing the Sr.No. in the next vacant cell immediately below the last row of the table.
The comboboxes only appear within the table - there are only two comboboxes (one in each column)
There are no on-sheet formula - no conditional formatting - no on-sheet data validation - the table is dynamic as are the comboboxes.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Thanks for your reply. Its dependent dropdown working fine.
But it only works for single row and not for other rows of the table. Also it operates only with the help of Mouse and not with keyboard.
Thanks again for help.
Did you not read the instruction - first place your Sr.No. in column 'A' - then click in adjacent cell (column 'B') you will note the 'structured table' expands dynamically.
As the table expands so does the application of the dropdowns - it deliberately does not work outside of the table.
How do you envisage it working without the mouse - what key-presses do you anticipate using for selection in the drop-down
Oh yes got it now. Thanks. Working fine. Just one more thing. Can you put one more thing? As i have large number of data to enter, it becomes easy with keyboard only. Can i dropdown combobox with down arrow or can it be automatically dropdown if i select it? ThanksOriginally Posted by torachan
Did you not read the instruction - first place your Sr.No. in column 'A' - then click in adjacent cell (column 'B') you will note the 'structured table' expands dynamically.
As the table expands so does the application of the dropdowns - it deliberately does not work outside of the table.
How do you envisage it working without the mouse - what key-presses do you anticipate using for selection in the drop-down
Another option:
See if this version of dependent data validation suit you (check post 7):
https://www.excelforum.com/excel-gen...ml#post5583005
as it is a data validation not a combobox then you can press ALT+Down Arrow to show the list.
Last edited by Akuini; 01-20-2022 at 04:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks