Enter data in a cell, then Macros greyed out

[UHsoccer]

I enter data in a cell, then select Tools / Macro the Macros selection is under-lighted (not active)

When I click in a different cell, then click on the cell in which I entered the data, the Macros is selectable.

The macros needs to read not only WHICH cell is selected but also what is in the cell. As is, I have to "teach" the user to enter the data, click elsewhere, then click the previous cell again, befoe the Macro is available. There has to be a solution for this.

Hope that makes sense.

 

[anis]

why do u want ur macro to read the data? is there any further data processing involved? y dont u used a variable to store the value of the selected range?

Dim strVal As String

strVal = Selection.Value

that's if i understood ur situation correctly :wink:

regards,

 

[erik.van.geit]

Hello, UHsoccer,

While editing a cell it's impossible to start macros.
It's normal that this option is not available.
How could you run a macro if the result of a cell is still incertain (being edited) ?

kind regards,
Erik

 

[UHsoccer]

My macro needs to know the ONE cell in which I entered a value (it uses that for subsequent processing)

I was hoping that by selecting the macro (which is added to the menu list at the top) it would imply that I was finished entering data.

But I gues not

 

[erik.van.geit]

perhaps you can use something like this
put it in the worksheetmodule

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "you just changed cell " & Target.Address & " to " & Target.Value, 64, "cell info"
End Sub

kind regards,
Erik