stop in cell
 

I want to force the user to fill cell c3, how can I do it?

stop in cell
 

Hi

Using a worksheet open, or sheet activate, autoexec macro
or some other event, enter the following.

If IsEmpty(Range("c3")) Then
Do
getit = InputBox("what data is going into cell
C3", , "Something")
Loop Until Len(getit) 0

Range("c3").Value = getit
End If

Tony
-----Original Message-----
I want to force the user to fill cell c3, how can I do it?
.