Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference the cell address next to Active cell - Try 2
Frank & Tom help me with my previous request but unfortunately I have to
approach the obstacle from another angle. My user choose something from the my combo box (2 columns of data displayed in combo box - Number & Description) and the VBA code add the value from BOUNDCOLUMN 1 to the active cell how can I add the value from COLUMN 2 into the cell to the right of the active cell. Your help would be appreciated. Regards Nico |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference the cell address next to Active cell - Try 2
Hi
to reference the cell right to the active cell try ActiveCell.Offset(0,1).value = your value -- Regards Frank Kabel Frankfurt, Germany Nico Le Roux wrote: Frank & Tom help me with my previous request but unfortunately I have to approach the obstacle from another angle. My user choose something from the my combo box (2 columns of data displayed in combo box - Number & Description) and the VBA code add the value from BOUNDCOLUMN 1 to the active cell how can I add the value from COLUMN 2 into the cell to the right of the active cell. Your help would be appreciated. Regards Nico |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference the cell address next to Active cell - Try 2
the combos ListIndex Property points to the selected
values with combobox Target.Value = .List(.Listindex,0) Target.Offset(0,1).Value = .List(.Listindex,1) end with Patrick Molloy Microsoft Excel MVP -----Original Message----- Frank & Tom help me with my previous request but unfortunately I have to approach the obstacle from another angle. My user choose something from the my combo box (2 columns of data displayed in combo box - Number & Description) and the VBA code add the value from BOUNDCOLUMN 1 to the active cell how can I add the value from COLUMN 2 into the cell to the right of the active cell. Your help would be appreciated. Regards Nico . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference the cell address next to Active cell - Try 2
Thanks Patrick it works. Saved me a lot of time.
"Patrick Molloy" wrote in message ... the combos ListIndex Property points to the selected values with combobox Target.Value = .List(.Listindex,0) Target.Offset(0,1).Value = .List(.Listindex,1) end with Patrick Molloy Microsoft Excel MVP -----Original Message----- Frank & Tom help me with my previous request but unfortunately I have to approach the obstacle from another angle. My user choose something from the my combo box (2 columns of data displayed in combo box - Number & Description) and the VBA code add the value from BOUNDCOLUMN 1 to the active cell how can I add the value from COLUMN 2 into the cell to the right of the active cell. Your help would be appreciated. Regards Nico . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use the active cell address as a value | Excel Discussion (Misc queries) | |||
Get Address of Active Cell | Excel Discussion (Misc queries) | |||
How do I reference the cell address next to Active cell | Excel Programming | |||
Getting active cell address | Excel Programming | |||
How to get the active cell address? | Excel Programming |