Combining two different actions in one event

[KK1234]

Hi,

I have following code for a (Form control button)
When pressed, the sheet selected area is saved in a folder and outlook is opened with this file attached in PDF ready to send.....ACTION-1

Please Login or Register  to view this content.

I have following code which transfers data to specific cells to other sheet when cell F41 is populated. Action--2

Please Login or Register  to view this content.

I want to combine it in one code and allocate it to a form control button, however actions must take place in sequence given above.
I have tried many combinations, but it does not work.

Any help please

[scott.s.fower]

not sure i follow completly, let me see if i have this correct, you want to run action 1, then action 2?

action 2 will not run since there is no code in action 1 that changes the value of $F$41 which is what the target address is.

can you please clarify?

[KK1234]

Yes you are right.

For action 2 What I do is type 'YES' in F41. This triggers transfer data to other sheet.

I want to modify code for Action 2 where 'YES' populated automatically in F41 to trigger action.

So action 1 is OK
Action 2 needs bit modification
Thanks
Regards

[scott.s.fower]

thats easy at the end of action one code

Please Login or Register  to view this content.

you don't need to change action 2 code at all (i think)

[KK1234]

Thanks mate. But can you combine the two codes in to one. I could not do it

[KK1234]

I have combined it and I need help.

Please Login or Register  to view this content.

[scott.s.fower]

not quite, since the action 2 macro is sheet code, it will run automatically when you update cell F41

Please Login or Register  to view this content.

[KK1234]

OK Mate. I will try.
thanks

[KK1234]

Hi Mate,
It worked well.
I was making a mistake and now modified to read as follows

Please Login or Register  to view this content.

Many thanks again
Regards

[scott.s.fower]

nice, yeah, I forgot that it was on a different sheet good catch, cheers!