Why not just use an Inputbox?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John.Greenan" wrote in message
...
Hi,

The best way to do this is to use the Worksheet_Change event and then to
check to see if the cell you are interested in is contained in the
"Target"
range.


Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Have a go with that and see if you can get it to work - if not post
another
question and I'll help out.

Cheers,


--
www.alignment-systems.com


"Devin Linnington" wrote:

Hi, what I'm trying to do is have a macro run when you start excel
(figured
out how to do this already) that waits for the user to enter a number
into a
paticular cell in excel, then calls a function. I had an idea on how to
make
it 'wait' for the value to not be null, but I fear that it won't be very
efficient as it is continuously looping until the value changes (see
code
below). I have searched around and found this article, but it doesn't
really
explain how you do it without the toolbar:
http://support.microsoft.com/kb/q131847/
What I would really like is a procedure that 'polls' that cell
every-so-often to see if it has changed, or does the code below every 1
second or so instead of as fast as it can possibly go (I don't think
that
would be too efficient).

Private Sub test()
Dim chkA
chkA = Worksheets("Visc Table").Range("b26").Value
Do While chkA = "" 'do the below while chkA is null
chkA = Worksheets("Visc Table").Range("b26").Value
Loop
Call KODEA(chkA)
End Sub

This would work, but I'm thinking there is a better way to do it than
this.
Thanks ahead of time for all the help.

- Devin L.