Last seen: Sep 11, 2025
Hi Maggie, See attached. To run the code, click into a cell where the text is that you want to check e.g. A1 then click the blue button 'Color W...
Hi Steve, In lstLookup_DblClick you have this loop cNum = 11 For X = 1 To cNum Me.Controls("Reg" & X).Value = findvalue ...
Hi Helen, You can use Conditional Formatting to do this, please see attached. The first thing to do is change the Timestamps into numbers, they ar...
Hi Steve, What about this? Sub InitSub Me.cboSelect.List = WorksheetFunction.Transpose(Sheet5.Range("AA5:AB5")) With Phonelist1 With...
Congrats.
Hi Helen, No file attached! What version of Excel are you using? regards Phil
Hi Charmi, Welcome to the forum, but please read this I moved your qs to its own thread rather than leave it tagged on to a resolved qs from over...
Hi Steve, What you're trying to do isn't totally clear and without your workbook again I can't see any code or the form. Why not just create a s...
You're welcome.
No worries 🙂
Hi Amel, Please see the attached workbook as a starting point. Once you've calculated your Mean and SD it's straight forward to calculate 3SD, 2SD...
Hi Amel, Try this = IF(N5="Alinity hq I (173)","Amel Al Faris", IF(N5="Alinity hq II (198)","Amel Al Faris", IF(N5="Sysmex 2500","Moneer"))) ...
Hi Damien, When you are attaching files to the forum you are attaching XLSX files which cannot have VBA code in them so each time we have to add th...