Macro to combine and return values

**meleo** · 08-24-2012, 02:05 AM

Hello everyone,

I am very new to this and would like some help with a code.

I have attached the sample workbook, and I am pasting the code I have made so far below.

However, I have no idea of how to code the next part.

Basically I want the macro to return this value in cells E2:E11:
「(value in Data Processing!F2) + "\" + (Value in RC[-1]) + ".jpg"」
But only if the previous cell contains value.

Please give me your advice & solutions!

SAMPLE.xlsx

Code I have:

Please Login or Register  to view this content.

**meleo** · 08-24-2012, 02:38 AM

Maybe I should clarify that when I write "But only if the previous cell contains value"

I mean:

"only if the cell in the same row of the previous column contains a value"

thanks

**olav** · 08-24-2012, 03:51 AM

Hi,

Place this code in the VBA module for the sheet "Result"
The code will trigger whenever you enter anything inside that sheet, but will check to make sure
that it only executes when you do anything inside tha range D2:D11.
If you erase the contents of the cell, then the cell in the E column will also be erased.

Regards
Olav
They don't make bugs like Bunny anymore

Please Login or Register  to view this content.

**Cutter** · 08-24-2012, 10:50 AM

@ meleo and olav

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**meleo** · 08-27-2012, 09:59 PM

Hi Olav,

How do I place the code in the VBA module?
Maybe I am doing it wrong.

I went to the sheet "result", opened Visual Basic then pasted your code in there and saved.
However, nothing happens in the Photo File column when I run my macro.

Many thanks,
Dario