sheetspostage.cells1

Evening, I have a combobox where i would like to show a msgbox when the entries become only 2 left. Please can you advise Private Sub UserForm_Initialize()Dim cl As Range Dim rng As Range Dim lstrw As Long Dim lastrow As Long Dim Lastrowa As Long Dim cntr As Integer...

Hi, I have a worksheet which is sorted from old to new date in column A where A9 is 02/01/2017 & A978 is 07/10/2019 In column B are the customers names. A code collects all the names column B & sorts them into an A-Z order, this takes place in column L I have a userform where a field called...

Hi. On my useform i select a name from a list & then press the transfer button. Now on my worksheet todays date has been entered in the cell which refers to the name i had selected on the userform. Normally the list on the userform has many names so this is a first for me because now there are...

Evening, I have a button which when pressed just opens a userform. I press the button & straight away i see the outer border etc of the userform quite some seconds etc before the button,form color etc etc is even shown. Im not sure what code you need to look at so i have supplied some below if...

Evening, I would like the date to populate TextBox1. I have used 2 different codes as shown here but both show mm/dd/yyyy and not dd/mm/yyyy TextBox1.Value = Date TextBox1.Value = Now TextBox1 = Format(TextBox1.Value, "dd/mm/yyyy") Here is the code in use. Private Sub...