AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Beep test level 2 excel1/23/2024 ![]() ![]() ![]() Alternatively if it would help I can probably post an anonymised version of the spreadsheet. I have to say that this whole idea is a “would be nice” rather than a “must have” and if it cannot be achieved easily please do not waste any more time on it. I tried replacing my own and VBA with this suggestion, but this was clearly not the way forward as no beeps at all were produced. The new code in post #6 looked good but I was unsure exactly what to do with it or whether it was meant to be accompanied by a formula in column F. ![]() Unfortunately suggestion in post #3 was way above my VBA level and really meant nothing to me. I dragged the =BeepMe (F2<30) down the column, but basically if there is a value anywhere in column F less than 30 a beep accompanies every input in column A. I have tried the VBA and Formula suggested by but I’m afraid this works the same way as my own initial attempt. Thank you very much indeed, and for your prompt responses. ![]()
0 Comments
Read More
Leave a Reply. |