$$Excel-Macros$$ Hidden sheets
I have the following code in my Excel 2007 Application.Worksheets(Log).Visible = True and Application.Worksheets(Log).Visible = False on my own computer I have run this in Excel 2007, 2010 and 2013 without a problem - I am running on Windows 7 I have given this workbook to an associate and whenever he runs the macros which picks up this code it shows a runtime error on this code. Any idea why this is happening. He is running Excel 2013 on windows 8 -- 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$$ Problem with searching through rows and their associated columns
Dear All, I am new to VBA programming I happen to need great and urgent help on a project that I am currently working on I would like to search through the worksheet, and find N or TR on row 6 Then, For every cell in the column of N or TR if all the cells are blank, then delete/ hide the column if the cells are not blank, highlight the cells that are in blank This sounds easy but I think it requires two for loops. I appreciate any contributions! Sub checkandhide() Set r = Range(6:6) Rows(7:7).Select For Each Cell In r Selection.Find(What:=N, After:=ActiveCell, LookIn:=xlFormulas, LookAt_ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase := _ False, MatchByte:=False, SearchFormat:=False).Activate 'search for N Application.Run deletecolumn Next End Sub *Sub deletecolumn() ActiveCell.Offset(6, 0).Select Range(Selection, Selection.End(xlDown)).Select For Each Cell.Value In Selection If Cell.Value = Then 'some code that let the loop goes on Else ActiveCell.Columns.Delete End If Next End Sub* https://lh6.googleusercontent.com/-mbWxnUGYXQ8/UdTP5k_XBtI/AA8/wSQW-PG043o/s872/help.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/groups/opt_out.
Re: $$Excel-Macros$$ Re: Match text to a list
Kris, Sorry, you are quite right. I made the mistake of copying the previous code and replacing the prvious code with the previous codes. thank you so much for your patience. On Thu, Mar 22, 2012 at 2:49 PM, Kris krishnak...@gmail.com wrote: That's not true. MATCH(A,**L6:L27,0) is not equal to MATCH(AA,**L6:L27,0). Can you attach the workbook ? Kris -- 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$$ Re: Match text to a list
This works just as well as the other code but still has the problem, If range (L6:L27) has the letters AA in it then it shows A as a match and says report A is already done On Wed, Mar 21, 2012 at 4:34 PM, Kris krishnak...@gmail.com wrote: Hi Replace Flg = Evaluate(ISNUMBER(LOOKUP(9.**999E+307,SEARCH(D18,L6:L27)))**) with Flg = Evaluate(ISNUMBER(MATCH(D18,L6:L27,0))) Kris -- 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$$ Re: Match text to a list
The code you supply works perfectly except for one issue. I am checking a column to see if I have run a report before and therefore the check for the match. The problem is I have one report marked AA and another marked A. If I have run the report AA before then when I run the report A, the code is indicating that the report has already been run. It seems to be seeing the AA as a match On Sat, Mar 10, 2012 at 7:25 PM, dguillett1 dguille...@gmail.com wrote: isnumber is based on the SEARCH returning same Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Brian brianfosterbl...@gmail.com *Sent:* Saturday, March 10, 2012 10:53 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Match text to a list Thank you Kris, your solution works perfectly. I was just wondering why you use IsNumber when it is actually text I am looking for? I mean it works but I am just curious. On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote: I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this 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$$ Replace letters with numbers
I am using Excel 2007 I have a list of single letters A to F in column H2 to H26 These letters are are mixed but only one capital letter per cell I want to go to this list and replace each letter by its numerical value. So A becomes 1, B becomes 2, C becomes 3 and so on to the letter F Can you please help with 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
$$Excel-Macros$$ Create range and select it
I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another area of the workbook to paste the values only. I understand most of it but am stuck when I try to got to the range referencce to select it to copy. In cell P10 I have this formula P7:P8 which crreates the range of the squad. I then have this line of code to go to that reference Range (P10).value.select This is what does not work. I thought it could be because I actually have a formula in P10 so I tried copying this and pasting the value in P9 and then let my line of code refer to P9 but that does not help. Can someone please assist. -- 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$$ Re: Create range and select it
Thanks I have attached the file On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another area of the workbook to paste the values only. I understand most of it but am stuck when I try to got to the range referencce to select it to copy. In cell P10 I have this formula P7:P8 which crreates the range of the squad. I then have this line of code to go to that reference Range (P10).value.select This is what does not work. I thought it could be because I actually have a formula in P10 so I tried copying this and pasting the value in P9 and then let my line of code refer to P9 but that does not help. Can someone please assist. -- 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 2.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Create range and select it
Just remembered to mention that when I go to the Master sheet (Not in the attached file) I am changing the day of the competition and that changes the ranges and times on the squad. Thant is why in the attached worksheet I am copying the range 4 times. On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another area of the workbook to paste the values only. I understand most of it but am stuck when I try to got to the range referencce to select it to copy. In cell P10 I have this formula P7:P8 which crreates the range of the squad. I then have this line of code to go to that reference Range (P10).value.select This is what does not work. I thought it could be because I actually have a formula in P10 so I tried copying this and pasting the value in P9 and then let my line of code refer to P9 but that does not help. Can someone please assist. -- 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$$ Re: Create range and select it
This just copies the contents of Range P10 it does not copy the range which P10 referrs to. I have not attached the whole workbook as it is huge so I just took the relevant worksheet and the piece of code I am struggling with and attached that. where the code refers to the Master Sheet on the Master sheet in cell B5 I change the day and this changes the ranges and times on the squad sheet for that day. That is why I copy the same range 4 times (once after each day change) On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another area of the workbook to paste the values only. I understand most of it but am stuck when I try to got to the range referencce to select it to copy. In cell P10 I have this formula P7:P8 which crreates the range of the squad. I then have this line of code to go to that reference Range (P10).value.select This is what does not work. I thought it could be because I actually have a formula in P10 so I tried copying this and pasting the value in P9 and then let my line of code refer to P9 but that does not help. Can someone please assist. On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another area of the workbook to paste the values only. I understand most of it but am stuck when I try to got to the range referencce to select it to copy. In cell P10 I have this formula P7:P8 which crreates the range of the squad. I then have this line of code to go to that reference Range (P10).value.select This is what does not work. I thought it could be because I actually have a formula in P10 so I tried copying this and pasting the value in P9 and then let my line of code refer to P9 but that does not help. Can someone please assist. -- 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$$ Match text to a list
I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this 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
$$Excel-Macros$$ Re: Match text to a list
I am getting an error on i = Application.WorksheetFunction.Match(Source, target) On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote: I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this code. On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote: I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this 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
$$Excel-Macros$$ Re: Match text to a list
Thank you Kris, your solution works perfectly. I was just wondering why you use IsNumber when it is actually text I am looking for? I mean it works but I am just curious. On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote: I am using Excel 2007 In cell D18 I have some text. I need the VBA to check if this text appears in the list in Cells L6:L27 If it does it then exits the sub otherwise it must do something else. Can anyone help with this 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
Re: $$Excel-Macros$$ VBA from Excel 2003 to 2010
Thanks, Problem solved On Oct 22, 3:57 am, abhishek pandey gjobabhis...@googlemail.com wrote: Hi You can use the converter technology Office Converter or OMPM for office 2010. Thanks Regards Abhishek On Thu, Oct 20, 2011 at 10:21 PM, Brian brianfosterbl...@gmail.com wrote: I have designed a number of macros in Excel 2003 and had no problems when I upgraded to 2007. However I am having problems reported for users using my macros in Excel 2010 I do not want to upgrade to Excel 2010 at this time and I was wondering if there is any compatabilty checker I can use in Excel 2007 which will identify problems or soilutions if I run it in 2010 I have heard of a VBA compatability checker for 2010 and was wondering where I can get it and if I can only use this if I have Excel 2010 -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 -- 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
Re: $$Excel-Macros$$ Date from textbox reversed.
Thank you - both work. and also thanks to Paul for helping me to shorten my code However, here is an interesting fact If in textbox 1 I enter 12/9/11 the text in the worksheet shows a 9/12/2011 but if i enter 12/9/2011 then the text shows as 12/9/2011 On Sep 9, 7:52 pm, Paul Schreiner schreiner_p...@att.net wrote: How is the date entered into the textbox? perhaps Excel isn't recognizing the value as an actual date... Try this:] if (isdate(frmApplications.TextBox1.Value)) then ActiveCell.Value = Format(frmApplications.TextBox1.Value)) , dd/mm/) end if I'm suspecting that the value in the textbox is being entered as a string that Excel isn't recognizing as a date, so it enters it as Text. also.. You don't really have to do all of the selects... ActiveCell.Value = Date ActiveCell.Offset(0, 1).Value = FrmApplications.TextBox1.Value should work just as well. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Brian brianfosterbl...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Fri, September 9, 2011 12:56:17 PM Subject: $$Excel-Macros$$ Date from textbox reversed. I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select Activecell.Value = Date works perfectly as it places the date in column A correctly in the format set for my computer dd/mm/ In textbox 1 I am entering a date in the form but when this is pulled into the cell in column B it reverses the date to mm/dd/ although my windows setting has been set to the format that appears in colmn A How do I correct this? I am using Excel 2007 -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://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$$ Date from textbox reversed.
I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select Activecell.Value = Date works perfectly as it places the date in column A correctly in the format set for my computer dd/mm/ In textbox 1 I am entering a date in the form but when this is pulled into the cell in column B it reverses the date to mm/dd/ although my windows setting has been set to the format that appears in colmn A How do I correct this? I am using Excel 2007 -- -- 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 in VBA
I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select The first entry enters the date in column A correctly in the format set for my computer dd/mm/ But in column B when the date is pulled in from the date entered in textbox 1 it reverses the date to mm/dd/ although my windows setting has been set to what appears in colmn A How do I correct this? I am using Excel 2007 -- -- 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$$ Re: HELP urgent
If you are using Excel 2007, then you can do part of this without VBA. If you want to change color of cell, for example, when the cell value is negative, you can accomplish this by going to Home Conditional Formatting and then creating a rule by which the cell changes. This is probably easier than fiddling with VBA to accomplish the same thing. To tackle your year question, I would probably figure out how to write a subroutine that would be activated upon a change in the worksheet. Whenever you make a change, this subrouting would be triggered to run. I would then run a loop using the range.offset property such that the loop counter is used to run down the rows and perform an algorithm on each row to check the value and copy your year. -- -- 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$$ Using VBA Macros to control GPIB equipment
National Instruments website has an example spreadsheet that can accomplish this: http://zone.ni.com/devzone/cda/epd/p/id/798 I've expanded the ni-488.2_in_excel.xls spreadsheet from this website to do just about anything you want to with test equipment over GPIB. -Brian -- -- 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$$ Re: Conditional Format Duplicate Rows
Combine the cells like so... A1B1C1 etc then use COUNTIF with the coniditional formatting. For example in G2 put =A2B2C2D2E2 (you can hide column H). Then for the conditional formatting start at A2 and use formula =IF(A2,IF(COUNTIF($G:$G, $G2)1,TRUE,FALSE)) On Feb 24, 9:35 am, John A. Smith johnasmit...@gmail.com wrote: Your kind help please. I have a database that I need to see duplicated rows but can't filter because some columns can legitimately repeat. If the entire row is a duplicate, I need to know. Please see attached example. Thanking you in advance for your continuing help in learning Excel. John Highlight Duplicated Rows Example.xls 24KViewDownload -- -- 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$$ Matching up two columns with different data
Okay, so here's my dilemma. I have 2 different systems that I am trying to match up. System A has about 1600 lines, system B has about 1000. A is the older system and has a lot of lines that don't matter much anymore. B has some things that aren't in A, but doesn't need a lot of the stuff in A. I'm trying to get the descriptions from A into B. So, here's what I've got. Columns A C are item number, B D are description. I'm trying to match up the columns by item number. Example: A B C D 1 glass 1 3 metal 2 stone 4 wood 3 6 other 5 I need to match up columns A C (inserting spaces where needed) so I can see what lines have descriptions that need moved from System A to System B (some have already been manually moved). I have a VB script that does it to some degree, but is just written to insert spaces into C D. It works until it hits the first number in C that's not in A - it keeps pushing C D down looking for a match. The script is in the 2nd response here: http://www.computing.net/answers/office/excel-match-sort-columns-with-sa/7350.html At that point, I need it to delete any line that isn't in both sides. So, in the example above it would delete numbers 2, 4, 5, and 6. This would leave me with lines 1 3, and I can move the descriptions easily from B to D. I'm not sure if I'm explaining this all properly, hopefully it will make sense to someone on here. Please let me know if you need more information or a trimmed down version of the spreadsheet to help out. I really appreciate any time that any of you are willing to take with this. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---