unload userform

Hello, I have a excel workbook that I have created that needs a specific code for userform combobox. The question/ problem, the combobox has a selection which is automatically populated in the initialization. In combobox the selection is: 1. clamp install 2. damaged clamp With that...

A very interesting post a while back from user Herve and replies by Jon Peltier and Richie(UK) talked about initializing a userform from a general module but keeping it hidden so the value could be passed back to the general module...

Greetings everyone... Longtime viewer but 1st time poster. Hopefully this will make sense... I have a userform that tracks who gets a project revision when the person the project belongs to is gone (this part works great). In this userform there is another userform that allows me to alter the...

Hi I have the following code Private Sub CloseBtn_Click() ActiveCell.EntireRow.Font.ColorIndex = 1 Unload UserForm4 MsgBox "closing" End Sub Can someone suggest a reason that it runs twice - I click Close, the form disappears, message box "closing" appears, then the form appears again, click...

Hi. I'm making a project that involves loading and unloading several user forms when I press the okay button. This is the code for the button: Private Sub cmdOkay_Click() Dim mychart As ChartObject Dim counterX As Long Dim k As Long Dim a As Long Dim i As Long Dim flag...

I hope some body can help me with this code I have created a form and want to enter data into the form, the form needs to find the last row on a spreadsheet offset to the next row past data into several differents cells (all on the same row), clear the form ready for the next lot of data...

Hey all, First time posting so apologies if I get anything wrong! I'm doing up a macro for a simple invoicing process and have everything working hunky dory. The process might be a little terrible as I'm not exactly a professional at the coding and this is something I suggested I could do...

Hi I am new to VBA and would like assistance in completing my code below. I am trying to create a spreadsheet on Customers and the first form would allow user too input new customer and I would also like to build from this a form and code to allow user to 'Edit' customer information. Any and all...

Hi all, i have a procedure which unloads a userform. When this userform is loaded, one of the textboxes are setfocused on (textbox1.setfocus). This textbox has validation codes in its BeforeUpdate event. If wrong text is entered, there will be a prompt. In the procedure i have the...