Hi Good day!
I created two Command Buttons both are in one Sheet.
The first button copy and pastes a range of cells in one row.
Then, I created another button that creates an information and paste it in one of the cells that is being copied by the first button.
I am thinking about a possiblity that if in case I forgot to click the second button the information that will be copied by the first button will be incomplete.
May I kindly ask your recommendations if possible to trigger the 2nd command button when I click on the 1st command button?
I am new to VBA, I know there is a shorter way on this... Hehe... I'm just trying to explore the possibilities because it's fun.
I'm hoping I was able to clearly state my request.
Thanks!
I created two Command Buttons both are in one Sheet.
The first button copy and pastes a range of cells in one row.
Then, I created another button that creates an information and paste it in one of the cells that is being copied by the first button.
I am thinking about a possiblity that if in case I forgot to click the second button the information that will be copied by the first button will be incomplete.
May I kindly ask your recommendations if possible to trigger the 2nd command button when I click on the 1st command button?
I am new to VBA, I know there is a shorter way on this... Hehe... I'm just trying to explore the possibilities because it's fun.
I'm hoping I was able to clearly state my request.
Thanks!