runtime

Hi All, I am wondering if anyone can help me, I am having some issues with one of my macros. I keep getting a Runtime Error '6' when I try and run my macro on a larger set of data - the exact same macro is fine on smaller data and works fine however the workbook I need to run this marco is now...

Hi, I have been trying to create a runtime frame control, which I am having issue to create within another existing frame. When I am adding a frame to the Userform Set cCont = Me.Controls.Add("Forms.frame.1", "NewFrame") its working fine. But the same is not working for the below code Set cCont...

I have written some code to check test the case for cell value > 0.0007 and if it is true to delete that row and the 199 rows below. This works when the cell value is greater than 0.51, however when the cell value is between 0.0007 and 0.5 I get a runtime error. This is my code Sub...

Hi, I need some help here. Previously it was working fine with the exact same code. And lately, it has been showing runtime error 1004 with the highlighted as per below. I have no idea what is wrong when there was no change from the previous. Please help.... Sub SaveInvWithNewName()...

I am trying to set a variable to a querytable as this macro will be run on multiple spreadsheets that are created for each new day. So the macro needs to refer to the activesheets listobject(1). I used the example on the msdn website, but i still get this error. Here is the code, can someone...

Hi, My run time is exceptionally long and I'm not sure why. In fact, the graph doesn't even populate. I just get the not responding screen in excel. How can I make my code more sleek and faster? Private Sub Submit1_Click() If Not IsDate(InitialDate.Value) Then MsgBox "Please enter...

Can anyone help? I'm using the following code to create and populate textboxes on a userform: Dim ct As Integer Dim txtB1 As Control Dim lbl1 As Control Dim r As Integer 'Database Row Dim c As Integer 'Database Column Dim t As Integer 'Top Position on screen Dim l As Integer 'Left Position on...

I have a very basic code to copy "non-blank" data from one sheet and paste to another. The code is not complete yet - I am running in debug mode I get the above error. My code is as below. Sub SampleFind() Dim StrWord As String Dim Quantity As String Dim i As Long Call nrows For j = 2 To 2...

Hi there, New to VBA and the forum. Have a little problem. I have entered some VBA code into my spreadsheet that avoids a CURRENCY PRICE being added to a column if the adjacent column DROPDOWN OPTION does not have a value. It pops up an ERROR MSG and then clears the entered value. Whenever i...

Has anyone ever run into this problem before? I have an extensive .xlsm which uses the simple command line : ThisWorkbook.worksheets(1).listobjects(1).listrows.add And 2 out of 3 times, it will cause a run-time error which will then crash Excel and restart it. The full piece of code is as...

Hi I have a userform that has one combobox at the top created manually. When the userform is opened, the user select an option in the combobox (these options are taken from a range on 1 worksheet). From the selection of the combobox, I use the comboxbox's change event to create and display 5...

I am encountering the following run-time error when lauching the code below from an Active X command button in Excel 2010, launching Word 2010. I have a spreadsheet which has the option to load a word doc which is a helpfile. This code was working fine, but will not now and I can't determine...

I just got a new Excel report from my company. I thought that it was running too slow so I sugegsted that they redo it in Access. The response I got was that the tool is in Access Runtime. This was the first time I encountered this phrase. After Googling for a bit I think I understand that...

I have a userform that asks the following- Equipment Type: [ComboBox] Qty: [TextBox] I have the code that opens the form and all of the initial controls - it is rather long but this is basically what it looks like: Private Sub UserForm_Initialize() With ComboBox_BoilerType...

Hi Folks, This is going to be a lo-o-ng post, so thanks in advance to those who power through it and reply to this thread. I have a mature (been in use for 3 years) spreadsheet that was created w/ Excel 2007 and saved as an *.xls file as most end users still run Excel 2003. This...

Hi, So I have some code and Userform1 tracks the progress of that code. As part of the code it closes the workbook, waits 15 seconds, then re-opens the workbook and finishes the code. I have tried many combinations to try and have a second userform open as part of the code, but I keep getting...

Hi, I am trying to write a routine to be able to place a textbox on a multipager layout that is on a userform during program execution. I am able to place a textbox on the userform but not on the page of a userform. Below is a snippet of code i found on this forum but it only puts the text box...

I'm close to having the macro done. My question is how can I have a macro run on a different sheet than the one I am inputting selections in? Basically I have a first sheet which has checkboxes on it and when I select them the corresponding columns from a data sheet copy and then paste onto a...

I Customized a Toolbar and attached it to a form using the form.toolbar property. I also, defined the first form to load, Now if I open the MDE file using the Access 2003, the toolbar appear when the form is activated. if I open the same MDE file, in the same computer, using RUNTIME 2007, the...

Hi all, Can I artificially create a runtime error 1004 to check how my error handler reacts and what display happens? Can I also designate what type of error is generated, ie: if I want the same macro to produce error 75, etc. Any suggestions on how to achieve this. TIA :rolleyes: