handling

Hey, I would like some help with making this code below work for the 30 checkbox's I have. Is there a way to shorten it down instead of copy and pasting it 30 times? If CheckBox1.Caption = "" Then CheckBox1.Visible = False End If TIA Kyle

I am trying to handle multiple errors and am a bit surprised the following actually works: On Error Goto Errhandler ' Do something Exitpoint: On Error GoTo 0 ' OK this line is not actually needed. Exit Sub ErrHandler: On Error Resume Next 'Do something...

Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and...

I would like to use an error handling statement to define string variable if an error occurs. The error has the potential to occur if the value of RngEnd is near enough to the top of the sheet to return a value that would be outside of the sheet. How can I do this so that the error handling...

=IFERROR(INDEX('Summary (WA1)'!B:B,MATCH(A2,'Summary(WA1)'!A:A,0)),IFERROR(INDEX('Summary (WA2)'!B:B,MATCH(A2,'Summary(WA2)'!A:A,0)),IFERROR(INDEX('Summary (WA3)'!B:B,MATCH(A2,'Summary(WA3)'!A:A,0)),IFERROR(INDEX('Summary (WA4)'!B:B,MATCH(A2,'Summary(WA4)'!A:A,0))&"","")))) Is there ashorter...

In my spreadsheet there is one place that the user can enter a value that can cause an error. I have created an error handling routine that captures the error and clears out the cell the error occurred in. What I need is to make that cell active. Here is the error handling code I have created...

I am looping through a collection and try to trap the error that occurs when the member of the collection does not exist. I can't get my error handling to deal with the situation, it just ignores my direction to go to a line number and crashes. On Error GoTo 32 If Not...

Hey all, I was just looking for some advice/suggestions on handling a VBA-sFTP relationship. Presently I have an upload of a CSV file via sFTP to a third party. The third party response file can take up to 1 hour to be returned. Therefore I was wondering if anyone could suggest any more...

Hello Everyone, I have been banging my head to figure out this task. <tbody> Name Wk 1 AHT Wk 2 AHT Wk 3 AHT Wk 4 AHT Target A 0:19:18 0:17:00 B 0:20:17 0:17:00 C 0:13:38 0:17:00 D 0:15:31 0:17:00 </tbody> I have the AHT for the first week by each of the agent. But the...

Hello, I am using error handling in my macro using On Error GoTo and part of that is Debug.Print Err.Description which gives me the error in the Immediate Window but does not tell me which line the error is on as it would in Debug mode. How can I make it do this? Thanks

I have recently had 3 instances where my error handling is not working the way I had intended. I am not sure whether these instances are related or three different problems. I have used error handling many times before and it has worked the way I intended it, so I am hoping this is not just my...

Hello, Is there a way I can spring a message and exit a routine if Excel receives an out of memory error? I have a routine which does a lot of calculation and importing data via ODBC and on occasion I will get ODBC error System Resources Exceeded- The fix is pretty easy, I just close...