Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
Hi,
How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
Sub AAAtest()
Cells(1, 1).Select SendKeys "{F2}" End Sub -- Regards, Tom Ogilvy Michael Gree wrote in message ... Hi, How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
Tom,
Many thanks for that - it worked. However I'm concerned that SendKeys only works on the Active window. Do you know a way to ensure the key strokes go to the correct window ? Regards Michael -----Original Message----- Sub AAAtest() Cells(1, 1).Select SendKeys "{F2}" End Sub -- Regards, Tom Ogilvy Michael Gree wrote in message ... Hi, How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
You can only edit in the active window, so that shouldn't be an issue.
I am not sure why you want to do this, but if you want to change the value in a cell, you certainly don't need to put excel into edit mode (where code doesn't run anyway). -- Regards, Tom Ogilvy Michael Green wrote in message ... Tom, Many thanks for that - it worked. However I'm concerned that SendKeys only works on the Active window. Do you know a way to ensure the key strokes go to the correct window ? Regards Michael -----Original Message----- Sub AAAtest() Cells(1, 1).Select SendKeys "{F2}" End Sub -- Regards, Tom Ogilvy Michael Gree wrote in message ... Hi, How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
Tom,
Thanks for that. The reason I want the cell open for editing is as a nicety for the user. Before this last line of code there is code to insert a new row, specially format it with validation etc. I then position the active cell so the user can start entering data. Regards Michael Green -----Original Message----- You can only edit in the active window, so that shouldn't be an issue. I am not sure why you want to do this, but if you want to change the value in a cell, you certainly don't need to put excel into edit mode (where code doesn't run anyway). -- Regards, Tom Ogilvy Michael Green wrote in message ... Tom, Many thanks for that - it worked. However I'm concerned that SendKeys only works on the Active window. Do you know a way to ensure the key strokes go to the correct window ? Regards Michael -----Original Message----- Sub AAAtest() Cells(1, 1).Select SendKeys "{F2}" End Sub -- Regards, Tom Ogilvy Michael Gree wrote in message ... Hi, How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to open an Excel cell for Edit
Michael,
Getting back to what Tom said..why would you want to do this? As long as you're in VBA, create a UserForm and let the user enter data into a textbox. You can validate the data in the textbox a lot easier than in a cell and when (via coding) you're certain it's correct, write it to the cell in whatever format you want. John "Michael Green" wrote in message ... Tom, Thanks for that. The reason I want the cell open for editing is as a nicety for the user. Before this last line of code there is code to insert a new row, specially format it with validation etc. I then position the active cell so the user can start entering data. Regards Michael Green -----Original Message----- You can only edit in the active window, so that shouldn't be an issue. I am not sure why you want to do this, but if you want to change the value in a cell, you certainly don't need to put excel into edit mode (where code doesn't run anyway). -- Regards, Tom Ogilvy Michael Green wrote in message ... Tom, Many thanks for that - it worked. However I'm concerned that SendKeys only works on the Active window. Do you know a way to ensure the key strokes go to the correct window ? Regards Michael -----Original Message----- Sub AAAtest() Cells(1, 1).Select SendKeys "{F2}" End Sub -- Regards, Tom Ogilvy Michael Gree wrote in message ... Hi, How do I open a cell for edit from code ie as if the user had pressed F2... Regards Michael Green . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If i open a 2003 excel document in excel 2007 can i edit it ? | Excel Discussion (Misc queries) | |||
Can I open, edit and save an Excel file online? | Excel Discussion (Misc queries) | |||
Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) | |||
Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming | |||
Programmatically open / edit vba-editor | Excel Programming |