[Solved] How to put slash in specific cell

mickstereen · Post by **mickstereen** » Sat Oct 31, 2020 6:38 pm

I am looking to put a slash into a specific cell depending upon the content of another cell. Could use some help! I have attached the spreadsheet. I am looking to put a slash in cell p5 conditional upon b5 being "UC".
Thanks,
Mick

Baggins · Post by **Baggins** » Sat Oct 31, 2020 7:28 pm

I'm not sure if I understand your problem but...
Your cell P5 is currently empty (no code), so why don't you just use:
=IF(B5=”UC”;”/”;””)
In cell P5?

Post by **Zizi64** » Sat Oct 31, 2020 8:16 pm

Your sample file contains some MS Excel VBA macro code.

Do you want to put the slash by a macro? What event do you want to assign your macro to?

(You need rewrite your VBA macros based on the API functions and procedures of the AOO/LO.)

mickstereen · Post by **mickstereen** » Sat Oct 31, 2020 8:44 pm

Thanks. That will work!

[Solved] How to put slash in specific cell

[Solved] How to put slash in specific cell

Re: how to put slash in specific cell

Re: how to put slash in specific cell

Re: how to put slash in specific cell