lab

Hello, I have 4 different lab tests I run every week for 4 weeks, then it resets. So lab test 1 on week 1, lab test 2 on week 2...then week 5 back to lab test 1. If I know that the week of Jan 7 2019 lab test 3 was run, how do I create a formula that allows me to enter a date and it reports what...

Hello Everyone, I am trying to use Conditional Formatting... Our goal is to have clients with viral load results less than 200, When a client's viral load lab result is greater than 200, there should be an X in front of the lab results (see below) When a client's viral load lab result is...

Can it be done? Let say I create 200 labels on a user form; 100 of which are C1.labelzA and 100 of which are C1.labelzB Private Sub UserForm_Initialize() Dim x As Long Set MEM1 = New Collection For x = 1 To 100 Set LAB = UserForm1.Controls.Add("Forms.Label.1") With...

Is it possible? During control creation, you can assign a class event routing (click, change events.....) to a UserForm control (My method below) Set C1 = New Class1 Set C1.labelz = LAB Is there any possibility for re-assigning a control that has already been...

How do I change this code, so that the macro runs when the workbook opens? Sub InsertMap_Click() 'Updateby Extendoffice 20161116 Dim Pshp As Shape Dim xRg As Range Dim xCol As Long On Error Resume Next Application.ScreenUpdating = False Set Rng = ThisWorkbook.Sheets("Executive...