LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sumit
 
Posts: n/a
Default regarding form preparation


i am designing a form in excel. i want only maximum one character/letter
to be entered in a particular cell and once it is entered, cursor/active
cell shifts to adjacent cell.

i tried data validation, it helps in restricting maximum text length to
one but i am not able to shift cursor/active cell to adjacent cell.


--
Sumit
------------------------------------------------------------------------
Sumit's Profile: http://www.excelforum.com/member.php...o&userid=29520
View this thread: http://www.excelforum.com/showthread...hreadid=492207

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I make a form number change everytime the form is opened babydumplingspita Excel Worksheet Functions 1 October 10th 05 07:58 PM
Sumif Linking to Another Workbook error #VALUE! Tunde Excel Discussion (Misc queries) 16 March 4th 05 03:02 AM
How about IRS tax preparation form that helps prepare refunds. childofGod_333 Charts and Charting in Excel 0 February 16th 05 04:19 PM
How about IRS tax preparation form that helps prepare refunds. Krini27 Charts and Charting in Excel 0 February 16th 05 04:19 PM
Trying to delete form border, and it deletes all borders PeterM Excel Discussion (Misc queries) 11 January 3rd 05 03:36 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"