Help me regarding userform combo box update from Range table

[mebro]

Hi Team,

I have sheet name "Details" with different Range table columns like Table1,Table2,Table3 with data, i am using a userform with 3 comboboxs which are getting the data while form initialization from table1,table2 and table3 respectivley.

my requirement is :

i want to show the combobox values by latest value in the top of combobox and want to show filtered data only from the tables(if i uncheck any value in the table it should not show up in combobox)

thanks in advance

[Leith Ross]

Hello Mebro,

Show your work by uploading your workbook or posting the code you are using. Be sure the code you post is either the original or a faithful example. Provide both before and after examples of the data for reference.

[mebro]

thanks for your reply Leith Ross,

i am attaching the sample file, when you double click on any date in the calendar sheet, it will show up a user form with comboboxes(getting data from "Details" sheet).

i have unchecked the app5 in App range table, but its showing the combobox. i want to skip that and i want to show the latest entry in that table as top value in the combobox.

thanks in adavance.

[mebro]

Hi Team,

can someone help me on this..


thanks in advance

[mebro]

please consider the updated worksheet with this post