$$Excel-Macros$$ Sending Cell Values to another open Windows program
Hi I want to send, using a command button, 4 separate cell values as a string (numerical only) from Excel 2000 (open) to another open program in Windows7 (in this case an Arduino micro controller program) but could be any other open program on the Window OS. Code will include the open file address. Just need some advice or reference to material online (have looked without success) for the vba to get the string together and the code to get into the other program. Thankyou Charles Harris -- 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$$ Excel VBA - Alex Cantu contact
Hi ou Anyone have a contact for Alex Cantu re his 'smiley face' vba on Youtube Charles -- 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$$ Sum Formula allowing for sub-totals
Hi XL2000 Have searched for this with no luck. Have a column with figures entered by user and also some sub-totals as a result of formula. How do I have a formula to add all the entered figures only, excluding the sub totals. Maybe sumif with is formula ? Thanks CharlesHarris -- 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: Sum Formula allowing for sub-totals
Hi Mandeep Sheet attached.I want to check that the total of entries only adds up to grand total. A double check to make sure everything in. Say total of E11:E220 Thanks Charles On Monday, May 18, 2015 at 7:05:40 PM UTC+12, Mandeep Baluja wrote: Can we have the sheet ??? On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote: Hi XL2000 Have searched for this with no luck. Have a column with figures entered by user and also some sub-totals as a result of formula. How do I have a formula to add all the entered figures only, excluding the sub totals. Maybe sumif with is formula ? Thanks CharlesHarris -- 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. Sample1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Date not Correct, List of Tabs, Hide Exit X
Hi Excel 2000 Three small questions as to these small codes not working. Want to make a new sheet and list all sheets with hyperlink to each sheet. Code curteosy of member of this group. (slips my mind at the moment apologies) Sub MakeHyperlinkIndex() Dim ndx As Worksheet, X As Integer Set ndx = Sheets.Add(before:=Sheets(1)) ndx.Name = Index ndx.Cells(1) = Worksheets For X = 2 To Worksheets.Count ndx.Hyperlinks.Add Anchor:=ndx.Cells(X, 1), Address:=_ SubAddress:=' Worksheets(X).Name '!A1,_ TextToDisplay:=Worksheets(X).Name Next X End Sub Gets to thendx.HyperLinks.Add ** With this I am trying to hide the exit cross button. Not sure if I have the 'select' correct. Private Sub UserForm_Initialize() Dim UserForm As Integer Dim HideCloseButton As Integer UserForm(RegArea).Select HideCloseButton Me End With End Sub This is working ok with the vba but the date that shows in the formatted date column is 00Jan00!. The clock in Windows 7 shows correct time. Is there anything in XL that I need to check? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 And Target.Offset(0, -1).Value = Then Target.Offset(0, -1) = Format(Now(), DD:MM:YY) End If End Sub * Thankyou Charles Harris -- 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$$ Excel2000 - Using color in Activex Scroll Bar added to sheet
Hi Is there any add-in for a different scroll bar to add within a sheet? I would like to be able to change colors in 3 places. The 2 arrows, the thumb, and the background. And also even use graphics jpg as background. Excel2000 seems a bit limited to blacks and greys. Thanks Charles Harris -- 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$$ Excel w/VBA on Android w/Bluetooth !!
Hi For a hobby project controlling speed of model train, using Excel. Others around but not using Excel. Want to use a Android phone/tablet with Excel including VBA to send data via the bluetooth to a Arduino. Arduino and Excel programming ok, just want to be able to use via Excel the bluetooth option. There are some Excel on phones etc, but non allow VBA. Question is :is Excel available with VBA on Android ? Thankyou Charles Harris -- 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: VBA Intersect Range...
Hi Vabz Thanksfor good work in sorting for me. Charles On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: VBA Intersect Range...
Hi Vabz Thanks for the WB it works great. However when I incorporate code into my project VE comes up with error , see below, at the word 'range' . My code is: Option Explicit Private Sub CommandButton1_Click() Dim ctl As Control Dim Range As Integer With Worksheets(RegionalAreas).Range(h8) YourValue = Range(H65536).End(xlUp).Value + 1' 'Expects Array' at word Range 'Message = MsgBox(Last Value is: YourValue) .Offset(RowCount, 0).Value = Me.RegAreaEnter.Value End With End Sub ** Your comments and help much appreciated. Thankyou Charles On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: VBA - Cell with comma separated serial numbers - send list to individual cells
Hi Vabz and all Works very well. Great work. Thankyou Charles On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote: HI Have cells that have had serial numbers entered (up to 50 serial numbers) each separated by a comma. Is there a VBA argument that can take the cell and transfer each serial number to its own cell. Part of a larger VBA project. VBA rather than function wanted. e.g. 45,55,56,57,58,60,71,72,73,74,80,90,91,92,93,94,95,96,97,98,99,100,101, Thanks CharlesHarris -- 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: VBA Intersect Range...
Hi Vabz Thanks for that. Tried that but get 'Compile error, Expected Array' on the word 'range' in the new code. Have I got something wrong in the setup somewhere? There is not much there to go wrong! Is Option Explicit a ouproblem? Thankyou Charles On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: VBA Intersect Range...
Hi Ashish Thanks for your WB etc. My Excel2000 will not open. Are you able to post .xls version which I can download. Thankyou Charlie Harris On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: VBA - Cell with comma separated serial numbers - send list to individual cells
Hi Everyone I am in a different time zone and later to respond. In New Zealand, already Friday evening. Thankyou for your comments and workbooks. I am using Excel 2000 .xls and the WB for 'Charlies Column Split' and 'For Charlie'I had to convert to .xls using OfficeCalc. Iam away from the Excel machine again at the moment. When in 2000 they did open ok but no macros show up? Are you able to post an .xls version I can down load and put straight into Excel. Thanks The WB for Formula Split Value opened ok as no vba. Works very well. One question - it places the data across columns. Is there a formula that would list the values down rows in a single column? And can you explain the last part of the code that says-99 etc. What does this do? Thanks and regards enjoy the weekend. Charlie Harris On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote: HI Have cells that have had serial numbers entered (up to 50 serial numbers) each separated by a comma. Is there a VBA argument that can take the cell and transfer each serial number to its own cell. Part of a larger VBA project. VBA rather than function wanted. e.g. 45,55,56,57,58,60,71,72,73,74,80,90,91,92,93,94,95,96,97,98,99,100,101, Thanks CharlesHarris -- 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$$ VBA Intersect Range...
Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: VBA - Cell with comma separated serial numbers - send list to individual cells
Thanks for the function options. Look great but I would prefer to do with VBA 23,34,56,57,60... would become 23 34 56 57 60 etc Thanks Charles On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote: HI Have cells that have had serial numbers entered (up to 50 serial numbers) each separated by a comma. Is there a VBA argument that can take the cell and transfer each serial number to its own cell. Part of a larger VBA project. VBA rather than function wanted. e.g. 45,55,56,57,58,60,71,72,73,74,80,90,91,92,93,94,95,96,97,98,99,100,101, Thanks CharlesHarris -- 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: VBA Intersect Range...
Hi Have checked and this is all the code I had. What I want the code to do is to put the last number in a list in the text box on user form. Thanks for your help. Charles On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets(RegionalAreas).Select Intersect(Range(H:H),ActiveSheet.UsedRange Offset(RowCount,0).Value=Me.RegAreaEnter.Value End Sub Thanks Charles Harris -- 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: AssignMacro to Shape - for a Userform
Hi Guys Thanks for your replies. All sorted now. Charlie On Sunday, January 18, 2015 at 6:28:38 PM UTC+13, sswcharlie wrote: Hi Trying to get a macro assigned to open a userform. The macro does not show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the net) Sub... UserForm1.Show EndSub but userform still does not show. How do I get the userform1 etc to show in Macro Menu ? Thanks Charlie -- 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$$ AssignMacro to Shape - for a Userform
Hi Trying to get a macro assigned to open a userform. The macro does not show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the net) Sub... UserForm1.Show EndSub but userform still does not show. How do I get the userform1 etc to show in Macro Menu ? Thanks Charlie -- 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: VBA to Destination of Value only
Hi Ashish Thanks for code. Still not working. Has message to say 'application defined or object defined error'. Using XL2000 Note that my code without the .value works fine and copies across except it has the error messages. Just need to addthe value only. Thnaks Charlie On Sunday, December 30, 2012 8:45:51 PM UTC+13, sswcharlie wrote: Hi I want to copy the values only to another sheet. Without .value on the end it copies thru with error messages. If I put . value on the end it comes up with message 'copy method of range class failed'. Do not want to use copy/paste special method. Want to use 'Destination as shown. Sheets(DailyList).Range(ItemsList).Copy Destination:=Sheets(ItemsListArchives).Range(D Rows.Count).End(xlUp).Offset(7).value Found other code on the net that just used the .value but one above it does not work. Do I have to make a small change ? or does the .value go in a different position ? Thanks Charlie Harris -- 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.
Re: $$Excel-Macros$$ Multiple sorts on one Sheet
Hi Guys Wow, they work like magic. Thanks Ashish and Rajan. Some more new knowlege for me. Great work and thanks Charlie Harris On Aug 26, 5:58 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Try this: Sub SortList() On Error Resume Next Dim Record As Integer Record = ActiveSheet.UsedRange.Rows.Count For i = 1 To Record If Range(D i).Value = HD Then Range(D i + 1).Select ActiveCell.Resize(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column).Sort Range(F i) End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Friday, August 26, 2011 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multiple sorts on one Sheet Hi On attached workbook there is a sheet tha has multiple lists with empty rows in between. No of empty rows can vary. What I am trying to do is sort each list on the list into say into col F ascending order. Once the first list sorted vba takes it onto the next list, until all lists have been sorted. The empty rows still remain. Each list is always started with a heading row which with a ' HD' ref in the same row D. Is this the best reference for finding each list. In plain English go to first entry of HD xldown to last entry in that list data sort by col F next list Your help would be appreciated. Thanks Charlie Harris -- ---- -- 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$$ Attachments to Group
Hi I want to post a message with .xls file attached. Where is the button to add attachments to email ? Thanks Charlie -- -- 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$$ VBA Copy Comments Box (with photo)
Hi Files attached. Shipments is were the vlookup is and Database is where the comments box are. Oops, cannot find the place on the webpage here to attach the sheets. Let me know how to. Thankyou Charlie On Jul 1, 1:46 am, ICWAI Help icwai.answ...@gmail.com wrote: Please attached the sheet. so we can help you better On Thu, Jun 30, 2011 at 6:29 AM, sswcharlie swch...@gmail.com wrote: Hi Have a photo in a comments box in wb 2. Also have a vlookup in another workbook WB1 to bring forward the text from the cell into WB2. This works great. I also want to bring forward the comment box in the same cell from WB2 into WB1. Would like to use vlookup function but I believe not possible. With vba event, do I use a copy/paste special macro, or is there a better method. Thanks Charlie -- ------ 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- Hide quoted text - - Show quoted text - -- -- 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$$ VBA Copy Comments Box (with photo)
Hi Have a photo in a comments box in wb 2. Also have a vlookup in another workbook WB1 to bring forward the text from the cell into WB2. This works great. I also want to bring forward the comment box in the same cell from WB2 into WB1. Would like to use vlookup function but I believe not possible. With vba event, do I use a copy/paste special macro, or is there a better method. Thanks Charlie -- -- 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$$ Hyperlink for Sheet in a Cell - changes
Hi Is it possible to have say a cell with hyperlink to sheet (that is ok) but also if the name in that cell changes it stays as a hyperlink to a another sheet. eg if A1 has 'Sheet2' hyperlinked, and then A1 changes to 'sheet3' will the hyperlink change to sheet 3 ? Thanks Charlie -- -- 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$$ Find value in Active Cell in another sheet(s) delete
Hi Part of a another code - I want to find the value(text) in active cell (value changes often) in workbook (except current WS and one other worksheet 'home) and delete. Could be more than one instance. Thanks Charlie -- -- 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$$ Find value in Active Cell in another sheet(s) delete
Hi Guys Thanks for that - magic. I understand now how it works. Thanks Charlie On Jun 5, 12:04 pm, STDEV(i) setiyowati.d...@gmail.com wrote: Dear GoldenLance, Thank you very much for your great sugestion.. user just *selects/activates a cell* where the criteria is written, and run the macro... kindest regards, STDEV(i) On Sat, Jun 4, 2011 at 5:57 PM, GoldenLance samde...@gmail.com wrote: Just a minor tweak to STDEV(i)'s code. Based on the original subject, I might change *sCriteria* = MyCriteriaText to sCriteria = * ActiveCell.Value* On Jun 4, 2:24 pm, STDEV(i) setiyowati.d...@gmail.com wrote: please check and try this VBA code if it helps Sub DoSomething() * ' siti Vi* Dim w As Worksheet, xCel As Range Dim sCriteria As String sCriteria = MyCriteriaText ' please edit For Each w In Worksheets If Not w.Name = ActiveSheet.Name Then If Not LCase(w.Name) = home Then For Each xCel In w.UsedRange If xCel.Value = sCriteria Then xCel.Clear Next xCel End If End If Next w End Sub On Sat, Jun 4, 2011 at 11:47 AM, sswcharlie swch...@gmail.com wrote: Hi Part of a another code - I want to find the value(text) in active cell (value changes often) in workbook (except current WS and one other worksheet 'home) and delete. Could be more than one instance. Thanks Charlie- Hide quoted text - - Show quoted text - -- -- 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