Re: $$Excel-Macros$$ Userform - Login
Hi Pramod, None are working. On Mon, Nov 3, 2014 at 7:18 AM, Pramod Singh pramod...@gmail.com wrote: User id is 123456 Password may be 321 or 123 or the Try in three password. . Regards Pramod Pramod On 3 Nov 2014 02:02, joseph camill joseph.cam...@gmail.com wrote: Hi, I do not need an add-in, need to work on the file I sent. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. -- PramodSingh -- 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. -- 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
Re: $$Excel-Macros$$ Data Clean
How do you want to do this? I simply highlighted the ū and hit ctrl-c then selected all cells and hit ctrl-h (to find/replace) in the find box, i hit ctrl-v to paste the ū in the replace with box, i inserted u and then hit ReplaceAll. it worked just fine. 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: Deepak Rawat deepakexce...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Monday, November 3, 2014 12:50 AM Subject: $$Excel-Macros$$ Data Clean Hi I need to clean the following mark (don't what to say) at top of the u Aklūj what i Want as Akluj it sa massive data to clean is there any short command in Find n Replace?? Regards, Deepak -- 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. -- 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$$ Userform - Login
Guru Vaibhav Sir, is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. -- PramodSingh -- 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. -- 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
Re: $$Excel-Macros$$ Userform - Login
Hi, Try this UserName password. UserID - 123456 Password - secret Regards Ashish -- 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$$ Userform - Login
Hi All. User id 123456 Password: 321 REgards Pramod On Mon, Nov 3, 2014 at 6:48 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, Try this UserName password. UserID - 123456 Password - secret Regards Ashish -- 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. -- PramodSingh -- 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. Example Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Userform - Login
Hi, I am not sure who this is myxlg...@gmail.com. Please use a different mail to solve your queries, as it may confuse me to look for an appropriate answer and ask question to the experts. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. -- PramodSingh -- 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. -- 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
$$Excel-Macros$$ Four options to every question need to be randomized
In the attached excel file (version 2007), the first sheet is quiz and second sheet is sheet1. It has a question/answer sheet (sheet1) that is designed in such a way that the first letter of the question is prefixed with the answer. For example here is a sample data in the range A1:A20 which is also attached. Answer to first question is b hence the question is prefixed with b. bWho is a cricketer? Tiger Woods Sachin Tendulkar Will Smith Bill Gates aWho is a Golfer Tiger Woods Sachin Tendulkar Will Smith Bill Gates dWho is an Entrepreneur Tiger Woods Sachin Tendulkar Will Smith Bill Gates cWho is an actor Tiger Woods Sachin Tendulkar Will Smith Bill Gates I need to shuffle/jumble the four options for every question (in sheet1) whenever the workbook is opened without changing the logic of prefixing answer to the question's first letter and keeping all other things intact. Please help me how can I achieve this. What kind of code can be written and which section of vba (sheet/module)? Here is an example of question # 1 how it should be after randomization (on file open). cWho is a cricketer? Will Smith Bill Gates Sachin Tendulkar Tiger Woods Here, the options are shuffled/jumbled and also the correct answer is updated in the question (prefixed by 'c' which was earlier 'b'). I was looking at the chip article at http://www.cpearson.com/excel/ShuffleArray.aspx but I am not able to implement this in my question. I also tried finding source on how we can make use of these functions that suits my question to no avail. I am still trying... even if i randomize the four options, how can i get the correct answer sequence (a, b, c, d) to prefix in the question is another tough task. Appreciate some help here. Thank you! -- 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. random.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ My macro won't work in Excel 2013. Please help.
Trying to filter a few numbers from a larger group of numbers in one cell, copy them, then paste them in another cell. Error comes up as Runtime error '1004': Paste special Method of Range class fail. When I go to debug, it shows this: [image: copy to clipboard] Sub Macro1() ' ' Macro1 Macro ' averages ' ' Keyboard Shortcut: Ctrl+m ' Range(F4:F16).Select Selection.ClearContents ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1, Criteria1:=RGB(198, _ 239, 206), Operator:=xlFilterCellColor Range(A8:A239).Select Selection.Copy ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1 Range(F4:F15).Select ActiveSheet.Paste End Sub How can I get my macro to cut and paste what I want without this error? This is exactly how I tried to create my macro: Selected View tab Selected Record Macro tab (use relative references tab not highlighted) Macro name: Macro1 Short cut Key: Ctrl + m Store macro in: this workbook Select f4-f16 right click and select clear contents click on filter tab in column A select filter by color select green select a8-a239 right click and select copy click on filter tab in column A select clear filter from column A select f4-f16 right click and select paste click on stop button to stop recording macro. Then to run macro I: view macros select macro1 click on run Then it executes everything I did in my macro EXCEPT paste at the end. That's when I get the run-time error code '1004' paste special method of worksheet class failed. It seems to me I did everything right but it didn't work. -- 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$$ Backup contact
-- 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$$ Userform - Login
thanks for replying i named this mail id as myxlguru bcoz whatever i posted question in this group i got exact correct answer who send solution to me i called him as guru (master) vaibhav sir, ashish sir, paul sir etc all are masters master thanks On Mon, Nov 3, 2014 at 8:08 PM, joseph camill joseph.cam...@gmail.com wrote: Hi, I am not sure who this is myxlg...@gmail.com. Please use a different mail to solve your queries, as it may confuse me to look for an appropriate answer and ask question to the experts. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. -- PramodSingh -- 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. -- 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
$$Excel-Macros$$ Userform - Login Disable Add-ins
myxlguru, Add new module in this macro with follo. code. Call this macro whenever there is unsuccessful event. Once macro is ready create add-in of macro file install it. So whenever is excel is loaded it will disable addins if unsucessfull login.. code: Sub Disable_Addin() Dim ThisComputerName As String Dim myAddIn As AddIn For Each myAddIn In AddIns If myAddIn.Name = MYADDIN_NAME1.xlam _ Or myAddIn.Name = MYADDIN_NAME2.xlam _ Or myAddIn.Name = MYADDIN_NAME2.xla _ Then myAddIn.Installed = False End If Next End Sub Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Nov 3, 2014 at 6:11 PM, my excel myxlg...@gmail.com wrote: Guru Vaibhav Sir, is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov 2, 2014 at 6:24 PM, joseph camill joseph.cam...@gmail.com wrote: Hi Pramod, Thank you for the file, but I am unable to log-in. Checked the password, in the sheet and used the updated one as well, but I am unable to log-in. On Sun, Nov 2, 2014 at 2:43 PM, Pramod Singh pramod...@gmail.com wrote: Hi Dear, PFA.. Regards Pramod On Sun, Nov 2, 2014 at 4:33 AM, joseph camill joseph.cam...@gmail.com wrote: Hi experts, With the help of various online help have managed to work on few codes in userform. I need two help: 1. Get error when I Update password, please help me rectify 2. Please have a look at the code and try to make it more efficient, in terms of number of lines and also duplication. for log-in you can use id as 123456 and password as secret. -- 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. -- PramodSingh -- 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. -- 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
Re: $$Excel-Macros$$ how to copy a text from a cell into several rows
Hi Vaibhav Bhai, It's perfect. Regards Ashish -- 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$$ how to copy a text from a cell into several rows
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 4, 2014 at 11:56 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's perfect. Regards Ashish -- 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$$ My macro won't work in Excel 2013. Please help.
Hi Use this code: Sub Macro1() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If Range(F4:F16).ClearContents ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1, Criteria1:=RGB(255, _ 0, 0), Operator:=xlFilterCellColor a = Range(A Rows.Count).End(xlUp).Row Set Rng = Range(A2:A a) Rng.Offset(1, 0).Resize(Rng.Rows.Count - 1) _ .SpecialCells(xlCellTypeVisible).Copy _ Destination:=Range(F4) ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1 End Sub Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 4, 2014 at 7:24 AM, Daryl Zer0 sevenhorsesh...@gmail.com wrote: Trying to filter a few numbers from a larger group of numbers in one cell, copy them, then paste them in another cell. Error comes up as Runtime error '1004': Paste special Method of Range class fail. When I go to debug, it shows this: [image: copy to clipboard] Sub Macro1() ' ' Macro1 Macro ' averages ' ' Keyboard Shortcut: Ctrl+m ' Range(F4:F16).Select Selection.ClearContents ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1, Criteria1:=RGB(198, _ 239, 206), Operator:=xlFilterCellColor Range(A8:A239).Select Selection.Copy ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1 Range(F4:F15).Select ActiveSheet.Paste End Sub How can I get my macro to cut and paste what I want without this error? This is exactly how I tried to create my macro: Selected View tab Selected Record Macro tab (use relative references tab not highlighted) Macro name: Macro1 Short cut Key: Ctrl + m Store macro in: this workbook Select f4-f16 right click and select clear contents click on filter tab in column A select filter by color select green select a8-a239 right click and select copy click on filter tab in column A select clear filter from column A select f4-f16 right click and select paste click on stop button to stop recording macro. Then to run macro I: view macros select macro1 click on run Then it executes everything I did in my macro EXCEPT paste at the end. That's when I get the run-time error code '1004' paste special method of worksheet class failed. It seems to me I did everything right but it didn't work. -- 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. -- 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.