-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
target.offset1
-
R
Need help tweaking VBA code
Hi all I am using the code below with a BeforeDoubleClick event. I need help for the =CJ3 to be relative. If Not Intersect(Target, Range("c:c")) Is Nothing Then 'change this column to suit Target.Formula = "=CJ3" Target.Offset(1, 0).Select End If Thank you!- Russk68
- Thread
- =cj3 code suit target.formula target.offset1
- Replies: 2
- Forum: Excel Questions
-
P
Case Statement
Good morning, I need help to amend the following code. What should happen is this: the first thing that I do in my worksheet is to type in the activity name (ie run) in a cell. Then I type in the distance in the cell below (ie 10). When both values are typed in, I would like the...- PierreT
- Thread
- calculation case cell target.offset1 target.offset2
- Replies: 8
- Forum: Excel Questions
-
R
VBA - Making the double click event unique
Hi All, I run the following code to capture the current time in certain fields. All that the user does is double clicks a cell to enter the current time. However, if they in error click the field again, then it overwrites the captured time with the current time. Is it possible to exit the...- REUBEN
- Thread
- click end target.offset0 target.offset1 time
- Replies: 6
- Forum: Excel Questions
