userform vba

Hello, I have a userform that I am trying to insert the small calendar into. I believe the proper control name is Microsoft Outlook Date Control. When I select this in Additional Control it then appears in the toolbox. Good. However when I then click it and try to place on the userform in get...

Hello, First time poster and Self taught VBA Novice here in need of some assistance. I'm running into trouble getting my Userform to chnage the backcolor of controls based on dropdown selection and then select focus and open the dropdown menu of the next combobox. I shouldn't say it doesn't...

Hello there, I need multiple users in various Fantasy groups to populate a worksheet for me. I don't want the exercise to be cumbersome, hence a Userform. I need to achieve the following: User Selects their group (sample options below): Fantasy Group 123 Fantasy Group 1234 Fantasy Group 12345...

Hi All, I am getting "Unable to VLookup property of the Worksheets Function Class" Erro for the below code. Kindly assist I am using this code in a userform Private Sub ListBox1_Click() Dim l As Integer Dim f As Integer EST.TextBox6 = EST.ListBox1 l = Len(EST.TextBox6) f =...

Hi I'm trying to achieve the above on a user form with the below code and keep getting a key type error! can any one please help!?! Sub remove_key_click() Dim kName As String kName = cbo_KN.Value If Worksheets("Keys").Range("KeyName").Value = kName Then ans = MsgBox("Delete "...

Hello All, I recently found this code, which is to say the least, awesome! Sub GoogleStaticStreetView(oShape As Shape, _ sAddress As String, _ lHeading As Long, _ Optional lHeight As Long = 512, _...