| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox cases
Hello!
I am using excel and combobox to give alternatives for user. How to programme following command in VBA: If comboboxselection = 1 Then Copy from 'sheet2'!B45:B52 & paste to 'sheet2'!B58:B65 If comboboxselection = 2 Then Copy from 'sheet2'!C45:B52 & paste to 'sheet2'!B58:B65 If comboboxselection = 3 Then Copy from 'sheet'!D45:D52 & paste to 'sheet2'!B52:B65 .. .. .. repeated sufficient times... Hannu Rantala |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Cases=144 * # of Cases + Pieces | Excel Discussion (Misc queries) | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| repetition cases | Excel Discussion (Misc queries) | |||
| two cases for countif | Excel Worksheet Functions | |||
| Matching 2 cases at once. | Excel Discussion (Misc queries) | |||
Threaded Mode
