How to go to a particular cell while input its content in a box
Closed
vinaymaithani
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
-
Apr 17, 2014 at 03:55 AM
Blocked Profile - Apr 17, 2014 at 04:30 PM
Blocked Profile - Apr 17, 2014 at 04:30 PM
Related:
- How to go to a particular cell while input its content in a box
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- Summertime saga downloadable content - Download - Adult games
- Efootball 2022 downloadable content - Download - Sports
- How to input @ in laptop - Guide
- Fifa 23 downloadable content - Download - Sports
3 responses
Ok, give this a shot, paste into the VBA Code Pane. Let us know how it works:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim thecolumn
thecolumn = Cells(1, 1).Value
'MsgBox (thecolumn)
Cells(1, thecolumn).Select
End Sub
Very Simple.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim thecolumn
thecolumn = Cells(1, 1).Value
'MsgBox (thecolumn)
Cells(1, thecolumn).Select
End Sub
Very Simple.
vinaymaithani
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
Apr 17, 2014 at 01:56 PM
Apr 17, 2014 at 01:56 PM
Thanks ac3mark,
Love the quote of yours !
Thanks for the code and it works too, but i have an exception for it as well.
My data is arranged in columns but the column headers have data as '100', '101' till '250'.
Now can the same code be modified so that i can enter only the data and the cursor moves to the corresponding column position.
Do you get the requirement ?
Regards
Vinay
Love the quote of yours !
Thanks for the code and it works too, but i have an exception for it as well.
My data is arranged in columns but the column headers have data as '100', '101' till '250'.
Now can the same code be modified so that i can enter only the data and the cursor moves to the corresponding column position.
Do you get the requirement ?
Regards
Vinay
So, your first column is labled as column 100. Take the code and subtract an offset number from the data entered, would that work?
So:
thecolumn = Cells(1, 1).Value - 98
...or some other OFFEST value?
Notice in my example, the first column is reserved for entry, so the offset number would now 98 as the column labeled 100 is in the second position of the indexed columns.
It works for me.
Or, are you asking to select the whole column, not just the cell?
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
So:
thecolumn = Cells(1, 1).Value - 98
...or some other OFFEST value?
Notice in my example, the first column is reserved for entry, so the offset number would now 98 as the column labeled 100 is in the second position of the indexed columns.
It works for me.
Or, are you asking to select the whole column, not just the cell?
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
