I have been asked by my father to create him a sheet for work, he isn't very good with computers and I haven't used excel or vba for years.
I have managed to automate some tasks for him but there is one I can't workout, I am trying to create a macro to alter the values by 1 when a combination is pressed.
The idea is to allow him to quickly add or subtract multiple values for highlighted cells, for example, he can ctrl + LC on cells b2, b6 and b9 and subtract them by 1.
The code i have at the moment does what I need but only for the active cell and what I would like is the macro to run on all highlighted cells and ideally but not essential, to automatically change to green or red depending on whether or not a value was added or subtracted.
Current code
Sub addOne()
ActiveCell = ActiveCell.Value + 1
End Sub
Any help would be greatly appreciated.
I have managed to automate some tasks for him but there is one I can't workout, I am trying to create a macro to alter the values by 1 when a combination is pressed.
The idea is to allow him to quickly add or subtract multiple values for highlighted cells, for example, he can ctrl + LC on cells b2, b6 and b9 and subtract them by 1.
The code i have at the moment does what I need but only for the active cell and what I would like is the macro to run on all highlighted cells and ideally but not essential, to automatically change to green or red depending on whether or not a value was added or subtracted.
Current code
Sub addOne()
ActiveCell = ActiveCell.Value + 1
End Sub
Any help would be greatly appreciated.