terminate

I have a Sub Routine to help users add a new tab to a spreadsheet. It starts by opening a userform where they enter the name of the new tab. The userform then closes and the VBA then searches to see if there is already a tab with that name - if there is the user gets a message to say it already...

Hi, I created a utility for data retrieval/input and it is meant for customer use, therefore I designed it to only show a userform when the workbook is opened, and close the excel application when the userform is terminated. However, this makes it so I now cannot access the Visual Basic editor...

Hi, Is it possible to terminate a pop-up message box, by using something like Ctrl + Break, without clicking on "Yes", "No", "Cancel" etc... buttons ? I have a command button on an userform. When it is clicked, a message box would pop-up. However, pressing Esc / Ctrl + Break seem not working to...

All, I have attached simplified data set. <colgroup><col><col><col><col></colgroup><tbody> Asset Status Priority Timestamp A Terminate 1 13-Oct-18 A New 4 13-Oct-18 B Terminate 1 13-Oct-18 B Change 3 13-Oct-18 C Terminate 1 13-Oct-18 C Change 3 13-Oct-18 </tbody> Is it...

Is it good practice to always follow an on error with a resume? For example, method 1: Sub Start() On Error GoTo Errhandler a = 0 b = 10 / a On Error GoTo 0 ' do something Terminate: On Error GoTo 0 Exit Sub Errhandler: Msgbox "Div by 0" Resume Terminate End Sub...

I have a form that gets data from a class but somehow when the nested sub that reads the data to the form gets terminated premature Private BA As BidApproval Private Sub UserForm_Initialize() Set BA = New BidApproval For Each c In Me.Controls If TypeName(c) = "ComboBox" Then...

Hello, i have following Problem: I wrote a Macro in Word, that opens an Excel file, changes stuff and saves ist again. When it runs a second time i get "method rows of object _global failed" as Error. (It works fine, if i close Word inbetween the runs). I suppose it's because the EXCEL:EXE *32...

Hi, Hi I'm trying to find the VBA code for determine where I terminate my form so when I initiate it again it will be located at the same position. I want to save the position into the value of a cell. I've tried: Private Sub UserForm_Terminate() Range("xPos").Value = Me.Left...

I wanted to integrate a video file (embedded as a Media Player object in a worksheet) together with other graphic results - all displayed in a loop . I have activated the video file using VB command : Worksheet.("Msg1").shapes("object13").OLEFormat.activate It worked fine and the Video was...