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 |
macro help!
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 |
macro help!
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. |
macro help!
ok i thought this worked, but it is returning values from different areas and
isn't applicable for different entries. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com