I have an imput box in cell F5. The only things that can be imputte
inside that cell is a dollar amount.

I want a macro to run only after someone has entered a number in tha
cell and right after he/she imputs the amount and presses Enter.

Can this be done in this manner or will I still need to place a butto
next to the cell to click once an amount has been imputted?

Thanks, I appreciate the help

--
Message posted from http://www.ExcelForum.com

even better. It can be automatic
right click sheet tabview codecopy/paste this. Change cell to suit. Use A
instead of a.

Private Sub Worksheet_Change(ByVal Target As Range)
if target.address="$A$1" then call mymacro
End Sub


--
Don Guillett
SalesAid Software

"grin2000 " wrote in message
...
I have an imput box in cell F5. The only things that can be imputted
inside that cell is a dollar amount.

I want a macro to run only after someone has entered a number in that
cell and right after he/she imputs the amount and presses Enter.

Can this be done in this manner or will I still need to place a button
next to the cell to click once an amount has been imputted?

Thanks, I appreciate the help.


---
Message posted from http://www.ExcelForum.com/

I tried it and it gives my

"Compile error:
Sub or Function not defined"

the cell is f73 that I want to run so I put $F$73 but it gives me thi
erro

--
Message posted from http://www.ExcelForum.com

do you have a macro named mymacro?

--
Regards,
Tom Ogilvy

"grin2000 " wrote in message
...
I tried it and it gives my

"Compile error:
Sub or Function not defined"

the cell is f73 that I want to run so I put $F$73 but it gives me this
error


---
Message posted from http://www.ExcelForum.com/

no it's called Test and I did change it to that but it still gives m
that erro

--
Message posted from http://www.ExcelForum.com

Grin,

what you probably did is copy the exact code Don gave you. When cel
F73 changes it calls the Sub "mymacro", which Don put in the code as a
example of a Sub to run if the cell has changed.

I don't know what you want to happen when the cell changes, but you ca
approach it in two ways. The first is to put the code right in th
Worksheet_Change event. The second is to call another Sub when the cel
changes:

FIRST:

Code
-------------------

Private Sub Worksheet_Change(ByVal Target As Range)

If target.address="$F$73" then
'Write whatever code is needed, for example:
MsgBox ("Cell F73 has changed to value: " & Target.Value)
end if

End Sub

-------------------

SECOND:

Code
-------------------

Private Sub Worksheet_Change(ByVal Target As Range)

if target.address="$F$73" then
call GrinsMacro(Target)
end if

End Sub


Sub GrinsMacro(Target As Range)

'Write whatever code is needed, for example:
MsgBox ("Cell F73 has changed to value: " & Target.Value)

End Sub

-------------------


Good luck

--
Message posted from http://www.ExcelForum.com

This goes into the code module for the sheet (right click tab & Vie
Cose).

'-------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$F$5" Then
MsgBox ("Put code here.")
End If
End Sub
'-----------------------------------------------------

--
Message posted from http://www.ExcelForum.com

"grin2000 " skrev i melding
...
no it's called Test and I did change it to that but it still gives me
that error

Test should be in the same module or in a standard module. If it's in
another sheet module then it must be addressed like this:

Call Sheet2.Test

HTH. Best wishes Harald

Great tip!
I don't understand what you mean by "Use A instead of a."
-----Original Message-----
even better. It can be automatic
right click sheet tabview codecopy/paste this. Change
cell to suit. Use A
instead of a.

Private Sub Worksheet_Change(ByVal Target As Range)
if target.address="$A$1" then call mymacro
End Sub


--
Don Guillett
SalesAid Software

"grin2000 "
wrote in message
...
I have an imput box in cell F5. The only things that
can be imputted
inside that cell is a dollar amount.

I want a macro to run only after someone has entered a
number in that
cell and right after he/she imputs the amount and
presses Enter.

Can this be done in this manner or will I still need to
place a button
next to the cell to click once an amount has been
imputted?

Thanks, I appreciate the help.


---
Message posted from http://www.ExcelForum.com/



.

I meant do not use lower case. Use UPPER case. And, don't forget the " "

--
Don Guillett
SalesAid Software

"jeffP" wrote in message
...
Great tip!
I don't understand what you mean by "Use A instead of a."
-----Original Message-----
even better. It can be automatic
right click sheet tabview codecopy/paste this. Change
cell to suit. Use A
instead of a.

Private Sub Worksheet_Change(ByVal Target As Range)
if target.address="$A$1" then call mymacro
End Sub


--
Don Guillett
SalesAid Software

"grin2000 "
wrote in message
...
I have an imput box in cell F5. The only things that
can be imputted
inside that cell is a dollar amount.

I want a macro to run only after someone has entered a
number in that
cell and right after he/she imputs the amount and
presses Enter.

Can this be done in this manner or will I still need to
place a button
next to the cell to click once an amount has been
imputted?

Thanks, I appreciate the help.


---
Message posted from http://www.ExcelForum.com/



.

thanks Binzelli!
It works great

--
Message posted from http://www.ExcelForum.com