| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data to combobox value sheet
Sheets("Sheet1").OLEObjects("combobox1").Object.Ad dItem "abc"
"TUNGANA KURMA RAJU" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
