Cell,

Ralph56 · Apr 11th, 2002, 03:13 PM

I am setting up a template for ordering material. I want to set a row of cells to accept only one character per cell and have the cursor go to the next cell in the row when keying in a stock number.

[ This Message was edited by: Ralph56 on 2002-04-11 14:13 ]

Jack in the UK · Apr 11th, 2002, 03:15 PM

Hi

try validate so pop up appear if less than 1 and greater than 9 !

Any good

Ralph56 · Apr 15th, 2002, 10:37 AM

Validation works great for the cells to accept only one character per cell. Thanks for tip, and the Excel help screen.

Now, if I could figure out to make the cursor automatically move to the next cell after a character is inserted in the previous cell.

Tom Schreiner · Apr 16th, 2002, 01:16 AM

Hi
Outside of an API function I do not believe you can get a change event out of a cell as you would a textbox on a userform?
Tom

Big Blue · Apr 16th, 2002, 02:14 PM

I don't believe there's any way to have any program move to the next cell until you've told the program the number you've entered is what you want - you do this by htting enter.

If you want to be able to enter 1,2,3,4,5,6 in six horizontally adjacent cells by keying 1,enter,2,enter,3,enter....
go to tools/options/ select 'move selection after enter' and pick a direction - in your case, 'right'

hope this is what you're after

Apr 11th, 2002, 03:15 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi try validate so pop up appear if less than 1 and greater than 9 ! Any good __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 03:13 PM	#1
Ralph56 New Member Join Date: Apr 2002 Location: Worthington, IN Posts: 2	I am setting up a template for ordering material. I want to set a row of cells to accept only one character per cell and have the cursor go to the next cell in the row when keying in a stock number. [ This Message was edited by: Ralph56 on 2002-04-11 14:13 ]

Apr 15th, 2002, 10:37 AM	#3
Ralph56 New Member Join Date: Apr 2002 Location: Worthington, IN Posts: 2	Validation works great for the cells to accept only one character per cell. Thanks for tip, and the Excel help screen. Now, if I could figure out to make the cursor automatically move to the next cell after a character is inserted in the previous cell.

Apr 16th, 2002, 01:16 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Outside of an API function I do not believe you can get a change event out of a cell as you would a textbox on a userform? Tom

Apr 16th, 2002, 02:14 PM	#5
Big Blue Board Regular Join Date: Mar 2002 Location: Ontario Posts: 52	I don't believe there's any way to have any program move to the next cell until you've told the program the number you've entered is what you want - you do this by htting enter. If you want to be able to enter 1,2,3,4,5,6 in six horizontally adjacent cells by keying 1,enter,2,enter,3,enter.... go to tools/options/ select 'move selection after enter' and pick a direction - in your case, 'right' hope this is what you're after