Thread: macro help!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chip_pyp chip_pyp is offline
external usenet poster
 
Posts: 5
Default macro help!

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