Works great !!! thanks so much
Wilbur
On Jan 26, 2:13 am, Norman May wrote:
> In Excel 2003 go to Tools/Options/Edit then remove the check mark from "Move
> selection after enter".
> Norman
>
>
>
> On Mon, Jan 25, 2010 at 6:38 PM, Wilbur Kush wrote:
>
> > I have a scale that inputs
Hi Wibur,
In Excel 2007 go to Excel options -> Advanced -> uncheck the After Pressing
enter move Selection.
This would suffice.
Regards,
Praveen
On Tue, Jan 26, 2010 at 5:08 AM, Wilbur Kush wrote:
>
>
> I have a scale that inputs data into excel via rskey, a keyboard
> emulator that comes wit
elected cell is A2.
if it is, then it selects cell A1
(note, this will THEN call this routine once again, but since the new cell:
"A1"
is not "A2", nothing happens)
hope this helps,
Paul
From: Norman May
To: excel-macros@googlegroups.com
In Excel 2003 go to Tools/Options/Edit then remove the check mark from "Move
selection after enter".
Norman
On Mon, Jan 25, 2010 at 6:38 PM, Wilbur Kush wrote:
>
>
> I have a scale that inputs data into excel via rskey, a keyboard
> emulator that comes with the scale. No problems getting the data
Dear Wilbur,
You can use a macro to make this happen. The macro should be written in
selection_change event of worksheet, so whenever the cursor move to A2..it
will go back to A1 address of worksheet.
Attached is the solution in macro enabled workbook for your reference.
Please let us know if any
I have a scale that inputs data into excel via rskey, a keyboard
emulator that comes with the scale. No problems getting the data into
excel from the scale, however, a carriage return (enter) is sent after
the weight is entered into field A1. This sends the cursor to A2
after entering the weight
