userform1

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...

This code displays data in Userform1 on the active sheet(in the background [showmodal = false] Private Sub UserForm_Initialize() currentrow = 2 'currentrow is a global variable of type Long lastrow = Sheets("REGISTER").Range("A" & Rows.count).End(xlUp).Row TextBox1 = Cells(currentrow, 1)...

Hello, I am really new with programming and this is my first job with VBA, I hope somebody can help me, because I cannot find solution for some days.. :/ In my excel are more sheets and each has 1 table objects - after opening the workbook, the macro set of its visible to false and show...

I'm opening my UserForm1 by selecting a specific cell (any cell within a range of A2:A100). I say "specific cell" because UserForm1 is pulling info back into my TextBox1 and TextBox2. However, if any cell within my range of A2:A100 is empty, I want UserForm1 to open with a grey instruction text...

if user click on command button,user form will pop up I have made a Userform1,i have added label to it I want to find user windows name on label1 Can i get macro for it?

Hi, I have a user form (Userform1) that adds a row into a table, one of the options on Userform1 displays a new user form (Userform2) allowing the user to key in some dates. Now obviously, the dates that have just been keyed in cannot be transferred to the 'new row' in the table because...

Hi, HOw can I make userform1. textbox1 & textbox2 to accept only time format in hh:mm then I want textbox3.value = textbox2.value -textbox1.value in time format. keeps getting error Private Sub TextBox3_Enter() TextBox3.Value = TextBox2.Value - TextBox1.Value End sub Thanks Pedie;)

I just dont know where to start i have the userform that has a calender that is linked to cell A1 then i select the date from uderform it changes the date on cell A1. What I am trying to achieve is that from main data range A1:D205 i have list of meetings scheduled.... when i select the date i...

Hi, I am struggling with a combobox on a userform. I need 2 cascading comboboxes and a textbox. Obviously the data in combobox 2 is dependent upon the choice made in combobox 1. Then the user can type anything in the textbox. But, depending on the choice made in combobox2 - the text/value in...

I hope I can explain the problem well enough that someone can help because I cannot forward the file that is causing the error -- it's nearly 25MB. There's quite an extensive relational database involving several sheets and a VBA userform interface and code. All has been running well for the...