ListBox in Excel Sheet
Query:
I have one List Box Populated with some meaningful data (Code_Description) from database.I want to update the listbox in the excel sheet(that listbox is associated with the cell),every time the user enters something in the ActiveCell-Cum-listbox.
ex - Suppose the user presses something like 444 in the cell,the listbox will get updated and contain the entries starting with Code = 444
Again If the user erases the 444 from the ActiveCell, the listbox will show all the data (that was fetched earlier from database but kept in the hidden sheet .. listbox is getting populated from that hidden sheet).
Please provide the code for the same.
|
