Re: $$Excel-Macros$$ for updating the worksheet through the user form
thank you very much bro On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Shankar, PFA, I have just added one more button (Modify) use that before update button. Thanks Regards, Ganesh N On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema shankar.n...@gmail.com wrote: Good morning all, I am attaching an excel workbook which is meant for office file tracking. On the worksheet I placed commandbutton namely Entry Form. Which enables entry of the data into the sheet. Entry fields will be initially filled upto TIMEIN column. From the Timeout, entry of columns will be made at the end of the office hours. Hence, I placed an update command button. I want to update the sl no.1 without disturbing the previous / initial entries. Kindly provide solution. what is this .xlsm. I saved the file in .xls format but its showing as .xlsm. However, its working on my machine. Thank you in advance regards shankar sb -- 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 =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$$ for updating the worksheet through the user form
Dear Ganesh I have tried just now and what I found is, when I enter rest of column fields from the Form Entry and pressing the Modify, a message box asking for the sl no to modify and I have supplied but nothing is happening. Modify means, entered fields should reflect on the worksheet na. Please provide solution. On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Shankar, PFA, I have just added one more button (Modify) use that before update button. Thanks Regards, Ganesh N On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema shankar.n...@gmail.com wrote: Good morning all, I am attaching an excel workbook which is meant for office file tracking. On the worksheet I placed commandbutton namely Entry Form. Which enables entry of the data into the sheet. Entry fields will be initially filled upto TIMEIN column. From the Timeout, entry of columns will be made at the end of the office hours. Hence, I placed an update command button. I want to update the sl no.1 without disturbing the previous / initial entries. Kindly provide solution. what is this .xlsm. I saved the file in .xls format but its showing as .xlsm. However, its working on my machine. Thank you in advance regards shankar sb -- 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 =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$$ for updating the worksheet through the user form
thank you, thank you so much. working fine. On Wed, Sep 24, 2014 at 1:20 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Shankar, The modify will choose the particular row (enter the sn. no) and then wht ever change u want make (e.g out time) and then click the update button. Just try if you have doubt let me know. Regards, Ganesh N On Wed, Sep 24, 2014 at 1:07 PM, Shankar Bheema shankar.n...@gmail.com wrote: Dear Ganesh I have tried just now and what I found is, when I enter rest of column fields from the Form Entry and pressing the Modify, a message box asking for the sl no to modify and I have supplied but nothing is happening. Modify means, entered fields should reflect on the worksheet na. Please provide solution. On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Shankar, PFA, I have just added one more button (Modify) use that before update button. Thanks Regards, Ganesh N On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema shankar.n...@gmail.com wrote: Good morning all, I am attaching an excel workbook which is meant for office file tracking. On the worksheet I placed commandbutton namely Entry Form. Which enables entry of the data into the sheet. Entry fields will be initially filled upto TIMEIN column. From the Timeout, entry of columns will be made at the end of the office hours. Hence, I placed an update command button. I want to update the sl no.1 without disturbing the previous / initial entries. Kindly provide solution. what is this .xlsm. I saved the file in .xls format but its showing as .xlsm. However, its working on my machine. Thank you in advance regards shankar sb -- 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 =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
$$Excel-Macros$$ for updating the worksheet through the user form
Good morning all, I am attaching an excel workbook which is meant for office file tracking. On the worksheet I placed commandbutton namely Entry Form. Which enables entry of the data into the sheet. Entry fields will be initially filled upto TIMEIN column. From the Timeout, entry of columns will be made at the end of the office hours. Hence, I placed an update command button. I want to update the sl no.1 without disturbing the previous / initial entries. Kindly provide solution. what is this .xlsm. I saved the file in .xls format but its showing as .xlsm. However, its working on my machine. Thank you in advance regards shankar sb -- 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. dak track tool.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ doubt in extracting worksheet balances to sheet1 with other sheet names
hai Vaibhavji thank you so much regards shankar sb On Thu, Aug 7, 2014 at 12:03 PM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA Cheers!! On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema shankar.n...@gmail.com wrote: Hai friends I am attaching an Excel workbook for an apartment maintenance. sheet1 i considered as Main page, sheet2, sheet3 will hold individual accounts and their balances when the extract balances button pressed on the sheet1 page, the names of the remaining worksheets should come on the column1 of the sheet1 and the balances of the sheets to the respective column of the sheet1. I am not understanding how to do this. Friends, kindly provide solution. Thanks in advance. regards shankar sb -- 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 =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$$ doubt in extracting worksheet balances to sheet1 with other sheet names
Hai friends I am attaching an Excel workbook for an apartment maintenance. sheet1 i considered as Main page, sheet2, sheet3 will hold individual accounts and their balances when the extract balances button pressed on the sheet1 page, the names of the remaining worksheets should come on the column1 of the sheet1 and the balances of the sheets to the respective column of the sheet1. I am not understanding how to do this. Friends, kindly provide solution. Thanks in advance. regards shankar sb -- 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. flat_DETAILS.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ html to excel sheet
I am attaching the html page and excel workbook. I need help from the members that the data entered into the html page shall be generated the excel sheet after pressing the button on webpage. Kindly guide me in this regard. regards shankar sb -- 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. Token number: Name: Design: Nature of Leave: Select EL Commuted Leave From: TO: Number of Days: Generate Excel Sheet Leave account.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ BANKING APPLICATION
Hai Friends Pleas guide me and refer any site which is having sample EXCEL VBA applications in the retail banking sector. I am very thankful to one and all. regards shankar sb -- 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$$ excel query
Thank you naveen for providing solution Wherein, the difference between dates from 01-01-2014 to 31-01-2014 is 31 days, but with the formula it is showing 30 days just short of 1 day. How can I get the one day added to that column On Tue, Feb 11, 2014 at 6:03 PM, Naveen Kumar M N naveenkumarmn...@gmail.com wrote: Hi can this help u.. chk this by creating hyper link u can navigate the sheets(As shown in attachment-Shankar) go as per the attached(days b/w dates resolved by formating as NUMBER). don't forget to enable the macros. On Tue, Feb 11, 2014 at 2:36 PM, Shankar Bheema shankar.n...@gmail.comwrote: dear all I am attaching the workbook. I tried with the solution provided for getting days between two dates by the respected programmers for my query kept in yesterday. But I am not successful. In the workbook, if a row created with a unique gen no., I need to have a worksheet with that gen no. just like the format of shankar worksheet or rama worksheet. Navigation is also required. If we click on either gen no. or name of the master worksheet, that would take us to that named worksheet. I will be thankful to you. regards shankar sb -- 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. -- Naveen Kumar M N Transport Supervisor +91 80 99808 36003 mailto:naveenkumarmn...@yahoo.com -- 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. -- 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
$$Excel-Macros$$ excel query
Dear all, I attached an excel workbook which contains 3 worksheets. worksheet1 is named as Members worksheet2 is with membername and worksheet 3 is also named after the member how can obtain When the member worksheet is filled the corresponding membernamed worksheet also filled. how to obtain the days between two dates how to navigate to the membernamed worksheet from the member worksheet Please assist me in this regard. I will be thankful for the queries done regards shankar sb -- 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 QUERY.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ maximum worksheets per workbook
Thank you ravinder. On Mon, Jan 20, 2014 at 4:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote: It depends on system memory there is no limit of worksheets *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Monday, January 20, 2014 4:40 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ maximum worksheets per workbook Hai everyone I heard that an excel workbook can manage only 255 worksheets. Is it true. Cant it be increased ? regards shankar sb -- 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. -- 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. -- 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$$ maximum worksheets per workbook
Hai everyone I heard that an excel workbook can manage only 255 worksheets. Is it true. Cant it be increased ? regards shankar sb -- 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$$ date difference problem
thank u deepak its working On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal barnwaldee...@gmail.comwrote: PFA Regards deepak On Fri, Jul 26, 2013 at 11:28 PM, vba v...@vabs.in wrote: PFA Actually years should be 37 not 36!! HTH//Cheers On Fri, Jul 26, 2013 at 10:12 AM, Shankar Bheema shankar.n...@gmail.comwrote: Good morning everyone I am attaching an excel worksheet which contains a userform. There are fields like Date of joining and Date of Retirement. I need the total service rendered by an employee by getting the date difference between these two fields. Whereas all is going well except days difference. For my organisation, we assume each month contains as 30days on average basis. Hence, on this assumption, we are considering each month contains as 30 days. Here comes problem. for an example Date of joining of an employee as: 08-12-2004 Date of Retirement: 30-04-2041 then the difference must be 36 years 04 months 22 days but the application is showing the days only 2. please help me out. -- 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. -- 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. -- 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. -- 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
$$Excel-Macros$$ doubt with regard to change event of the combo
Hai everyone I attached an excel sheet which contains a form. In that I placed three nos. of combo boxes. Each have its values. when I change the gp combo value the remaining two combo values should automatically change. I tried in many ways but failed. please help me out. regards shankar sb -- 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. combo doubt.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ interest calculation
Dear Friends I have doubts in projecting the interest amount on the attached worksheet. Kindly provide solution. I am very thankful to the group. regards shankar sb -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. loan account.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ interest calculation
Dear Friends Yesterday I posted the same file in the group. Today some more fields I had added to the file. Kindly provide solution to the attachment. I am very thankful to the group. regards shankar sb -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. loan account.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ printing an userform in pdf format
thank you santhosh On Thu, Mar 29, 2012 at 12:27 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I am using to take a printout of an userform by using the following code in a command button: me.printform But, is there any option to take a softcopy of an unserform in a .pdf format ? regards shankar sb -- 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
$$Excel-Macros$$ printing an userform in pdf format
Dear experts I am using to take a printout of an userform by using the following code in a command button: me.printform But, is there any option to take a softcopy of an unserform in a .pdf format ? regards shankar sb -- 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
Re: $$Excel-Macros$$ printing doubt
thank you noorain bhai On Wed, Mar 28, 2012 at 11:20 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mothilal, You can use below code to printout all sheets of workbook Sub print_allsheetofworkbook() Dim sh As Worksheet For Each sh In ActiveWorkbook.Sheets sh.PrintOut From:=1, to:=1 Next sh End Sub or Sub print_allsheetofworkbook() Dim i As Integer For i = 1 To Sheets.Count Sheets(i).PrintOut From:=1, to:=1 Next i End Sub Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 28, 2012 at 9:28 AM, jmothilal gjmothi...@gmail.com wrote: Dear Sir, How can i print all sheets ? Thanks with Mothilal.J On Tue, Mar 27, 2012 at 12:54 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Shankar, You can also use.. Sub Print_setup() Application.Dialogs(xlDialogPrint).Show End Sub On Tue, Mar 27, 2012 at 12:23 PM, Shankar Bheema shankar.n...@gmail.com wrote: Dear experts for a command button of an userform for Printing of sheets purpose I am using code as sheets(sheet1).printout whereas, i need to print 3rd page of sheet1 everytime, so what change is required in the above code to get only 3rd page. regards shankar sb -- 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 -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.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
Fwd: $$Excel-Macros$$ Service Count problem
-- Forwarded message -- From: Shankar Bheema shankar.n...@gmail.com Date: Sat, Mar 24, 2012 at 11:00 AM Subject: $$Excel-Macros$$ Service Count problem To: excel-macros@googlegroups.com Dear Experts In the userform of the attached workbook contains Date of Joining text box and Date of Retirement textbox. The difference of both the values should come to 23 yrs 01 mth 29 days but it is showing as 23 yrs 01 mth 01 day In my office procedure resultant date should be given 1 bonus day with this, the result should be 23 yrs 01 mnth 30 days In general, as per my office rules 30 days will be considered as 1 month for calculation of salary Final result should come like 23 yrs 02 mths 00 days Pls rectify the problem. regards shankar sb -- 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 total service problem.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ printing doubt
Dear experts for a command button of an userform for Printing of sheets purpose I am using code as sheets(sheet1).printout whereas, i need to print 3rd page of sheet1 everytime, so what change is required in the above code to get only 3rd page. regards shankar sb -- 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
$$Excel-Macros$$ watermark
Dear experts How to get watermark impression on the userform while taking printout ? regards shankar sb -- 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
$$Excel-Macros$$ APPEAL
Dear Owner of the Community Recently posting query by an attachment was failed due to size of the file. The returned comments by the server is that the blog is not accepting more than .10 mb capacity. Please increase the size to enable posting with an attachment. regards shankar sb -- 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
$$Excel-Macros$$ getting impression on background of a textbox
Dear Experts In the userform of the enclosed excel workbook, there exists two textboxes for date format. Is it possible to get a background impression like DD-MM- in a grayscale for the convenience of the users of the application. That impression would disappear when user types a value for that date. regards shankar sb -- 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 total service problem.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Service Count problem
Dear Experts In the userform of the attached workbook contains Date of Joining text box and Date of Retirement textbox. The difference of both the values should come to 23 yrs 01 mth 29 days but it is showing as 23 yrs 01 mth 01 day In my office procedure resultant date should be given 1 bonus day with this, the result should be 23 yrs 01 mnth 30 days In general, as per my office rules 30 days will be considered as 1 month for calculation of salary Final result should come like 23 yrs 02 mths 00 days Pls rectify the problem. regards shankar sb -- 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 total service problem.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ checkbox query
Good evening Sir, Tons for thanks for solving my query by sparing your valuable time. I tried your code and it is removing the options in the datasheet. Whereas, what I want is, at the opening of the datasheet it should have hidden data options and as per the tick marked checkbox data they have to be unhidden mode. regards shankar On Tue, Mar 20, 2012 at 7:21 PM, Kris krishnak...@gmail.com wrote: Hi Create a commandbutton. And put this code in the userform module. Dim Rng As Range Private Sub CommandButton1_Click() Dim i As Long Application.ScreenUpdating = False Rng.Rows.Hidden = False With Me For i = 0 To .Controls.Count - 1 Debug.Print .Controls(i).Caption If TypeName(.Controls(i)) = CheckBox Then If .Controls(i).Value Then Rng.Find(.Controls(i).Caption).EntireRow.Hidden = True End If End If Next End With Application.ScreenUpdating = True End Sub Private Sub UserForm_Initialize() Set Rng = Intersect(Range(c:c), ActiveSheet.UsedRange) Rng.Rows.Hidden = False End Sub Kris On Tuesday, 20 March 2012 18:02:54 UTC+5:30, NOORAIN ANSARI wrote: Dear Shankar, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Mar 20, 2012 at 11:32 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I have attached an excel file containing data of qualification. On the userform I created check boxes with similar to the datasheet data. I need action like, only the tickmarked check box data only shown on the data sheet all other have to go in hidden mode (even in print also). waiting for your reply. regards shankar sb -- 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
Re: $$Excel-Macros$$ checkbox query
Dear Noorain The query solved by Mr KRIS krishnak...@gmail.com is catering my need. Thank you for your cooperation my dear friend. On Tue, Mar 20, 2012 at 6:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Mar 20, 2012 at 11:32 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I have attached an excel file containing data of qualification. On the userform I created check boxes with similar to the datasheet data. I need action like, only the tickmarked check box data only shown on the data sheet all other have to go in hidden mode (even in print also). waiting for your reply. regards shankar sb -- 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
$$Excel-Macros$$ creating hyperlink on userform
Dear Experts If a pdf file name is placed on a Label form and assume its location is in D:/. How it would be hyperlinked from the USerform. regards shankar sb -- 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
$$Excel-Macros$$ checkbox query
Dear experts I have attached an excel file containing data of qualification. On the userform I created check boxes with similar to the datasheet data. I need action like, only the tickmarked check box data only shown on the data sheet all other have to go in hidden mode (even in print also). waiting for your reply. regards shankar sb -- 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 Qualification.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ connecting to an excel data file without opening the particular excel file
Good morning I want to fetch data from the Student data.xls to student marks.xls without opening the student data.xls file. regards shankar On Wed, Mar 21, 2012 at 12:08 AM, dguillett1 dguille...@gmail.com wrote: From looking at your files it appears that you haven’t given us much info to go on. what data do you want from the data file and where do you want it? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, March 19, 2012 11:51 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ connecting to an excel data file without opening the particular excel file Dear Experts I am attaching two excel files. One is having Student data. I am having an userform in another excel file to prepare student marks information. Can I connect to the similar fields in the student data.xls without opening it from the student marks.xls by clicking UPDATE command button on the userform? waiting for your valuable replies. regards shankar sb -- 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
$$Excel-Macros$$ rounding off problem
Dear Experts The above attached file contains an userform for rounding off of the value if the 3% of the given value comes to more than multiple of 10 except the fraction that value should be rounded off to the nearest multiple of 10 ex. if the value of 3% comes to 660.01 or 660.50 or 660.99 the answer should be 660 only if the value of 3% comes to more than the round figure like 661 then it should be rounded off to 670. pls provide me the solution. regards shankar sb -- 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 test rounding off to nearest 10.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ saving particular worksheets in a fresh workbook
I tried the following code and during execution the following error is coming. run time error 9, Subscript out of range. Pls provide solution. regards shankar sb On Wed, Feb 29, 2012 at 4:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: thank you abhishek On Wed, Feb 29, 2012 at 12:11 PM, Abhishek Jain abhishek@gmail.comwrote: Sheets(Array(Sheet1, Sheet2)).Select Sheets(Array(Sheet1, Sheet2)).Copy ActiveWorkbook.SaveAs Myfile.xls HTH Abhishek On Wed, Feb 29, 2012 at 10:29 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts In my workbook there are several worksheets exists. I wish to save sheet1 and sheet2 worksheets in a fresh workbook. I placed a command button on the worksheet sheet1 and given the following code activesheet.select activesheet.copy sheet2.select sheet2.copy application.dialogs(xldialogsaveas).show but it is throwing an error in saving. pls guide me. regards shankar sb -- 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
$$Excel-Macros$$ saving an excel sheet
is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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
Re: $$Excel-Macros$$ saving an excel sheet
thank you On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: http://www.mrexcel.com/forum/showthread.php?t=354 On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema shankar.n...@gmail.comwrote: is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.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
Re: $$Excel-Macros$$ doubt with setfocus
thank you for solution On Tue, Feb 21, 2012 at 3:24 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear shankar, I tried to solve your problem PFA On Tue, Feb 21, 2012 at 12:47 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I am enclosing the attachment which was solved by NOORAIN. but when I add third textbox to the userform, the code is not working. Please guide me. regards shankar sb -- 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 -- 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 -- 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
$$Excel-Macros$$ doubt with setfocus
Dear Experts I am enclosing the attachment which was solved by NOORAIN. but when I add third textbox to the userform, the code is not working. Please guide me. regards shankar sb -- 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 setfocus problem(Solved).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ problem with setfocus
Thank you Noorain Bhai On Fri, Feb 17, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please try it.. Private Sub TextBox2_Enter() If TextBox1.Text = Then MsgBox Mandatory Field, vbQuestion + vbOKOnly, Alert TextBox1.SetFocus Else TextBox2.SetFocus End If End Sub See attached sheet. On Fri, Feb 17, 2012 at 1:18 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I am attaching an userform with 2 textboxes. While on exit from the first textbox I have given a msgbox alert for not keeping the box empty. But the setfocus event is not working for it. Kindly guide me. regards shankar sb -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.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
$$Excel-Macros$$ problem with setfocus
Dear Experts I am attaching an userform with 2 textboxes. While on exit from the first textbox I have given a msgbox alert for not keeping the box empty. But the setfocus event is not working for it. Kindly guide me. regards shankar sb -- 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 setfocus problem.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ refreshing data of sheet2
thank you so much On Mon, Feb 6, 2012 at 7:04 PM, dguillett1 dguille...@gmail.com wrote: Your macro worked on sheet 1 because you were on sheet 1 and didn’t work on sheet 2 because your with did not have the necessary dots. with sheet2 .do it .do that .do anoither end with Don Guillett SalesAid Software dguille...@gmail.com *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Sunday, February 05, 2012 10:50 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ refreshing data of sheet2 Dear experts. I attached an excel worksheet and want to refresh data of sheet2. Pls specify the code. -- 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
$$Excel-Macros$$ refreshing data of sheet2
Dear experts. I attached an excel worksheet and want to refresh data of sheet2. Pls specify the code. -- 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 refreshing other sheet data.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ datediff doubt
Dear Experts, I placed two userforms for a worksheet. txtavgfrom1 of userform2 should carry the next day of the previous 10 months date of txtdor.text of userform 1 eg. if txtdor.text is 30-04-2041 then txtavgfrom1 of userform2 should carry 01-07-2040. If the dateavgfrom1 of userform2 not starts with the 1st then the days combo should active and produce the difference of days between the dates or else the months combo should active and produce the difference of months. waiting for the solution regards shankar -- 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 calculation of avg emol.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Fwd: single active cell space between words
Dear Sam Please provide solution. -- Forwarded message -- From: Shankar Bheema shankar.n...@gmail.com Date: Tue, Jan 31, 2012 at 12:17 PM Subject: Re: single active cell space between words To: Sam Mathai Chacko samde...@gmail.com Good afternoon Sam, Yes, exactly. regards shankar sb On Mon, Jan 30, 2012 at 11:35 PM, Sam Mathai Chacko samde...@gmail.comwrote: I specifically made that extra effort to cut the name to the next line if the number of characters remaining in the name will not accommodate in the remaining cells. And now you want to have only one cell space? Are you saying it should look like this S U R N I B H E E M A S H A N K A R ?!! Sam Mathai Chacko On Mon, Jan 30, 2012 at 10:17 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I am attaching an userform which contains a worksheet having name data. The example showing one name but the spaces are not identical. So pls I need single active cell space between words. regards shankar sb -- Sam Mathai Chacko -- 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
Re: $$Excel-Macros$$ prefix 0 problem
Thank you asa. On Mon, Jan 30, 2012 at 1:40 PM, Asa Rossoff a...@lovetour.info wrote: Hello Shankar, You can use Format() in VBA. txttotser.Text = Format(txttotyrs.Value, 00) Format(txttotmths.Value, 00) Format(txttotdays.Value, 00) ** ** To use Application.Worksheetfunction.Text, it would go like: txttotser.Text = Application.WorksheetFunction.Text(txttotyrs.Value, 00) Application.WorksheetFunction.Text(txttotmths.Value, 00) Application.WorksheetFunction.Text(txttotdays.Value, 00) ** ** Also your calculator form left the year textbox blank when using the test dates you suggested. There should be a number in that box for the above formula to generate zeroes for the year. If you want to pad a string with zeroes no matter if it's empty, a number, or something else; you could, like this: txttotser.Text = Right(00 txttotyrs.Value, 2) etc. ** ** One more thing - I didn't study how you are calculating your date difference, but VBA has a function called DateDiff for that purpose. Check VBA Help for more info. Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Sunday, January 29, 2012 10:02 PM *To:* excel-macros@googlegroups.com; Sam Mathai Chacko *Subject:* $$Excel-Macros$$ prefix 0 problem ** ** Dear Experts In the above attached file, there exists a worksheet containing total service cell. It takes the value from the userform data and saves on it. when a single digit value comes in years or months or days textbox, it should show prefixing 0. application.worksheetfunction.text(arg1,arg2),interval as string is not working and throwing error. Pls clarify. -- 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
Re: $$Excel-Macros$$ prefix 0 problem
Good afternoon all. Thank you very much Sam and Asa. Actually I am not so sound in code building. I am working in a office and trying to minimise and simplifying my dealing work by automating the data entry. For that I joined for VB 6.0 and built some programs but many were failed. After a long gap, I saw this community in Google and registered and with the help of this community only I built those failed programmes in EXCEL VBA and now I am very comfortable with my work. Thanks one and all. I never forget your valuable help. regards shankar On Tue, Jan 31, 2012 at 1:26 AM, Rajan_Verma rajanverma1...@gmail.comwrote: WorksheetFunction.Text(1,””) = 0001 ** ** ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Jan/Mon/2012 11:32 *To:* excel-macros@googlegroups.com; Sam Mathai Chacko *Subject:* $$Excel-Macros$$ prefix 0 problem ** ** Dear Experts In the above attached file, there exists a worksheet containing total service cell. It takes the value from the userform data and saves on it. when a single digit value comes in years or months or days textbox, it should show prefixing 0. application.worksheetfunction.text(arg1,arg2),interval as string is not working and throwing error. Pls clarify. -- 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
Re: $$Excel-Macros$$ about set focus event
thank you so much On Tue, Jan 31, 2012 at 7:53 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thnks On Mon, Jan 30, 2012 at 12:43 AM, Asa Rossoff a...@lovetour.info wrote: Thanks for posting a useful, practical application, Noorain. Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Sunday, January 29, 2012 9:41 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ about set focus event ** ** Dear Shankar, Please see attached sheet.. Private Sub TextBox1_Change() If Len(TextBox1) = 2 Then TextBox2.SetFocus End If End Sub Private Sub TextBox2_Change() If Len(TextBox2) = 2 Then TextBox3.SetFocus End If End Sub On Sat, Jan 28, 2012 at 10:36 AM, Shankar Bheema shankar.n...@gmail.com wrote: Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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
Re: $$Excel-Macros$$ about set focus event
Hai Asa. May I have one example pls. Because I tried but I did not get. regards shankar sb On Sat, Jan 28, 2012 at 1:30 PM, Asa Rossoff a...@lovetour.info wrote: Also, regular form controls support the Enter event which is very similar. It fires when the control gets focus from another control on the form. Form controls also have an Exit event, which is like LostFocus but only among the form's controls (when the form gets/loses focus these events are not fired.) ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff *Sent:* Friday, January 27, 2012 11:47 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ about set focus event ** ** Hello Shankar, If you mean a SetFocus method, form and ActiveX controls have that in Excel. If you mean a GotFocus event, ActiveX controls have that and you can use them in Excel. ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Friday, January 27, 2012 9:07 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ about set focus event ** ** Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- 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 -- 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
Re: $$Excel-Macros$$ doubt with prefix
thank you noorain bhai On Fri, Jan 27, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please see attached sheet and use code format for your coding. On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I attached an userform, in which, frame2 contains total service. Which obtains by deducting date of joining from date of retirement. wherein, if a single digit comes, I need 0 as prefix for example: 1 yrs 2 mnths 3 days should reflect as 01 yrs 02 mnths 03 days. regards shankar sb -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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
$$Excel-Macros$$ about set focus event
Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- 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
Re: $$Excel-Macros$$ saving in different placements of an excelsheet
THANK YOU VERY MUCH SIR On Wed, Jan 25, 2012 at 5:09 PM, Sam Mathai Chacko samde...@gmail.comwrote: Should be Private Sub cmdsave_Click() With Sheet1 With UserForm1 Range(F3) = .Name Range(F4) = .txtdesign Range(F6) = .txtdob Range(F7) = .txtdoj Range(F8) = .txtdor Range(F11) = .txtdor Range(E11) = .txtdoj Range(D29) = .txtpay Range(H29) = .cbogp Range(B40) = .txtpay Range(E40) = .txtGP Range(H40) = .txtda End With With Sheet2 Sheet1.Range(F4).Value = .txtpay Sheet1.Range(G22).Value = .txtpay Sheet1.Range(G27).Value = .txtpay End With End With End Sub End Sub Regards, Sam Mathai Chacko On Wed, Jan 25, 2012 at 11:04 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I tried with the attached excel form. I am getting an error while compilation. Please explain how the F3 cell of the sheet will recognise the text when we represent it like .Name,.Pay,.DOB etc. Printing portion is doing well. regards shankar On Tue, Jan 24, 2012 at 3:22 PM, Shankar Bheema shankar.n...@gmail.comwrote: Thank you very much. On Mon, Jan 23, 2012 at 11:13 PM, Sam Mathai Chacko samde...@gmail.comwrote: And for printing Private Sub CommandButton2_Click() Worksheets(Page1).PrintOut Worksheets(Page2).PrintOut End Sub Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 6:44 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Bheema, use below code format for your query.. Private Sub cmdsave_Click() With Sheet1 with Userform1 .Range(F3)=.Name .Range(F4)=.Design .Range(F6)=.Dob .Range(F7)=.Doj .Range(F8)=.DOR .Range(F11)=.DOR .Range(E11)=.DOJ .Range(D29)=.Pay .Range(H29)=.GP .Range(B40)=.Pay .Range(E40)=.GP .Range(H40)=.Da End with With Sheet2 Sheet1.Range(F4).value=.Pay Sheet1.Range(G22).value=.Pay Sheet1.Range(G27).value=.Pay End With End With End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 23, 2012 at 1:33 PM, Shankar Bheema shankar.n...@gmail.com wrote: Dear Experts In the attached excel workbook contains two sheets page1 and page 2. Page1 is the first page of the application and the page 2 is the second page. The data entered in the userform would be saved corresponding cell (colored as red) in the workbook. I divided the application form in two sheets for the convenience of the data entry but how to print one after another with the single click on the print command button placed in the excel workbook ? regards shankar -- 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 -- Sam Mathai Chacko -- 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
Re: $$Excel-Macros$$ auto change of the combobox data
thank you very much. On Mon, Jan 23, 2012 at 6:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, See attached sheet...Hope your query has been solved. On Mon, Jan 23, 2012 at 1:36 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts In an excel book, each sheet is named with the designation of the employee and that particular sheet contains the names of that particular designation. I placed two combo boxes on the userform, how to link the corresponding data into the comboboxes with an option that choosing a designation would capture only employee names of that particular designation and vice-a-versa ? regards shankar -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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
Re: $$Excel-Macros$$ difference between two dates
thank you very much On Mon, Jan 23, 2012 at 6:24 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please use.. Private Sub txtto_Exit(ByVal Cancel As MSForms.ReturnBoolean) txtdays.Value = VBA.DateDiff(D, txtfrom.Value, txtto.Value) End Sub See attached sheet. - Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 23, 2012 at 1:45 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I am attaching an userform. In which I want to get the difference of days between two dates (it is throwing an error with the code). Last Leave report and the Leave Report number are the headings for the sheet and they should not recur. If the same employee puts two spells of leave, the name should be shown only once in the sheet eg. ___ name FromTo No. of Days Nature of Leave -- shankar 01-01-2012 02-01-2012 02 EL 04-01-2012 07-01-2012 04 EL regards shankar -- 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
Re: $$Excel-Macros$$ Proportionate calculation
Actually for calculation of salary, as per Government orders have to calculated 30 days per month whether it is Feb or Apr or Aug and thank you very much for providing solution for my query On Mon, Jan 23, 2012 at 7:22 PM, Sam Mathai Chacko samde...@gmail.comwrote: You will have to enter 01-05-2012, or you will have to enter 05-Jan-2012 Otherwise, everything works fine. By the way, what's with all days having 30 days? Jan has 31, Feb never has 30.. If you really are worried about the 30, use Private Sub CommandButton1_Click() Dim lngDays As Long, lngActualDays As Long On Error Resume Next lngDays = 30 lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value), Month(TextBox2.Value), Day(TextBox2.Value))) + 1 TextBox3.Value = TextBox1.Value * lngActualDays / lngDays If Err.Number Then TextBox3.Text = End Sub Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: Without looking too close, try /30 Don Guillett SalesAid Software dguille...@gmail.com From: Shankar Bheema Sent: Monday, January 23, 2012 4:06 AM To: excel-macros@googlegroups.com ; Sam Mathai Chacko Subject: Re: $$Excel-Macros$$ Proportionate calculation Dear sir, I attached the excel file. An error is coming in calculation of the proportionate pay. Here, assume that every month should have only 30 days irrespective their actual days. suppose if a person is promoted on 05-01-2012, his pay would reflect as 30-4 ==26 days if pay is 1000/-, (1000/30)*26 days == result regards shankar On Mon, Jan 23, 2012 at 1:22 PM, Shankar Bheema shankar.n...@gmail.com wrote: thank you sir On Sat, Jan 21, 2012 at 9:55 PM, Sam Mathai Chacko samde...@gmail.com wrote: Private Sub CommandButton1_Click() Dim lngDays As Long, lngActualDays As Long On Error Resume Next lngDays = Day(DateSerial(Year(TextBox2.Value), Month(TextBox2.Value) + 1, 0)) lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value), Month(TextBox2.Value), Day(TextBox2.Value))) + 1 TextBox3.Value = TextBox1.Value * lngActualDays / lngDays If Err.Number Then TextBox3.Text = End Sub On Sat, Jan 21, 2012 at 11:23 AM, Shankar Bheema shankar.n...@gmail.com wrote: Dear Experts I am attaching an excel form, in which according to the promotion date text box the proportionate pay text box has to show in the command button event the pay of that particular month according to the days calculation. eg. if the pay is 1000/- pm (consider every calendar month should have 30 days only) suppose if the date of promotion is on 01-09-2011, the proportionate pay will remain 1000/- else if the date of promotion is on 02-09-2011 or 03-09-2011 so on... the remaining days of that particular month should be calculated and shown in that text box. Here if the Date of promotion is on 02-09-2011 remaining days will be 30-1 = 29 (1000/30) * 29 = 966.7 regards -- 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 -- Sam Mathai Chacko -- 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
Re: $$Excel-Macros$$ saving in different placements of an excelsheet
Thank you very much. On Mon, Jan 23, 2012 at 11:13 PM, Sam Mathai Chacko samde...@gmail.comwrote: And for printing Private Sub CommandButton2_Click() Worksheets(Page1).PrintOut Worksheets(Page2).PrintOut End Sub Regards, Sam Mathai Chacko On Mon, Jan 23, 2012 at 6:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Bheema, use below code format for your query.. Private Sub cmdsave_Click() With Sheet1 with Userform1 .Range(F3)=.Name .Range(F4)=.Design .Range(F6)=.Dob .Range(F7)=.Doj .Range(F8)=.DOR .Range(F11)=.DOR .Range(E11)=.DOJ .Range(D29)=.Pay .Range(H29)=.GP .Range(B40)=.Pay .Range(E40)=.GP .Range(H40)=.Da End with With Sheet2 Sheet1.Range(F4).value=.Pay Sheet1.Range(G22).value=.Pay Sheet1.Range(G27).value=.Pay End With End With End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 23, 2012 at 1:33 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts In the attached excel workbook contains two sheets page1 and page 2. Page1 is the first page of the application and the page 2 is the second page. The data entered in the userform would be saved corresponding cell (colored as red) in the workbook. I divided the application form in two sheets for the convenience of the data entry but how to print one after another with the single click on the print command button placed in the excel workbook ? regards shankar -- 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 -- Sam Mathai Chacko -- 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
$$Excel-Macros$$ Saving the form data charaterwise in excel sheet
Pls provide solution for this problem. -- Forwarded message -- From: Shankar Bheema shankar.n...@gmail.com Date: Mon, Jan 23, 2012 at 1:28 PM Subject: Saving the form data charaterwise in excel sheet To: excel-macros@googlegroups.com Dear Experts I attached a VBA form. How to save the data in charaterwise entered in that form into the excel sheet ? regards -- 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 sample datesheet.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Saving the form data charaterwise in excel sheet
Thank you sirji. I will try on it. On Tue, Jan 24, 2012 at 8:40 PM, Sam Mathai Chacko samde...@gmail.comwrote: I have just shown an example for the name. I am sure you can replicate it for all your other fields. 'The strNewLine is optional. It is used as a character that will force to go to the next line. 'For example, if we use + sign as new line feed, Sam Mathai+Chacko, then Chacko will be forced to the next line 'However, if we do not use the new line feed character, like Sam Mathai Chacko, then the entire text will be entered in one line 'Any character can be used for new line feed, and not just '+' Sub CharToCells(rngCells As Range, strText As String, Optional strNewLine As String) Dim lngRows As Long Dim lngCols As Long Dim lngCounter As Long strText = Trim(strText) rngCells.ClearContents For lngRows = 1 To rngCells.Rows.Count For lngCols = 1 To rngCells.Columns.Count lngCounter = lngCounter + 1 If Mid(strText, lngCounter, 1) = Then If InStr(1, Mid(strText, lngCounter + 1) , ) - 1 rngCells.Columns.Count - lngCounter + (rngCells.Columns.Count * (lngRows - 1)) Then If lngRows rngCells.Rows.Count Then lngRows = lngRows + 1 lngCols = Empty GoTo NextLine Else Exit For End If End If End If If lngRows rngCells.Rows.Count And Mid(strText, lngCounter, 1) = strNewLine Then lngRows = lngRows + 1 lngCols = Empty Else rngCells(lngRows, lngCols).Value = Mid(strText, lngCounter, 1) End If NextLine: Next Next End Sub Regards, Sam Mathai Chacko On Tue, Jan 24, 2012 at 3:25 PM, Shankar Bheema shankar.n...@gmail.comwrote: Pls provide solution for this problem. -- Forwarded message -- From: Shankar Bheema shankar.n...@gmail.com Date: Mon, Jan 23, 2012 at 1:28 PM Subject: Saving the form data charaterwise in excel sheet To: excel-macros@googlegroups.com Dear Experts I attached a VBA form. How to save the data in charaterwise entered in that form into the excel sheet ? regards -- 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 -- Sam Mathai Chacko -- 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
$$Excel-Macros$$ auto change of the combobox data
Dear Experts In an excel book, each sheet is named with the designation of the employee and that particular sheet contains the names of that particular designation. I placed two combo boxes on the userform, how to link the corresponding data into the comboboxes with an option that choosing a designation would capture only employee names of that particular designation and vice-a-versa ? regards shankar -- 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 comboform.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Proportionate calculation
thank you sir On Sat, Jan 21, 2012 at 9:55 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() Dim lngDays As Long, lngActualDays As Long On Error Resume Next lngDays = Day(DateSerial(Year(TextBox2.Value), Month(TextBox2.Value) + 1, 0)) lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value), Month(TextBox2.Value), Day(TextBox2.Value))) + 1 TextBox3.Value = TextBox1.Value * lngActualDays / lngDays If Err.Number Then TextBox3.Text = End Sub On Sat, Jan 21, 2012 at 11:23 AM, Shankar Bheema shankar.n...@gmail.com wrote: Dear Experts I am attaching an excel form, in which according to the promotion date text box the proportionate pay text box has to show in the command button event the pay of that particular month according to the days calculation. eg. if the pay is 1000/- pm (consider every calendar month should have 30 days only) suppose if the date of promotion is on 01-09-2011, the proportionate pay will remain 1000/- else if the date of promotion is on 02-09-2011 or 03-09-2011 so on... the remaining days of that particular month should be calculated and shown in that text box. Here if the Date of promotion is on 02-09-2011 remaining days will be 30-1 = 29 (1000/30) * 29 = 966.7 regards -- 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 -- Sam Mathai Chacko -- 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
$$Excel-Macros$$ Saving the form data charaterwise in excel sheet
Dear Experts I attached a VBA form. How to save the data in charaterwise entered in that form into the excel sheet ? regards -- 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 sample datesheet.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Proportionate calculation
Dear Experts I am attaching an excel form, in which according to the promotion date text box the proportionate pay text box has to show in the command button event the pay of that particular month according to the days calculation. eg. if the pay is 1000/- pm (consider every calendar month should have 30 days only) suppose if the date of promotion is on 01-09-2011, the proportionate pay will remain 1000/- else if the date of promotion is on 02-09-2011 or 03-09-2011 so on... the remaining days of that particular month should be calculated and shown in that text box. Here if the Date of promotion is on 02-09-2011 remaining days will be 30-1 = 29 (1000/30) * 29 = 966.7 regards -- 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 pay.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ for print dialog box in excel vba form
Dear Experts Pls provide code line for a command button to invoke Print Dialogue box. thank you -- 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
$$Excel-Macros$$ regarding rounding off
Subject: reply regardingrounding off Kind Attention: Paul Schreiner thank you for your reply and sorry for my late response as I am out of town. What I required is: if a result comes to 20.60 or 20.10 (here whatever be the fraction) it should be rounded off to 20 only if a result comes to 21 or 21.10 or 21.60 it should be rounded off to 30 regards -- 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
$$Excel-Macros$$ rounding off to nearest multiple of 10
Dear experts I am using excel vba. I want to round off an amount to its nearest multiple of 10. eg : 251.10 (here fraction should not be considered only the whole number which has to be rounded off to its nearest multiple of 10 i.e. 260) 252 = 260 but 250 remains 250 Pls do reply -- 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
Re: $$Excel-Macros$$ doubt with rounding off and change event in excel vba
Thank you very much sir. On Thu, Jan 5, 2012 at 6:58 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Use Mround Function ** ** See the attached file ** ** Regards Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Jan/Thu/2012 12:31 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ doubt with rounding off and change event in excel vba ** ** Dear Experts I am attaching an excel vba file. In which I am facing a problem with change event. the addition of textbox2.text + textbox3.text values with the value of 3% of the value of the above both. That 3% value if exceeds 1 rupee it should be rounded off to the next nearest 10 rs. eg: if textbox2.text = 1000 and textbox3.text = 500, 3% on the above addition 45 which means it should be rounded off to the nearest multiple of 10 i.e. 50. The result for the textbox5.text required to be: (1000+50)=1050 Pls do reply. -- 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
$$Excel-Macros$$ doubt with rounding off and change event in excel vba
Dear Experts I am attaching an excel vba file. In which I am facing a problem with change event. the addition of textbox2.text + textbox3.text values with the value of 3% of the value of the above both. That 3% value if exceeds 1 rupee it should be rounded off to the next nearest 10 rs. eg: if textbox2.text = 1000 and textbox3.text = 500, 3% on the above addition 45 which means it should be rounded off to the nearest multiple of 10 i.e. 50. The result for the textbox5.text required to be: (1000+50)=1050 Pls do reply. -- 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 test rounding.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ getting combobox list on form load
thank you very much swapnil for posting solution for my query On Sun, Dec 25, 2011 at 1:09 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, pls find attached file. Regards, Swapnil. On Sun, Dec 25, 2011 at 12:26 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts Here I am attaching a folder called TEST in a zipped format which contains files as test1,test2 and test3. I want to get these file names as a list in the COMBO Box placed in the MS Access form in the Load event. Pls do reply. -- FORUM RULES (934+ 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 (934+ 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 (934+ 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
Re: $$Excel-Macros$$ accessing files through form
thank you so much somnath, I will try and get back to you with the result. On Fri, Dec 23, 2011 at 4:28 PM, Somnath Pardeshi somcparde...@yahoo.co.inwrote: Hi, Try this i have used Adobe Reader 9.0 If their is any other version u ar using then you have to change codes accordingly Thanks and Regards, Somnath C Pardeshi -- *From:* Shankar Bheema shankar.n...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 23 December 2011 11:53 AM *Subject:* $$Excel-Macros$$ accessing files through form Pls provide solution for the query. Dear Experts I am attaching a .mdb file and folder containing PDF files. I want to get the list of Pdf in each folder when the folder name is accessed through the form. and I want to open the respective pdf file after clicking OK for printing purpose. Pls do the help. regards -- FORUM RULES (934+ 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 (934+ 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 (934+ 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
Re: $$Excel-Macros$$ how to restrict character size for a textbox control
thank you for the solution and i will try it On Thu, Dec 15, 2011 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please try through below link, hope it will help to u. http://allenbrowne.com/ser-34.html -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Dec 15, 2011 at 7:13 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts How to restrict character size for a textbox control for MS ACCESS 2003. THANK YOU -- FORUM RULES (934+ 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 (934+ 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 (934+ 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
Re: $$Excel-Macros$$ doubt with rounding off and totalling of the amounts
thank you very much ansari bhai. wil try and get back to you. On Fri, Dec 16, 2011 at 9:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please see attachement.hope it will help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Dec 16, 2011 at 1:26 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I am attaching the .mdb file. which contains combobox and i want to add some items under dropdown list. With the code I written it is not working. Pls provide solution for that. I want to get the rounding off the persentage of the addition value of the first text box and the value of the combo box. all the above results should be shown in the last textbox as TOTAL. regards -- FORUM RULES (934+ 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 (934+ 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 (934+ 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
$$Excel-Macros$$ how to restrict character size for a textbox control
Dear Experts How to restrict character size for a textbox control for MS ACCESS 2003. THANK YOU -- FORUM RULES (934+ 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
$$Excel-Macros$$
Dear Experts How to assign max length for a textbox control in MSAccess 2003. In properties, no such facility is available. How can it be assigned through Code. regards shankar sb -- FORUM RULES (934+ 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
$$Excel-Macros$$ accessing pdf files
Dear Experts For example, One folder contains some pdf files. Folder is named as file number If I supplied the particular file number to a textbox created in EXCEL VBA Form and after clicking OK command button, the list of pdf's in a folder to be opened in a separate list with the hyperlink facility. Pls provide me solution for this problem. REGARDS SHANKAR SB -- FORUM RULES (934+ 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
$$Excel-Macros$$ max length for textbox control
Dear Experts How to assign max length for a textbox control in MSAccess 2003. In properties, no such facility is available. How can it be assigned through Code. regards shankar sb -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ doubt with msaccess 2003
thank you so much for your response. I will try and get back to you with the result. If possible pls clarify my rest of doubts put in our community. On Tue, Dec 13, 2011 at 4:06 PM, Maries talk2mar...@gmail.com wrote: Hi, use the below code. It will work. Private Sub cmdnetser_Click() Dim year1 As Double Dim year2 As Double Dim yearresult As Double Dim month1 As Double Dim month2 As Double Dim monthresult As Double Dim day1 As Double Dim day2 As Double Dim dayresult As Double ' for net qualfying service lblnetqs.Visible = True lblnetyrs.Visible = True txtnetyrs.Visible = True lblnetmths.Visible = True txtnetmths.Visible = True lblnetdays.Visible = True txtnetdays.Visible = True year1 = ttotyrs year2 = txtnonyrs month1 = ttotmths month2 = txtnonmths day1 = ttotdays day2 = txtnondays If year1 year2 And month1 month2 And day1 day2 Then yearresult = year1 - year2 monthresult = month1 - month2 dayresult = day1 - day2 End If txtnetyrs = yearresult txtnetmths = monthresult txtnetdays = dayresult End Sub Regards, MARIES. On Tue, Dec 13, 2011 at 12:43 PM, Shankar Bheema shankar.n...@gmail.comwrote: Good Afternoon I am in preparation of a calculation sheet for my office purpose in ms access 2003. I am enclosing the file for your reference. In the Form, Right Frame containing Qualifying service i am facing a problem. When I click on Yes for the Non Qualifying Service, I have to give the years, months and days. I have written a code in Show Net Service command button for obtaining the difference in the Net yers, net months and net days. But it is not displaying. Pls provide solution. -- FORUM RULES (934+ 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 (934+ 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 (934+ 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
$$Excel-Macros$$ Delivery Status Notification
Dear Experts Good Morning I am attaching an excel vba form. In which I placed a label, textbox and a command button. *When we supply a file number, it should open all the related PDF documents kept in a folder in a list box with hyperlinks to enable us to show the contents in pdf format.* Each relevant file numbered folder contains a couple of pdf documents. The form should display all the pdf documents in a list box. thank you -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ Delivery Status Notification
noorain bhai attachment is not accepting by the domain On Mon, Dec 12, 2011 at 8:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Attachment is missing. On Mon, Dec 12, 2011 at 8:31 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts Good Morning I am attaching an excel vba form. In which I placed a label, textbox and a command button. *When we supply a file number, it should open all the related PDF documents kept in a folder in a list box with hyperlinks to enable us to show the contents in pdf format.* Each relevant file numbered folder contains a couple of pdf documents. The form should display all the pdf documents in a list box. thank you -- FORUM RULES (934+ 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ 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 (934+ 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
$$Excel-Macros$$ text assignment to the textbox control
Dear experts Good morning, I am trying to assign a FIXED TEXT for a TEXTBOX1 Control in MSACCESS 2003. I have given a code line like: text1.text=Good Morning But it is not assigning the text given in strings. Pls suggest me how to assign a fixed text to a text box control. Thank you. -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ Re: saving command button not functioning
thank you very much Kishan On Thu, Dec 8, 2011 at 11:37 AM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Please add the following code. rst.update after assigning values to the fields Also instead of using rst.fields(0), --- you can use rst.fields(fileno) which will be more legible and readable. Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(select * from t_main) rst.AddNew rst.Fields(0) = txtfileno rst.Fields(1) = txtempname rst.Fields(2) = txtempdesign rst.Fields(3) = txtdob rst.Fields(4) = txtdoj rst.Fields(5) = txtdor rst.Fields(6) = ttotyrs rst.Fields(7) = ttotmths rst.Fields(8) = ttotdays rst.Fields(9) = txtnonyrs rst.Fields(10) = txtnonmths rst.Fields(11) = txtnondays rst.Fields(12) = txtnetyrs rst.Fields(13) = txtnetmths rst.Fields(14) = txtnetdays rst.Update End Sub Regards, Kishan Reddy, K -- FORUM RULES (934+ 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 (934+ 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
Re: $$Excel-Macros$$ help needs to connect form controls to the table
Dear Sam How to restrict max length of characters in a text box for MS ACCESS 2003 ? On Mon, Nov 21, 2011 at 9:57 PM, Sam Mathai Chacko samde...@gmail.comwrote: I don't see any remaining doubts! What doubts do you have? Sam On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema shankar.n...@gmail.comwrote: thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote: You have to create a recordset by using the OpenRecordSet command in the CurrentDB Use Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(SELECT * FROM t_main) rst.AddNew 'Add the Payment record rst.Fields(0).Value = txtfileno 'Payment ID rst.Fields(1).Value = txtempname 'W.O. # End Sub Also, your first column has a data type of Number. However, the txtfileno variable contains a string / text value. That will have to be corrected also. I have fixed this in the attached database. Regards, Sam Mathai Chacko On Sat, Nov 19, 2011 at 4:32 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I created a form with MSACcess 2003, I placed a command button on the form for saving the data into the table. But it is throwing an error. Pls check and suggest me solution. -- FORUM RULES (934+ 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 -- Sam Mathai Chacko -- FORUM RULES (934+ 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 (934+ 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 -- Sam Mathai Chacko -- FORUM RULES (934+ 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Re: $$Excel-Macros$$ help needs to connect form controls to the table
thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote: You have to create a recordset by using the OpenRecordSet command in the CurrentDB Use Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(SELECT * FROM t_main) rst.AddNew 'Add the Payment record rst.Fields(0).Value = txtfileno 'Payment ID rst.Fields(1).Value = txtempname 'W.O. # End Sub Also, your first column has a data type of Number. However, the txtfileno variable contains a string / text value. That will have to be corrected also. I have fixed this in the attached database. Regards, Sam Mathai Chacko On Sat, Nov 19, 2011 at 4:32 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I created a form with MSACcess 2003, I placed a command button on the form for saving the data into the table. But it is throwing an error. Pls check and suggest me solution. -- FORUM RULES (934+ 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 -- Sam Mathai Chacko -- FORUM RULES (934+ 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 (934+ 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
Re: $$Excel-Macros$$ possibility of form creation in msaccess 2003 like excel vba
Good morning experts !! waiting for your valuable suggetions On Mon, Nov 7, 2011 at 4:49 PM, Shankar Bheema shankar.n...@gmail.comwrote: I am presenting my excel VBA form below and also as an attachment of the screenshot. http://i40.tinypic.com/wa3ekl.jpg With the help of all of this forum I created and simplified my work at office. Now, I would like to generate the same form in msaccess but I am not able to get the calculations on the form with the click events i used in excel. Pls provide me solutions or an example file to know how to get calculations on the click even in msaccess form. Because I want to make automated reports for the application. Pls provide solution experts. -- FORUM RULES (925+ 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 (925+ 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
$$Excel-Macros$$ doubt
Hai All, I created a calculation form in EXCEL 2003 VBA. I placed save, update and etc commands on the VBA form. The data which I enter will save in excel format. Is it possible to prepare reports using MSACCESS 2003 for generating reports using the stored data in excel ? -- FORUM RULES (925+ 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
$$Excel-Macros$$ Doubt
Hai all. My query relates to MS ACCESS. Friends, how to make the MSACCESS designed form application an executable one. means how to hide code part. Because I made a form and want to give other users in my office. If anything went wrong my effort will goes to waste. So, I want to hide the code part. Is it possible to make the MS ACCESS form an executable one like in VB ? Pls help me -- -- 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$$ Doubt
I am using 2003 office. On Thu, Oct 20, 2011 at 7:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Bheema, It is possible,,, In MS Access 2007 Goto : *Database Tools*-*Visual Basic*-In Right part Collaspe all fields-Right Click and Project Properties-Protection and Set password with Checked Lock Project for viewing. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Oct 20, 2011 at 6:21 PM, Shankar Bheema shankar.n...@gmail.comwrote: Hai all. My query relates to MS ACCESS. Friends, how to make the MSACCESS designed form application an executable one. means how to hide code part. Because I made a form and want to give other users in my office. If anything went wrong my effort will goes to waste. So, I want to hide the code part. Is it possible to make the MS ACCESS form an executable one like in VB ? Pls help me -- -- 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 -- -- 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$$ Code request
Dear All May I get any expert attention for my problem with regard to the crystal report and excel vba userform. How to open a designed crystal report from the excel vba userform by a command button ? What I have to select from the check boxes in the reference option of Tools Menu of Excel vBA userform ? -- -- 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$$ pls help
Pls do reply experts.. On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema shankar.n...@gmail.comwrote: where do i get help for Crystal reports 9 problems ? -- -- 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
Re: $$Excel-Macros$$ datediff problem
THANK YOU SO MUCH SAM. On Fri, Sep 16, 2011 at 6:50 AM, Sam Mathai Chacko samde...@gmail.comwrote: Not sure if you can. But you can use this Private Sub ComboBox9_Change() Dim dtmStart As Date Dim dtmEnd As Date If Day(CDate(TextBox1.Text)) 12 Then dtmStart = CDate(TextBox1.Text) Else dtmStart = DateSerial(Year(CDate(TextBox1.Text)), Day(CDate(TextBox1.Text)), Month(CDate(TextBox1.Text))) End If If Day(CDate(TextBox2.Text)) 12 Then dtmEnd = CDate(TextBox2.Text) Else dtmEnd = DateSerial(Year(CDate(TextBox2.Text)), Day(CDate(TextBox2.Text)), Month(CDate(TextBox2.Text))) End If TextBox17.Text = DateDiff(m, dtmStart, dtmEnd) TextBox3.Text = (TextBox13.Text + Val(ComboBox9.Text)) * TextBox17.Text End Sub Private Sub UserForm_Initialize() ComboBox9.List = Array(1800, 1900, 2400, 2800, 4200, 4600, 4800, 5400, 6600, 7600, 8700, 8900, 1) End Sub Regards, Sam Mathai Chacko (GL) On Thu, Sep 15, 2011 at 9:06 PM, Shankar Bheema shankar.n...@gmail.comwrote: cant we change it for indian format ? On Thu, Sep 15, 2011 at 8:43 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Bheema, Please try it..and see attached sheet.. ** *Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox17.Text = VBA.DatePart(m, CDate(TextBox2.Text)) - VBA.DatePart(m, CDate(TextBox1.Text)) End Sub * -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Sep 15, 2011 at 7:25 PM, Shankar Bheema shankar.n...@gmail.comwrote: hai all, I am attaching my excel sheet userform. I am getting wrong result of months in different way. for example : Actual months difference between 01-02-2011 and 30-06-2011 are 5 months but the result coming as 4 pls provide solution -- -- 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 -- -- 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 -- -- 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
$$Excel-Macros$$ extract figure from one userform to other userform
I am attaching the example file. userform1 contains A and B textboxes. B value should get from the other form. -- -- 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 example.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ code to link report form to the userform
I am using crystal report 9 to make reports from excel data. How to access the report from the userform command button ? -- -- 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$$ opening a particular record from the userform
I am having excel data and designed a form using EXCEL VBA. each record of the excel is represented with a number. I will call the data onto the userform using the particular number. When I connected the excel data to my crystal reports 9, all the records are coming onto the report form. But I want to call only a particular record from excel. What would be the solution for this ? -- -- 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$$ extract figure from one userform to other userform
its working and thank you so much for the solution. On Thu, Sep 15, 2011 at 6:29 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Bheema, Please see attached sheet..if it help to u.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Sep 15, 2011 at 6:01 PM, Shankar Bheema shankar.n...@gmail.comwrote: I am attaching the example file. userform1 contains A and B textboxes. B value should get from the other form. -- -- 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 -- -- 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$$ datediff problem
hai all, I am attaching my excel sheet userform. I am getting wrong result of months in different way. for example : Actual months difference between 01-02-2011 and 30-06-2011 are 5 months but the result coming as 4 pls provide solution -- -- 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 datediff.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ about dateserial
Pls explain the usage of Dateserial function ? if possible provide me example -- -- 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$$ datediff problem
cant we change it for indian format ? On Thu, Sep 15, 2011 at 8:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Bheema, Please try it..and see attached sheet.. ** *Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox17.Text = VBA.DatePart(m, CDate(TextBox2.Text)) - VBA.DatePart(m, CDate(TextBox1.Text)) End Sub * -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Sep 15, 2011 at 7:25 PM, Shankar Bheema shankar.n...@gmail.comwrote: hai all, I am attaching my excel sheet userform. I am getting wrong result of months in different way. for example : Actual months difference between 01-02-2011 and 30-06-2011 are 5 months but the result coming as 4 pls provide solution -- -- 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 -- -- 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$$ doubt in report generation
I am trying to design report with crystal report 9. It is not having to design in FORM VIEW. All designs are in columner form. Pls do help me. -- -- 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$$ connecting code to the report
I used the following code to connect the report sheet Dim rep As New CrystalReport rep.ReportFileName = f:\test CRViewer1.ReportSource = rep CRViewer1.ViewReport End Sub But its throwing error as USER DEFINED TYPE NOT DEFINED -- -- 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$$ accessing crystal reports through VBA
How to access crystal report form with VBA ??? -- -- 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$$ date difference
Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 dOr.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ date difference
but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- -- 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$$ date difference
I tried with the provided code but its working only with the years but months and days are not working On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote: Private Sub CommandButton1_Click() txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1, DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text))) End Sub Regards, Sam Mathai Chacko (GL) On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote: but i am using userform na sir. So pls see my attachment and i am not understanding the mistake i did in my code On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote: Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) *From:* Shankar Bheema shankar.n...@gmail.com *Sent:* Monday, September 12, 2011 9:54 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be last day of the month if date of birth is on 28-04-1981 then date of retirement would in the last day of the April month i.e. 30-04-2041 iii) if the date of retirement falls in the month of February and if it is a leap year then the retirement date would be 29th feb. iv) If date of birth fells on 1st of the month the retirement date would be the last day of the last month eg. if Dob is 01-01-2012 then the date of retirement would be 31-12-2011. I have written code for that but its not throwing errors. if there is any simplest way may kindly be suggest. -- -- 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 -- -- 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 -- -- 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