macro help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chip_pyp - 23 Mar 2006 23:49 GMT

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

Reply to this Message

tony h - 24 Mar 2006 00:15 GMT

try
selection=selection.offset(-1)

regards

Signature

tony h

Reply to this Message

chip_pyp - 24 Mar 2006 18:09 GMT

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

Reply to this Message

idyllicabyss@googlemail.com - 24 Mar 2006 00:46 GMT

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.

Reply to this Message