textbox2.value

Hi all, I have a userform with some textboxs that are linked to some cells in a sheet of Excel. Here is the code of the userform Private Sub UserForm_Initialize() TextBox1.Value = "" TextBox2.Value = "" TextBox3.Value = "" TextBox4.Value = "" end sub And here is the code of the command...

Hi, I had this in use the other day, TextBox2.Value = Format(CDbl(Date), "dd/mm/yyyy") I was told that the CDbI was not needed so i put this in use. TextBox2.Value = Format(Date, "dd/mm/yyyy") Looking through some of my code i see this pop up in a few places so the thing is do i need to change...

my userform contain 2 textbBox TextBox1.value = start date TextBox2.value = end date e.g TextBox1.value = 14/8/85 TextBox2.value = 28/10/91 in sheet1 from range "A1" to show start date year to end date year by vba and using for loop.in above example show result as below 1985 1986 1987 1988...

Hi, I am trying to create a userform that looks up an address on Google Maps, or directions between two addresses. I got the above error message when creating this code below: Private Sub CommandButton1_Click() Dim r As Integer, r2 As Integer, URL As String Application.ScreenUpdating = False...