Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data to combobox value sheet
I have a userform, with a combobox ,its list values are sheets names of
activeworkbook.it has 4 textboxes(input) ,after inputting data in these boxes,the values be copied to (combobox1.vaue)w/sheet last row.I am using line code worksheets(.combobox1.value).activate Range("A1").select Do then the code follows to find last empty cell. When I run this sub I am getting error 'object required'. How to select Combobox1.value sheet?what is line of code? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Fill combobox from data in different sheet | Excel Programming | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Combobox data accidentally copied on different sheet | Excel Programming | |||
User Form-error 1004 unless opened in sheet w/combobox data | Excel Programming |