Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
hi
all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
Amod wrote:
hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod Private Sub Worksheet_Change(ByVal Target As Range) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
Private Sub Worksheet_SelectionChange(ByVal Target As
Range) If Target.Address = "$A$1" Then .. .. .. -----Original Message----- hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
hi
Jerry Thanks for reply. I was already using this event procedure. The problem with this is Worksheet_Change will get called when you come out of that particular cell. I want it to get called while I am typing in a cell. regards Amod -----Original Message----- Amod wrote: hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod Private Sub Worksheet_Change(ByVal Target As Range) . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
Hi
Serkan Thanks for reply. As you suggest I have used Worksheet_SelectionChange event procedure, but this procedure gets called when u type in a particular cell suppose A1, then you left that cell and type in other or just traversed through other cells, after that when you again go to A1 cell then this event get fire. so this event is not useful for me. I want an event procedure which get fired while I am typing in the A1 Cell. regards Amod -----Original Message----- Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$A$1" Then .. .. .. -----Original Message----- hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
Misunderstood your question.
I don't know of any method to edit keystrokes within a cell. Amod wrote: hi Jerry Thanks for reply. I was already using this event procedure. The problem with this is Worksheet_Change will get called when you come out of that particular cell. I want it to get called while I am typing in a cell. regards Amod -----Original Message----- Amod wrote: hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod Private Sub Worksheet_Change(ByVal Target As Range) . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
one problem in excel
For all practical purposes, macros don't run when you are in edit mode -
which is what you describe. -- Regards, Tom Ogilvy "Amod" wrote in message ... hi Jerry Thanks for reply. I was already using this event procedure. The problem with this is Worksheet_Change will get called when you come out of that particular cell. I want it to get called while I am typing in a cell. regards Amod -----Original Message----- Amod wrote: hi all As you all know there is an onchange event to a text box in VB. I want same functionality for excel worksheet cell or range. If you have any idea please let me know. thanks in advance. regards amod Private Sub Worksheet_Change(ByVal Target As Range) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |