0
I need a help with VBA.
My question is this::
I need cell "B" and "C" to receive a specific value when I type a value into cell "A":
For example: When I type the value "1" in cell "A", cell "B" should receive 'MOTO' and cell "C" should receive 'CAR'
When I type the value "2" in cell "A", Cell "B" should receive 'HOME' and Cell "C" should receive 'APARTMENT'
When I type the value "3" in cell "A", Cell "B" should receive 'DOG' and Cell "C" should receive 'CAT'
As if the numbers typed in cell "A" were codes that alter the behavior of the following cells!
Edit_1: there will be times when cell B and C will receive different values (from the keyboard) from DOG and CAT, so it needs to be a function or code that behaves like conditional formatting
Thanks in advance!
I don’t know if I understand but maybe the PROCV (or PROCH) function can help you.
– anonimo
In fact, I imagine how to use PROCV or H... the idea is that this information exists only in the formula or in VBA, its functionality is exactly the same as the conditional formatting, only instead of painting the cell or the border, it fills the cell with a predefined text.
– Christian O. Santos