PDA

View Full Version : Table View In user form..



chachu
12-19-2011, 07:53 AM
Hi all,

Im totally new to VBA so please be kind :)


What im trying to achive is, i need for form where i need to be able to populate one column with a list of models from one sheet and the second column i should be able to copy paste a list or even manual enter the qty for the that model.

Once im done all that data should be saved to a second sheet.


Now where im stuck is what tool to use to be populate a list and then enter the data in front of it.


If you can help plz. or just guide me in the right direction :help

mdmackillop
12-20-2011, 04:29 AM
You cannot use a listbox in that fashion. Here's an alternative for consideration.

chachu
12-20-2011, 04:42 AM
Im sorry for being stupid, but i keep getting an "file croupted" error whenever i try to open the file.

infact its the same with all the files i try to open on these forums...
Am i missing something,...

mdmackillop
12-20-2011, 04:49 AM
Can't see why that should happen. Try a different browser.
I've posted the file here (http://dl.dropbox.com/u/32560094/DataEntry.xls)

chachu
12-20-2011, 04:57 AM
Internet Explorer worked, Chrome did not.

Dear md,

your solution works very nicely. And almost exactly what i want.

However for every entry i have to click transfer data.
is there a way for me to edit all the row at once and then click trasfer data???

Thank you for your help.

mdmackillop
12-20-2011, 05:23 AM
is there a way for me to edit all the row at once and then click trasfer data???

I can't think of a simple method offhand. Try this revision

mdmackillop
12-20-2011, 05:24 AM
You could, of couse do it on a worksheet, and copy the data from there.