Re: $$Excel-Macros$$ Wosksheet_Change Event Triggering issue
Thanks a lot for your valuable feedback. I was also able to make it work by copy/move sheet but I didn't understand why it couldn't be able to activate same sheet. On Monday, 16 February 2015 18:16:20 UTC+5:30, Paul Schreiner wrote: I'm not sure what caused it. But, I copied your sheets into a new workbook, and it began working. (personally, I prefer the .xlsb format attached) *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Mahesh B mahes...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Monday, February 16, 2015 5:39 AM *Subject:* $$Excel-Macros$$ Wosksheet_Change Event Triggering issue Hello Team, I am new member to this group. PFA excel issue file. The problem in this file is Worksheet_Change event is not getting triggered. I tried for two days with several ways to trigger events but it's not getting. Please let me know how to resolve this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ User name to be picked up in excel
Hi Mr Paul The user name of excel to be come automatically in column L, once column K is entered by the user. I have given few names in column L as an example, which can be removed.. Pl do the needful. Regards Pravin. On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner wrote: Where do the names come from? what does the value in column K have to do with these names? I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique index... *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com javascript: *To:* Excel Macros excel-...@googlegroups.com javascript:; Paul Schreiner - Excel schrein...@att.net javascript:; Vaibhav Joshi (Vabz) - Mumbai Excel v...@vabs.in javascript:; Ms-Exl-Learner - Chennai ms.exl@gmail.com javascript: *Sent:* Wednesday, February 11, 2015 6:24 AM *Subject:* $$Excel-Macros$$ User name to be picked up in excel Hi, The user name to be picked up by formula in the column *L* once the value is entered in column *K* I have entered few names manually. Please help. *Regards, Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ User name to be picked up in excel
check this worksheet event. regards, Mandeep On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote: Hi Mr Paul The user name of excel to be come automatically in column L, once column K is entered by the user. I have given few names in column L as an example, which can be removed.. Pl do the needful. Regards Pravin. On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner wrote: Where do the names come from? what does the value in column K have to do with these names? I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique index... *Paul* - *“Do all the good you can,By all the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Pravin Gunjal isk...@gmail.com *To:* Excel Macros excel-...@googlegroups.com; Paul Schreiner - Excel schrein...@att.net; Vaibhav Joshi (Vabz) - Mumbai Excel v...@vabs.in; Ms-Exl-Learner - Chennai ms.exl@gmail.com *Sent:* Wednesday, February 11, 2015 6:24 AM *Subject:* $$Excel-Macros$$ User name to be picked up in excel Hi, The user name to be picked up by formula in the column *L* once the value is entered in column *K* I have entered few names manually. Please help. *Regards, Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Data Entry (1).xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Re: Wosksheet_Change Event Triggering issue
Hello, Myself is Mahesh, Can some one please check this and let me know since it is an urgent issue. Thank You In Advance. Mahesh Baad On Monday, 16 February 2015 16:09:25 UTC+5:30, Mahesh B wrote: Hello Team, I am new member to this group. PFA excel issue file. The problem in this file is Worksheet_Change event is not getting triggered. I tried for two days with several ways to trigger events but it's not getting. Please let me know how to resolve this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Error at VBA code
Hello Experts, I am going to need help with my code. I have a code that searches for a value in all the worksheets in a destined folder and pastes the entire row in an empty sheet in my current workbook. The problem is that I often get an error type mismatch but not always. I still don't understand when the error occurs there are many occasions that the functions works perfectly! Any help would be much appreciated! Cheers, Christos This is the code Sub SearchForString() Dim myDir As String, fn As String, ws As Worksheet, r As Range Dim a(), n As Long, x As Long, myTask As String, ff As String, temp myDir = C:\test\ If Dir(myDir, 16) = Then MsgBox No such folder path, 64, myDir Exit Sub End If myTask = InputBox(Enter Value or text) If myTask = Then Exit Sub x = Columns.Count fn = Dir(myDir *.xls*) With Application .ScreenUpdating = False .EnableEvents = False End With Do While fn With Workbooks.Open(myDir fn, 0) For Each ws In .Worksheets Set r = ws.Cells.Find(myTask, , , 1) If Not r Is Nothing Then ff = r.Address Do n = n + 1 temp = r.EntireRow.Value ReDim Preserve temp(1 To 1, 1 To x) ReDim Preserve a(1 To n) a(n) = temp Set r = ws.Cells.FindNext(r) Loop While ff r.Address End If Next .Close False End With fn = Dir Loop With ThisWorkbook.Sheets(2).Rows(1) .CurrentRegion.ClearContents If n 0 Then .Resize(n).Value = _ Application.Transpose(Application.Transpose(a)) -- this is where I get the error Else MsgBox Search completed, no values found, , myTask End If End With End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
