$$Excel-Macros$$ Enable Selection to Unlocked Cells only
Hi All Not sending this tip in the best tip for the week format as this is not my original idea but nevertheless a useful tip In a protected worksheet, a user may want to navigate only to those cells which are unlocked. i.e., Navigation should not be allowed to those cells which have formula (for example). Navigation should be allowed only to cells where a user can input data. To do this: To make cells unselectable, change the worksheet's EnableSelection property. Select *View, Toolbars, Control Toolbox* to display the Control Toolbox toolbar. Click the Properties button to display the Properties box for the worksheet, then click the cell labeled xlNoRestrictions and use the drop-down list to change the EnableSelection property to * xlUnlockedCells.*Close the Properties box. As long as the worksheet is protected, users cannot select the locked cells on the worksheet. Be sure to close the *Control Toolbox *toolbar once u are done. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Enable Selection to Unlocked Cells only
Hello Ashish, Can you help me to do the same in office 2007. new to 2007 hence need help. Thanks and Regards Atul Kesaria On Tue, Jul 7, 2009 at 11:45 AM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hi All Not sending this tip in the best tip for the week format as this is not my original idea but nevertheless a useful tip In a protected worksheet, a user may want to navigate only to those cells which are unlocked. i.e., Navigation should not be allowed to those cells which have formula (for example). Navigation should be allowed only to cells where a user can input data. To do this: To make cells unselectable, change the worksheet's EnableSelection property. Select *View, Toolbars, Control Toolbox* to display the Control Toolbox toolbar. Click the Properties button to display the Properties box for the worksheet, then click the cell labeled xlNoRestrictions and use the drop-down list to change the EnableSelection property to * xlUnlockedCells.* Close the Properties box. As long as the worksheet is protected, users cannot select the locked cells on the worksheet. Be sure to close the *Control Toolbox *toolbar once u are done. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Daniel -- calendar pop-up
error -- missing MS calendar control 8.0 pls help Thanks On Jul 7, 3:45 am, y2 kx ytw...@gmail.com wrote: Hello Mr.CA Narendra Ashara, Try this link very simple.. http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in*Calender **is available in all workBooks.* On Mon, Jul 6, 2009 at 9:59 PM, CA NARENDRA ASHARA aca.naren...@gmail.comwrote: HI Daniel, Excel file with date function attached by you is really nice. How do I make it available to every excel file i.e. I want to use it in all workbook. Kindly guide me. Thanks in advance. Thanks Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Daniel Sent: 05 July, 2009 9:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: calendar pop-up Look at the attached file. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Lynn Envoyé : dimanche 5 juillet 2009 17:56 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: calendar pop-up I don't understand what you are trying to tell me. I don't the command Date ? either. Could you further explain? On Jul 4, 10:21 pm, Daniel dcolarde...@free.fr wrote: Did you have a look at my workbook. The command Date ? is added to the cell right click menu when the file is opened. It is removed when the file closes. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Lynn Envoyé : samedi 4 juillet 2009 14:25 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: calendar pop-up this is not what I wanted. I do not want the calendar to be shown on the excel sheet. It should only pop-up when I click on the cell which I need to enter a date. Pls review this. thanks On Jul 4, 2:52 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Lynn, Calender control has been explained in the attached workbook. Note:- Date will be inserted in the selected cell, which can be modified. check up the code and you will understand the logic, It is quite simple. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Jul 3, 2009 at 9:35 PM, Lynn moley_c...@yahoo.com.au wrote: How can I have a calendar pop-up box for me to make date selection when I click on a cell? Using Calender Control in Excel.xls 31KViewDownload- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ macro to delete all labels
hi, anyone has a macro to delete all labels in a spreadsheet? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Macro : Copy info from one range to another wsheet IF...
Hello. Try : Sub test() Dim myRow As Long, myRange As Range myRow = [Sheet2!A65000].End(xlUp).Row + 1 Sheets(Sheet1).Select AutoFilterMode = False With Range(A1:D [B65000].End(xlUp).Row) .AutoFilter .AutoFilter Field:=1, Criteria1:=X Set myRange = [_filterdatabase].Offset(1, 1) Set myRange = myRange.Resize(myRange.Rows.Count - 1, _ myRange.Columns.Count - 1) myRange.Copy Sheets(sheet2).Cells(myRow, 2) End With End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Souriane Envoyé : lundi 6 juillet 2009 19:05 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Excel Macro : Copy info from one range to another wsheet IF... Thank you Nishant Jain I will reask the question in a more simple way because the code does nothing to my document and I have no idea why. So here is what I want to do: I have 2 sheets : Sheet1 (where the data come from) Sheet2 (where I want the data to be copied) In Sheet1, I have 4 columns A: X or N/A B : Code C : Date D: N. of hours In Sheet2, I have 3 column A: Name B: Code C: Date D: N. of hours. I want the macro to do the following: In sheet1, copy the line from B to D (not the other columns) ONLY if there is an X in column A Paste it in Sheet2 at the last unoccupied line of the table. Paste Sheet1 columns BCD to Sheet2 columns BCD. (The date for column A will come from another sheet.) Tahnk you so much for your help! Souriane On 17 juin, 01:05, Nishant Jain nishantjai...@gmail.com wrote: try this Sub Copy() Dim i As Integer Dim j As Integer 'find the next available cell to paste the data j = 2 Do While ThisWorkbook.Sheets(2).Range(B j) j = j + 1 Loop 'check whether the next cell is X and if yes then paste the value in next sheet i = 2 Do While ThisWorkbook.Sheets(1).Range(A i) If ThisWorkbook.Sheets(1).Range(Q i) = X Then ThisWorkbook.Sheets(2).Range(R j) = ThisWorkbook.Sheets (1).Range(A i) ThisWorkbook.Sheets(2).Range(S j) = ThisWorkbook.Sheets (1).Range(B i) j = j + 1 End If i = i + 1 Loop End Sub On Jun 16, 10:38 pm,Sourianejsouri...@videotron.ca wrote: Hi! I need help with the an Excel macro. On my worksheet, I have a monthly calendar where we can enter someone's working time. Beside it, starting on cell Q4, I have a 4 columns table that takes the information from the calendar and make it ready to be transfer to another worksheet where we will be able to play with the number. I want the macro to take the info in the table and transfer it in my second worksheet as follow: 1. Check in column Q if there is an X or a N/A 2. If N/A, then nothing. (if empty also!) 3. if X then the following: 4. copy info in column R 5. paste it in worksheet B, at the end of the existing table (that range from column A to D), in column B 6. copy info in column in column S 7. paste *THE VALUE ONLY* in worksheet B in column C and the rest, I think I will be able to do it. This macro will teach me how to do other similar one because it covers something that I often wish to do but can't yet. Thank you for your help! Souriane- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: V look up error 1004
Hello. The following code works : Private Sub ComboBox1_Change() Result = Application.VLookup(CDbl([Sheet1].ComboBox1.Value), _ [Sheet1!Q1:W100], 6, 0) End Sub HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Balachander S Envoyé : lundi 6 juillet 2009 19:22 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ V look up error 1004 Attn Dave Daniel Please find the sample file and the requirement --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 27 goes to ****Aindril De (Andy)****
Thanks Ayush, You are right! Indeed with this Tip of the week competition, I have learnt a lot. Congratulations to all who are participating and sharing their knowledge with everyone.. This award goes to all Thanks everyone and keep sharing Thats how we can increase our knowledge. Regards, Aindril (Andy) On Mon, Jul 6, 2009 at 10:41 PM, Ayush jainayus...@gmail.com wrote: Hello Everyone, Please congratulate Aindril De (Andy) for winning the Best Excel Tip award of Week # 27. It was really very useful trick to create a validation list from the data in other sheet. Most of us might not knowing this tip. (Atleast I didn't know this) All the tips submitted in week # 27 was excellent and it was difficult for me to decide the winner. The tips by Bakul Patel, Upendra Singh and Narendra Ashara is also very useful and quite different. I am personally learning a lot from the tips and thankful to all of you for participating here. THANK YOU SO MUCH. MANY MANY CONGRATULATIONS ANDY!! KEEP IT UP ! You are now nominated for monthly award and your name is published on home page of this group. CHEERS !!! The Winner of the JUNE MONTH will be declared soon. Keep watching this space The contest of week # 28 has already begin and you can submit your tip in the thread mentioned below: http://groups.google.com/group/excel-macros/browse_thread/thread/c1abf04a7349f3c1# Please participate and win wonderful prizes. KEEP POSTING Thanks and best regards, Ayush Jain --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Check Box macro
Hi Group, I have a very simple request. I have an excel spreadsheet setup as a check list for a very complicated audit process. I am using MS Excel 2003 and using the Check Box on this check list. What I want to do is when a person clicks on a check box on this worksheet I want Excel to popup a message saying Please Fill the Related Entities Spreadsheet, thanks that it. I was thinking of a macro that could do this. thanks in advance, Dave --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: KILL command in VBA
Unfortunately, you can't. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de pradip Envoyé : mardi 7 juillet 2009 17:15 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ KILL command in VBA please let me know how to retrieve files deleted by KILL command --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Check Box macro
Hi Dave, You have more than a way to achieve this. It depends how many checkboxes you have. If you have few, associate the same code with each checkbox : Private Sub CheckBox1_Click() If [AL1] = True Then MsgBox Please Fill the related Entities Spreadsheet, thanks End If End Sub (AL1 being the associated cell). If you have many, first, associate the cells from a given column to the checkboxes. You may want to hide this column in order to prevent users from entering data in it. Then, in the sheet module, paste the following code : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Or Target.Column 1 Then Exit Sub If Target.Value = True Then MsgBox Please Fill the related Entities Spreadsheet, thanks End If End Sub If you do have a great amount of it, it may be possible to use class module in order to avoid too many changes. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Dave Envoyé : mardi 7 juillet 2009 17:23 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ Check Box macro Hi Group, I have a very simple request. I have an excel spreadsheet setup as a check list for a very complicated audit process. I am using MS Excel 2003 and using the Check Box on this check list. What I want to do is when a person clicks on a check box on this worksheet I want Excel to popup a message saying Please Fill the Related Entities Spreadsheet, thanks that it. I was thinking of a macro that could do this. thanks in advance, Dave --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Outlook urgent
Daniel, If we create draft with out attachment then its working, but not working with attached. Please can you check. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Monday, July 06, 2009 6:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hello. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .BodyFormat = olFormatPlain .display ' to be deleted .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : lundi 6 juillet 2009 07:27 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent Daniel, It working but i want draft format should be in plain text or HTML. now it is in Rich text. Please can u help on this. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Saturday, July 04, 2009 8:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .display .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : samedi 4 juillet 2009 14:55 À : excel-macros@googlegroups.com Cc : bal...@gmail.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent Importance : Haute Dear Friends, I requeired i coding to create a draft with attachement and also the draft format should be in plain text. Find attached draft for your reference. Thanks Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: KILL command in VBA
You can try using the file undelete utility which restore the file from fat table. Regards, Sarfaraz Ahmed MS Excel help http://findsarfaraz.blogspot.com On Tue, Jul 7, 2009 at 9:02 PM, Daniel dcolarde...@free.fr wrote: Unfortunately, you can't. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de pradip Envoyé : mardi 7 juillet 2009 17:15 À : MS EXCEL AND VBA MACROS Objet : [Norton AntiSpam] $$Excel-Macros$$ KILL command in VBA please let me know how to retrieve files deleted by KILL command -- Thanks with regards, Sarfaraz Ahmed a target=_blank href=http://feeds2.feedburner.com/~r/blogspot/rtws/~6/6;img src=http://feeds2.feedburner.com/blogspot/rtws.6.gif; alt=Free MS Excel help style=border:0/a --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: V look up error 1004
Thanks Daniel it works Thanks Dave too S baloo On Tue, Jul 7, 2009 at 7:36 PM, Daniel dcolarde...@free.fr wrote: Hello. The following code works : Private Sub ComboBox1_Change() Result = Application.VLookup(CDbl([Sheet1].ComboBox1.Value), _ [Sheet1!Q1:W100], 6, 0) End Sub HTH Daniel *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] *De la part de* Balachander S *Envoyé :* lundi 6 juillet 2009 19:22 *À :* excel-macros@googlegroups.com *Objet :* [Norton AntiSpam] $$Excel-Macros$$ V look up error 1004 Attn Dave Daniel Please find the sample file and the requirement --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---