simple macro help. in my macro i have this line :
entry2 = InputBox("What kind of modem is it?")
If entry2 = "" Then entry2=

but i'm stuck on the last part. what i am trying to accomplish here is if
the user leaves the input box blank then entry2 will equal the vaule of the
cell in the row above it in the same column....for example-
user leaves input box blank so in c3 the value will be that of b3

try
selection=selection.offset(-1)

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=525905

if you're doing this just in code you could try

if entry2 = "" then
entry2 = cells(activecell.row -1, activecell.column).value
end if

Hope it helps.

ok i thought this worked, but it is returning values from different areas and
isn't applicable for different entries.