ScoobyNet.com - Subaru Enthusiast Forum

Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel Question

Thread Tools
 
Search this Thread
 
Old 29 November 2002, 04:48 PM
  #1  
BuRR
Scooby Regular
Thread Starter
 
BuRR's Avatar
 
Join Date: Dec 2001
Location: Was Wakefield, now London
Posts: 5,210
Likes: 0
Received 0 Likes on 0 Posts
Post
Should be an easy one for you guys

I want to enter a string into a field/cell and when specified number of characters has been reached (in this case just the 1) I want Excel to automatically ENTER and tab to the next cell on the right without the user having to press ENTER or TAB.

Can someone educate the uneducated, please?
BuRR is offline  
Reply Like
Old 29 November 2002, 07:47 PM
  #2  
nkh
Scooby Regular
 
nkh's Avatar
 
Join Date: May 2002
Posts: 633
Likes: 0
Received 0 Likes on 0 Posts
Post
Use Access instead?

You can always export the data to excel for analysis
nkh is offline  
Reply Like
Old 29 November 2002, 09:47 PM
  #3  
BuRR
Scooby Regular
Thread Starter
 
BuRR's Avatar
 
Join Date: Dec 2001
Location: Was Wakefield, now London
Posts: 5,210
Likes: 0
Received 0 Likes on 0 Posts
Post
No - its for an automated-type-thing.... the user inputs the data directly.

Can it be done?
BuRR is offline  
Reply Like
Old 30 November 2002, 09:19 AM
  #4  
BuRR
Scooby Regular
Thread Starter
 
BuRR's Avatar
 
Join Date: Dec 2001
Location: Was Wakefield, now London
Posts: 5,210
Likes: 0
Received 0 Likes on 0 Posts
Post
bump
BuRR is offline  
Reply Like
Old 30 November 2002, 09:30 AM
  #5  
monkeyboy
Scooby Regular
 
monkeyboy's Avatar
 
Join Date: May 2002
Location: Hanging around sussex
Posts: 563
Likes: 0
Received 0 Likes on 0 Posts
Post
Mate

You should be able to write a small macro to do this very easily. look up macros in the excel help theres a fair bit of info on this.

monkeyboy is offline  
Reply Like
Old 30 November 2002, 12:00 PM
  #6  
jods
Scooby Senior
 
jods's Avatar
 
Join Date: Feb 2002
Location: UK
Posts: 6,645
Received 0 Likes on 0 Posts
Post
If it is only 1 character I assume it is either a - z or 0 -9 ?
If that is the case why not set up as a drop down selection box.
jods is offline  
Reply Like
Old 30 November 2002, 12:53 PM
  #7  
Thunder77
Scooby Regular
 
Thunder77's Avatar
 
Join Date: Jul 2002
Location: Northants Gamertag: ThunderXUK
Posts: 554
Likes: 0
Received 0 Likes on 0 Posts
Post
You might not be able to achieve this without creating a form as it doesn't look like Excel can react to keypress events on a worksheet.

Thunder77 is offline  
Reply Like
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
2004 (54) Blue JDM Widetrack STi Fresh Import
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Lateral MD321H Billet turbo
leg200
Subaru Parts
5
07 October 2015 07:31 AM
New car new problems - alcatek
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM
Back to Subforum
Computer & Technology Related
View Next Unread
Buying second hand games from Game




Advanced Search
Quick Reply: Excel Question


Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 04:33 PM.