unload

Hello all, I am having an issue where this workbook will reopen after closing. I've googled many different solutions, and still can't get it to stop. The idea behind this is that if the workbook is inactive, then a userform will pop up informing them that they have 90 seconds to confirm they...

Hi all, I'm quite new here and new to vba. I have a worksheet that opens a pop up calendar when I click on a certain cell. When I then click on a date on that pop up it puts the date into that particular cell and then the calendar closes. This is all good and working. Is there a way that when...

Hi, I'm trying to make myself a cleaner coder, and hopefully write code that does not slow down every time I run it. Can anyone help me with a list of variable types that need to be set to nothing or unloaded from memory manually at the end of a macro? Thank you, Daniel

Hello all, I was wondering if any one can help with this: Private Sub Userform_Activate() TextBox3.Value = Sheets("Template").Range("AW" & Day(TextBox1.Value) + 7).Value End Sub Private Sub CMDADD_Click() Sheets("Template").Range("AW" & Day(TextBox1.Value) + 7) = TextBox2.Value /...

Any idea why upgrading from Windows 7 pro to Windows 10 would break a passworded textbox? Yes, they checked the caps lock key. Every machine they upgraded now gets "The password was wrong, try again." Yes/No All machines (Win7 and Win10) are using MS Office Professional Plus 2016 32 bit...

Not sure why this gets an error. It seems pretty simple. Error occurs at the ElseIf "Application.GoTo ActiveWorkbook.Sheets("Scores").Cells(3, 1)" line I replaced it with the App GoTo line above and if functions as it should, so its not liking the "Scores" name. Spelling correct, same...

The project has grown and has a few pains still and this is one. Sometimes it will work and sometimes it doesn't and not sure why. The objective is to sort on Col "J " within a range. Seems simple. We never allow more than 50 entries, so I first setup the range @ "A2:A50", but if there were...

I have a following situation. Form1 runs a printing routine after clicking OK. Then Modeless form Form2 shows up with info what is being printed now. I need a cancel button on Modeless form Form2 to stop all remaining tasks and exit. At the moment cancel button in Form2 I have cannot be clicked...

Hello, what is the way to shorten this formula: Private Sub CommandButton1_Click() Dim ws As Worksheet Set ws = Worksheets("Settings") Unload Menu With Menu_Names .TextBox1.Value = ws.Range("V2").Value .TextBox5.Value = ws.Range("V3").Value .TextBox9.Value =...

Greetings, I am using the following code to open a number of userforms simultaneously in a cascade layout. The first code (cleanroom zone) runs perfectly and the userforms layout just as I want them to. But the second one (grayroom zone) doesn't. The userforms do not start up in the same...

If I want a Form to 'remember' some values I can't unload it and then use Property Get? Correct? The right way woudl be to Hide the Form only. Then the Form Variables using Get will work 100%. This is no need to ever unload the Form?

Hi there, I am using Excel 2013 and am getting some strange behaviour when unloading a userform using the "Unload Me" statement. From what I understand the Unload command should remove the instance of the userform from memory. However even after the unload statement has executed, I am still able...

Hi, I am trying to unhide a very hidden worksheet based on a name picked from the drop down list. I am getting a Run-time error 91 Object variable or with block variable not set on the "If ws = Worksheets("Administrator").Range("B9").Value Then" line. Any ideas on how to fix this? Code: Dim...

frm_pdfimp.Show Hello All, I have the above code. Instead of simply hiding it at the end of the program, I want to completely unload it. I tried Unload Me, but it faulted on me. What am I doing wrong? Or, do I have to say the name of the User Form with Unload Me? Thanks

I've created a splash screen that opens when the workbook opens as planned, but does not unload after the required 3 seconds, it just stays open and does not seem to call the Sub that should close it. I'm using the code Application.OnTime Now + TimeValue("00:00:03"), "UnloadSplash" , and...

Hello Everyone, I am trying to create a sub (BOX_TYPE)that opens a userform. Since this is a step in a series of subs, I wanted to add the option of confirming closing the userform in the event of clicking on the close button (top right [X]). I manged it using this code: Private Sub...

Hello everyone! I have a MessageBox in my application that asks whether the user wants to add a new product to the order or not. If I press 'No', it closes. When I press 'Yes', it does what it's supposed to do, lets me add another product, and so on. The problem is that once I press no, the...

Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are the issue. Typically during testing , the userforms are loaded and unloaded a ton of times...

I have a around 10 cFmtCell commandbuttons on a userform. Instead of repeating the following code for 10 times, with varying indices at the end, is there a more convenient way to write the code? Private Sub cFmtCell7_Click() Call FmtCellTxt(cFmtCell7.BackColor, vbWhite) Unload Me End...

I have 2 userforms name "Home" and "Permanent". Home has several command buttons on it and one of them is set to close home and open permanent as follows. Unload Home Permanent.Show The "Permanent" userform has several controls on it that are editable by the user however, I do not want to...