controlling active cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 02 May 2008 17:11 GMT

I have a spreadsheet with 4 columns. I am scanning some bar codes
into the 2nd and the 3rd column. I want to the active cell to change
to the 3rd cell after I scan the bar code for the second column. This
is obviously easy to do. But I want it go to the 2nd column of the
next line after I scan the bar code for the 3rd column. Is there any
way to do this?

Step 1
Description Tag # Serial # Pallet
x
Step 2
Description Tag # Serial # Pallet
x x
Step 3
Description Tag # Serial # Pallet
x x
Description Tag # Serial # Pallet
x

Reply to this Message

Roger Govier - 02 May 2008 18:03 GMT

Hi Mike

One way would be to lock the Scroll area of the sheet.
The following macro will toggle the lock On or Off again.

Sub LockCols()
If ActiveSheet.ScrollArea = "" Then
ActiveSheet.ScrollArea = "B:D"
Else
ActiveSheet.ScrollArea = ""
End If
End Sub

Copy the Code
Alt+F11 to invoke the Visual Basic Editor
Insert>Module
paste the code into the white pane that appears
Alt+F11 to return to Excel

To use
Alt+F8 to bring up Macros
Select LockCols>Run

If the scroll area is set, it will unset it for you.
If it is unset, it will set it.

Signature

Regards
Roger Govier

> I have a spreadsheet with 4 columns. I am scanning some bar codes
> into the 2nd and the 3rd column. I want to the active cell to change
[quoted text clipped - 14 lines]
> Description Tag # Serial # Pallet
> x

Reply to this Message

Mike - 02 May 2008 20:06 GMT

Roger you are the bomb!!! That worked like a charm! You are going to
save me a ton of time. Thank you so much!!!

On May 2, 12:03 pm, "Roger Govier"
<roger@technology4unospamdotcodotuk> wrote:

> Hi Mike
>
[quoted text clipped - 44 lines]
> > Description Tag # Serial # Pallet
> > x

Reply to this Message