Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update one cell as soon as you start typeing in another
Hi,
Is it possible to get one cell to update on the begining of typing in another cell, eg Make the contents of Cell A1 = 1 as soon as the user starts typing into cell A2? If it is what formula would i use? I realise that it is possible to make cell A1 = 1 once you have entered something in A2 and pressed enter or tab, but our users would like the 1 to appear as soon as they have started typing into A2. Hope this makes sense 8-) Thanks in advance Tanya |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update one cell as soon as you start typeing in another
Tanya,
In a word, no. You could, however, use a text box from the Controls Toolbox. Set the Linked Cell property to A1. The stuff you type into the text box will appear as you type the characters. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Tanya" wrote in message ... Hi, Is it possible to get one cell to update on the begining of typing in another cell, eg Make the contents of Cell A1 = 1 as soon as the user starts typing into cell A2? If it is what formula would i use? I realise that it is possible to make cell A1 = 1 once you have entered something in A2 and pressed enter or tab, but our users would like the 1 to appear as soon as they have started typing into A2. Hope this makes sense 8-) Thanks in advance Tanya |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update one cell as soon as you start typeing in another
Thanks for getting back to me so quickly 8-) I didn't think it would be
possible but was worth a try. "Earl Kiosterud" wrote: Tanya, In a word, no. You could, however, use a text box from the Controls Toolbox. Set the Linked Cell property to A1. The stuff you type into the text box will appear as you type the characters. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Tanya" wrote in message ... Hi, Is it possible to get one cell to update on the begining of typing in another cell, eg Make the contents of Cell A1 = 1 as soon as the user starts typing into cell A2? If it is what formula would i use? I realise that it is possible to make cell A1 = 1 once you have entered something in A2 and pressed enter or tab, but our users would like the 1 to appear as soon as they have started typing into A2. Hope this makes sense 8-) Thanks in advance Tanya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Typeing zero as first number of a string | Excel Discussion (Misc queries) | |||
Apostrophe at the start of a cell | Excel Discussion (Misc queries) | |||
Inability to start Excel after Refresh update | Excel Discussion (Misc queries) | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
How do you start a new line within a cell? | New Users to Excel |