$$Excel-Macros$$ Re: Excel - Return on Investment
yearly On Tuesday, October 14, 2014 3:34:22 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, how do we calculate the ROI as I have upload the excel. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel calculating repayment and interest
Workbook upload. Please advise On Fri, Oct 10, 2014 at 6:39 PM, Vaibhav Joshi v...@vabs.in wrote: pl share excel file. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 10, 2014 at 10:54 AM, Falina Gan falina...@gmail.com wrote: To Whom It May Concern, May I ask how do you calculate the table that show per-attachment especially on the principle repayment and interest? We hope to hear from you soon. Thanks. Regards, Falina -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/B7ieCoeg9eE/unsubscribe. To unsubscribe from this group and all its topics, 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. repay.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Additional Control
To Ashish, The article is for Windows XP and Office 2007. Do you have the experience in Microsoft Office Standard 2010- 32 bit? Hope to hear from you soon. Thanks. On Friday, April 18, 2014 1:47:34 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, why can;t we click the additional Controls to create a new calender? Here is the image as below:- Thanks. https://lh3.googleusercontent.com/-W66RRb-bSOE/U1C735uHbiI/AGs/QMrtJZswwsc/s1600/additional+control.png -- 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$$ Additional Control
To Whom It May Concern, May I ask, why can;t we click the additional Controls to create a new calender? Here is the image as below:- Thanks. https://lh3.googleusercontent.com/-W66RRb-bSOE/U1C735uHbiI/AGs/QMrtJZswwsc/s1600/additional+control.png -- 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$$ Random numbers in decimal
To Whom It May Concern, Could you write in VBA on decimal random numbers? Hope to hear from you. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Creating UserForm on Upper, Lower and Proper case
To all, Thanks and I will try to understand it. On Thursday, April 10, 2014 3:38:52 PM UTC+8, Falina Gan wrote: To Whom It May Concern, I would like to know how we are going to create a user form as the subject above using VBA. Thanks. https://lh4.googleusercontent.com/-299NkMB7i2o/U0ZKbcd4DII/AGY/-AEVFSSXQEc/s1600/Case+Changer.png -- 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$$ Creating UserForm on Upper, Lower and Proper case
To Whom It May Concern, I would like to know how we are going to create a user form as the subject above using VBA. Thanks. https://lh4.googleusercontent.com/-299NkMB7i2o/U0ZKbcd4DII/AGY/-AEVFSSXQEc/s1600/Case+Changer.png -- 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$$ Re: How to identify which is text, integers, date, time in a table?
HI Basole, Sorry to make you another round of questions. I have tried in a new spreadsheets for me to understand the codes that you have created:- I have no idea, when I copy your codes in my new spreadsheets to run the application, it seems doesn't work. Here is the final images as below:- https://lh6.googleusercontent.com/-nnwcoxhayZ8/U0JdlKd_8WI/AGI/fXHAr121ttY/s1600/listofinfo.png On Monday, April 7, 2014 3:39:21 PM UTC+8, Falina Gan wrote: Hi Basole, Thanks for changes on the file to ABC.xlsm and the temperatures column. It takes time for me to digest your professional codes. I hope you don;t mind if I ask too many questions. Here are the questions on below:- 1) You have identify the name of the sheets, for example, Range(d sheet1.Range(d1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl. Can we name the workbook in vba code editor such as , book1 = ABC.xlsm sheet1 = sheet1 Range(d book1. sheet1.Range(d1).Offset(book1. sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 2) Correct me if i am wrong here, most of your codes are - Range(e sheet1.Range(e1), Range(f sheet1.Range(f1).Offset, Range(c sheet1.Range(c1).Offset. and the rest.Offset, are removing the cell from entering the data which is on the first row. 3) Can you make me understand on the other half, (sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl and (sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1).NumberFormat = hh.mmam/pm 4) Can you make me understand the codes as below:- Public Function CountChrInString(Expression As String, Character As String) As Long Dim iResult As Long Dim sParts() As String sParts = Split(Expression, Character) iResult = UBound(sParts, 1) If (iResult = -1) Then iResult = 0 End If CountChrInString = iResult End Function Function CheckForNumber(strg As String) As Boolean Dim i As Integer For i = 1 To Len(strg) If IsNumeric(Mid(strg, i, 1)) Then CheckForNumber = True Exit Function End If Next i End Function Function ContainDigit(sText As String) As Boolean ContainDigit = (sText Like *#*) End Function 6) Thirdly, even we click the stop button at the vba code editor, but the excel application still runs, any reason? I did not understand which button you refer to? Please refer the image as below:- ( highlighted in black box) https://lh3.googleusercontent.com/-cD2hakAEUCg/U0JVb375q6I/AFw/cCW6gcG8wqM/s1600/vbabtn.png It still can run the Start Code button or Clean button. https://lh3.googleusercontent.com/-payxCrdN1YA/U0JV1aIPGzI/AF4/FD1gncMZ3xQ/s1600/excelapp.png We hope to hear from you. Thanks. Falina On Monday, April 7, 2014 12:04:41 PM UTC+8, Basole wrote: Dear Falina Gan, Thank you very much. See the attachment, the answers to your questions are in the spreadsheet. Regards, Basole. 2014-04-06 12:42 GMT-03:00 Falina Gan fali...@gmail.com: Hi Basole, While testing your application, how can we do the error handling when the numbers are not suppose in the text column? Refer the image as below:- Thank you. https://lh4.googleusercontent.com/-yyG9qgr10e0/U0F1wnfs6gI/AFg/-0W_obNfhIM/s1600/abc1.jpg On Sunday, April 6, 2014 11:25:31 PM UTC+8, Falina Gan wrote: Hi Basole, Thank you for your brilliant codes especially you have identify which sheets that we need to run the application. May I ask how about the project name such as ABC.xlsm? Secondly, the symbol @ is for any string? Thirdly, even we click the stop button at the vba code editor, but the excel application still runs, any reason? Can we put a temperature or degree column in for column F? how do we do it in vba? We hope to hear from you. On Sunday, April 6, 2014 9:22:13 AM UTC+8, Basole wrote: Hi Falina, See the attachment I inserted the explanation in the commentary of the vba code editor. Corrected some errors and drafted the macro. Regards, Basole. 2014-04-05 1:52 GMT-03:00 Falina Gan fali...@gmail.com: Thanks Basole, The codes are running well but can I ask from your codes for my understanding as a learner. Could you explain as below:- 1) z = sheet1.Range(a1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row 2) Set cl = .Cells(i, 1) 3) Case IsEmpty(cl) Case InStr(cl.NumberFormat, :mm) 0 Range(e sheet1.Range(e1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 4) Range(c sheet1.Range(c1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 5) If a user key in a data, for example, today's date, does it affect the codes as well? Hope to hear from your good solutions. On Friday, April 4, 2014 11:41:19 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time
$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()
Hi Ashiah, Thank you for your advise on the range. Could I ask you some questions as below:- 1) Why do we use If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then is it that the cell must not be empty and not a date? 2) If a user want to change the whole column rather than the cell, can we do it? Is it For Each cl In Selection.Col? 3) If you refer back the image, how about the D - fruit column? We hope to hear from you. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()
Hi Ashish, Good day, I have tested your codes but the texts are not changes at all. The macro have asked me which one to run and I have run all the sub function but still can't see the results. Thanks https://lh5.googleusercontent.com/-Q7t-x2gsqIY/U0AuFWKT9vI/AFE/-umQsMjybL0/s1600/lower.jpg Here is my images for your reference. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ How to identify which is text, integers, date, time in a table?
To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time in a table such as:- Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: How to identify which is text, integers, date, time in a table?
Thanks Basole, The codes are running well but can I ask from your codes for my understanding as a learner. Could you explain as below:- 1) z = sheet1.Range(a1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row 2) Set cl = .Cells(i, 1) 3) Case IsEmpty(cl) Case InStr(cl.NumberFormat, :mm) 0 Range(e sheet1.Range(e1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 4) Range(c sheet1.Range(c1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 5) If a user key in a data, for example, today's date, does it affect the codes as well? Hope to hear from your good solutions. On Friday, April 4, 2014 11:41:19 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time in a table such as:- Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Delete button on Sequence Column
To Whom It May Concern, Could you guide me with VBA codes, on these steps:- 1) Create a sequence column as image below ( all in alphabets ) 2) Delete button to delete the sequence column 3) Then the pattern column is in A column. ( refer to your right side ) Hope to hear from you. Thanks https://lh3.googleusercontent.com/-Hz697YMgPPM/Uz-NmT7WsNI/AEc/DDx5v2sFrMY/s1600/pattern.jpg -- 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$$ How to define the uppercase, lowercase and proper()
To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()
To Whom It May Concern, In VBA please. thanks. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.