is it possible?

[abrahamperl1987]

hi I have a interesting excel question I've been trying to do it for a while
but I wasn't successful maybe someone here could help me.

when I type 1 in cell A1 I want three things to happen
1. 12072020 should appear in cell A1
2. 122020 should appear in cell B1
3. 01042021 should appear in cell C1
is it possible?
thank you.

 

[Rick Rothstein]

        Target = "12072020"
        Target.Offset(0, 1) = "122020"
        Target.Offset(0, 2) = "01042021"

For those who might be interested, these three red highlighted lines of code from Joe4's code can be replaced by this single line of code...

Target.Resize(, 3) = Array("12072020", "122020", "01042021")

 

[abrahamperl1987]

You are welcome.

If you have any questions about the code, let me know.

OK thanx again