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$$ 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
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$$ Userform - Login
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. Example Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Userform - Login
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 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
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 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
Re: $$Excel-Macros$$ Userform - Login
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 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
Re: $$Excel-Macros$$ Userform - Login
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 VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to
$$Excel-Macros$$ Userform - Login
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. Example Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ UserForm control property reference
Hi! Normally for a UserForm to assign new property to a control a variable is used by me like following sample code: Dim inttxtbxTp As Integer inttxtbxTp = Workbooks(..xlsm).Worksheets().Range(...).Value Me.TextBox1.Top = inttxtbxTp This works fine. However, now I need to pass even the property name by variable Dim strtxtbPpt As String strtxtbPpt = Workbooks(..xlsm).Worksheets().Range(...).Value..which is..Top Me.TextBox1.Properties(strtxtbPpt) = inttxtbxTp This code does not work. What I need is a correct statement to pass property name by variable. Please help ASAP, regards, Learner -- 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/groups/opt_out.
$$Excel-Macros$$ Userform If-Else Error in German Excel sheet
Hello all, In *German excel worksheet* I created an userform which has following code ''' Private Sub CommandButton1_Click() TextBox6.Value = (TextBox2.Value * TextBox3.Value * TextBox4.Value) / (TextBox5.Value) If TextBox1.Value = TextBox6.Value Then MsgBox Ned = Nrd vbNewLine Erfüllt Else MsgBox Ned Nrd vbNewLine Nicht erfüllt End If End Sub ''' My Problem explained by an example: Initially I enter values for TextBox2.Value , TextBox3.Value , TextBox4.Value and TextBox5.Value The calculated value of TextBox6.Value (Nrd) I get is 150 If I give TextBox1.Value = 10 or 100 then message ''Ned=Nrd Erfüllt'' is seen, which is fine but if TextBox1.Value = 1000 still it shows same message instead of ''Ned Nrd Nicht erfüllt''. What could be the reason for it? If anyone could help , I would be grateful. Thanks. -- 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/groups/opt_out.
Re: $$Excel-Macros$$ Userform Filter
try using the vlookup function or DLOOKUP function on the form. On Sat, Mar 3, 2012 at 11:15 AM, Deba Ranjan drdeva...@gmail.com wrote: * * *Regards* *Deba Ranjan P** * *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]*** ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ * * * * -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Thu, Mar 1, 2012 at 5:58 PM Subject: $$Excel-Macros$$ Userform Filter To: NOORAIN ANSARI noorain.ans...@gmail.com, David Grugeon grug...@gmail.com Cc: excel-macros@googlegroups.com Dear Sir, Please help me in creating user for filter. i mean :- for eg. 1. customer name:- Ranjan lawran 2. Mobile:- 6587459874 3. state:- delhi. Above data is just an example, in user form, when i click ranjan Lawran, his particular number *6587459874* as well as his state should come. can u please do for me that in urgent basis. PLease. *Regards* *Deba Ranjan P** * *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]*** ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ * * * * -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.gif
$$Excel-Macros$$ userform need to search display the value in respective text box
Dear Specialist, Attached the excel file for your reference. with useform. I want to search via roll on codes (length of roll on codes are fix with 8 digest), If I put 4 digest in text box of roll on codes and hit the search button after this other text box suppose to be populate where the value matched with text box value. Even need to view previous and next value matched by hitting previous button and next button For example :- I enter roll on codes in text box i.e. 123456 and hit the search button then it need to show first code in text box of roll on code which is 12345678, then name Rabbit, Duty in 10% units Y If hit the next button then it need to show next match value, and if hit the next button the need to show next matched value, and if hit the previous button then need to show previous match value. Roll On Code Name duty in %Unit's 12345679 Hourse 2% N 12345610 Lion 0% N 12345611 Tiger 0% N 12345678 Rabbit 10% Y Please help thanks in advance. Attached the excel file for your reference. -- Thanks Regards, Prajakt Pande +971551388482 ** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ROLL ON CODES.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ userform
No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Goodmorning all, Is it possible to make an Excel Userform as an executable file ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ userform
You can try visual studio , by excel its not possible On 19/09/2011, Sam Mathai Chacko samde...@gmail.com wrote: No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Goodmorning all, Is it possible to make an Excel Userform as an executable file ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from my mobile device Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ userform
thank you for responce On Mon, Sep 19, 2011 at 7:45 PM, rajan verma rajanverma1...@gmail.comwrote: You can try visual studio , by excel its not possible On 19/09/2011, Sam Mathai Chacko samde...@gmail.com wrote: No On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Goodmorning all, Is it possible to make an Excel Userform as an executable file ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from my mobile device Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ userform is not opening
Hi Friends, Need another help. I am trying to upload a userform using combobox but it is not working. Sample sheet is attached. Regards Santosh santoshkumar.subu...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Combobox.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ UserForm Programming
Dear All I am designing a user form but new to this, so i need help on prgramming. The logic i am mentioning here as under: Threre are 2 comboBoxes, one calender, and amount file. What i want 1. Which date i would select that should show in Label4 2. First i would select an Type from ComboBox1(cboType) 3. Then there should items should come in second ComboBox(cboItem) 4. Then user will fill the amount and then enter 5. Finally all the data should be entered in the excel sheet as i press Enter For Example I would select in first ComboBox(cboType) Milk then there should come automatically some items like Full Cream Milk, Poly Pack in the in second combobox(cboItem) and finally all the data should be entered in the excel sheet as the user press Enter File is attached!! Regards, Deepak Rawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Expense Entry Workbook.xlsm Description: Binary data
$$Excel-Macros$$ UserForm Programming
Dear All I am designing a user form but new to this, so i need help on prgramming. The logic i am mentioning here as under: Threre are 2 comboBoxes, one calender, and amount file. What i want 1. Which date i would select that should show in Label4 2. First i would select an Type from ComboBox1(cboType) 3. Then there should items should come in second ComboBox(cboItem) 4. Then user will fill the amount and then enter 5. Finally all the data should be entered in the excel sheet as i press Enter For Example I would select in first ComboBox(cboType) Milk then there should come automatically some items like Full Cream Milk, Poly Pack in the in second combobox(cboItem) and finally all the data should be entered in the excel sheet as the user press Enter File is attached!! Regards, Deepak Rawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Expense Entry Workbook.xlsm Description: Binary data
$$Excel-Macros$$ userform, shape and ....ontime ....
hello to all ! I'm trying to make a shape in an userform, and, to make longuer longuer this shape like a progress bar for a time duration. for exemple, my duration is 45 minutes. the max shape longuest side represent 45 minutes. Every 1 minute i want to increment this shape inside my userform. Can someone give me some examples or tutorials covering my problem ? thanks from France (and my horrible english) José -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ UserForm
I would appreciate some help/guidance for doing the following. I would like to create a userform, ( which is triggered by an action taken in a cell on another sheet called test1 in the workbook), with five variables each with it’s own checkbox; the checkbox information will be a 1 or 0 and will be placed / saved / copied into separate columns “M through Q” , with the new data being added to row below each time the userform is triggered the information is placed on a different sheet test2 cloumns “M through Q”in the same workbook. I would like the userform to have an OK button on it so once the user is finished choosing variable 1 thru 5 or all five,and licks on the OK button the userform will close. In addition to capturing the userform information information I would like to then copy three other cells on the same row in sheet test1 to be copied to the same row and dedicated columns in sheet test2, that we are placing the userform information. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Userform locks Excel
I have an Excel workbook w/ a VBA menu to pops up a userform to write values back to a worksheet in the workbook. Sometimes, the userform locks Excel and it has to be abended. I suspect its due to users have other workbooks open and copying and pasting between them. Can I specify a specific instance in the VBA code for the userform? Is the userform independent of the workbook and could write back to whatever instance is active? Can I specify a window handle? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ userform with animation
SOMEBODY COULD HELP ME THANKS El 2 de junio de 2010 22:15, Víctor González vmgon...@gmail.com escribió: hello friends need to do a userform with an animation I searched the Internet but I did not understand the solution works if anyone can give me an idea or help with an element that would be ideal. thanks from Chile -- Ing. Víctor González Erices -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ing. Víctor González Erices -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ userform with animation
hello friends need to do a userform with an animation I searched the Internet but I did not understand the solution works if anyone can give me an idea or help with an element that would be ideal. thanks from Chile -- Ing. Víctor González Erices -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Userform - user prompted for path of image which will be displayed in the workbook along with the other data.
or user prompted for whatever gets the job done...I am just assuming that would be the way to get it done. I have created my first userform to input data into my worksheet. I have 8 fields which populate my worksheet. On my userform I have an 'Add Data' button which works like a charm via a tutorial from contextures.com On each row on my worksheet I would like there to be a product image in the last field. The images are stored in various folders on our network drive. How do I add an input field on my userform that will allow the user to point to an image file and in essence be my 9th field on my worksheet? I have tried creating a button using the getopenfilename along with other commands for this button but nothing I have tried comes close to achieving my goal. I am not sure of what the code should be for that command button anyway...guess that's a big part of my problem here. Maybe I shouldn't be using a command button...maybe this cannot be achieved with a userform? Can anyone explain to me how I can accomplish this. So, my goal is for the user to select a photo as one of the fields that will populate my spreadsheet. Also, if this can be achieved can I set an image size for this item. Needs to be a little bigger than a thumbnail. I have spent hours looking for the answer to this question. I hope someone has mercy on me. ALSO how do I have the rows to a predetermined width and height? I see how I can set this one by one, but I want the excel spreadsheet to already have the proper cell sizing before any data is entered. The sizing is going to revolve around this image that I am trying to get in there. ellie --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ USERFORM LINKED VIA HTML HYPERLINK
I have a userform which is hyperlinked in word then saved as HTML when I open the form all is ok but upon exit i get this error from command button using application.close savechanges = false excel missing file:res://\\ieframe.dll/ErrorPageTemplate.CSS or if i use close button it trys todownload the form ? in temp Any ideas woul be greatly appreciated --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Userform for 10 secs
Hi, I have created Userform which will open when the excel sheet opens, but how to keep it only for 10 secs. After 10 seconds it should close automatically. Any macro code for that?? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ UserForm objects/controls collections?
Hi Dear all, I have this puzzle for a long time. I often program UserForm and always format controls like this : .TextBox1.Height = 18 .TextBox1.Width = 100 .TextBox2.Height = 18 .TextBox2.Width = 100 .TextBox3.Height = 18 .TextBox3.Width = 100 .TextBox4.Height = 18 .TextBox4.Width = 100 .TextBox5.Height = 18 .TextBox5.Width = 100 I am thinking is there a collection like TextBoxes ,then you can refer to each textbox as TextBox(i) then just do loop like this: For Each tb in TextBoxes tb.height=18 tb.width=100 next tb Any ideas or any other way around that? Vincent --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---