userform2

I have a combobox1 in UF1 that is coded as... sub combobox1_change() userform2.show end sub Once userform2 shows up, I need another combobox to select something. Code I have... Sub combobox1() Me.combobox1.List = Worksheets("Drop Down Data").Range("d3:d51").Value end sub Once...

Hi I have 2 forms. UserForm1 and UserForm2. Do I need to say UserForm2.Label1.Caption or just Label1.Caption I did "Label1.Caption" and everything work fine, it is not effecting the UserForm1 The code below is for UserForm2 Private Sub myadd_Click() UserForm2.Label1.Caption =...

Hello I've button which loads Userform2. In Second command button i want to know whether userform2 is loaded in Gen Module Public usrForm As Object Function IsUserFormLoaded(ByVal usfrName As String) As Boolean IsUserFormLoaded = False For Each usrForm In VBA.UserForms If...

I have never used "Target" before. I have a list of name (a18:a150) and want to click on one and have the name inserted into textBox1 in userForm2. I can get the range set correctly and "userform2.show" brings up userform2 (which has my textbox1). I cannot figure out how to get the name from...

I have userform1 to search for a value in a list. If userform1 doesn't find amatch it calls userform2 to ask the user what they would like to do, Add, SearchAgain or Cancel. If the user selects "Add" (or CommandButton1) onuserform2, then the tab changes and the search value that was obtained...

Im trying to make a vba program that will open specific userform by clicking specific cells. I have two forms Userform1 and UserForm2 that I want to show on the same Worksheet when a user click specific cell. Example; when Range("A1") is doubleclicked show UserForm1, when Range("A5") is...

Hi All, In UserForm1 I would like a button leading to Userform2 into a specific Page (of MultiPage1) that is not necessarily the starting page (of Userform2). I tried: Private Sub CommandButton1_Click() Unload Me 'close Userform1 UserForm2.MultiPage1...

Hello, I have two userforms and I have a commandbutton on useform1 that calls for userform2. On userform1 I have a text value in textbox1 that I want to pass on to textbox1 on userform2 when it launches. I thought the code below should be all I need, but when I launch userform 2 the textbox...