How to update "Multiple records on a Userform"?

[rksample]

Dear Experts,

I have one problem to be solved.

I am working a project on "Inventory Management". I am preparing an application with user interface only as UserForms. There will be no direct working on the spreadsheets.

I have a worksheet with inventory of multiple items (bolts), every item with a specific "ID" and a "Status" tag to display if it is "Available, Out of Stock, In Godown"

When we update the stock, I want to be able to load all the "Out of Stock" items in the userform and their status in Combobox. For those items which we get stock, I'll change the status as "Available" and submit, which should modify the spreadsheet.

1. What is the best way to display multiple records on the userform for status updates (I use flexgrid for such a scenario in VB6)?
2. Is there any control that we can use in excel that is convenient to user for more records (like 20 records)?

Please help me with a solution.

Thanks in advance for the help,
Ravi Kiran.

 

[Norie]

Ravi

To display multiple items you can use Listbox.

You would need to do the updating yourself though, but that wouldn't be too difficult.

Also, you can't have a combobox within the listbox.