$$Excel-Macros$$ User form problem showing up Calendar
I am getting error on this "cannot find object or library" :- Any speedy way to resolve it !!! How do i place the calendar ?? All names have been modified ,take note. -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. bookings.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
Hi Vabs, This doesnt do the same thing as http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ The beauty of the method in the above linked is that it does not matter if the string you have started typing is part of the second, first, or any word, it will find that string. So, if i have a list with the following Apples Oranges Aardvarks Ants Leopards Pebbles And i then start typing the string LE the above linked will return: appLEs, LEopards, pebbLEs whereas your method will only return LEopards. For my own searches this is important as i am using it to look up a list of wine makers, which some people often enter different (i.e. Domaine Paul Isgreat, Dom. Paul Isgreat, Paul Isgreat, Domaine Isgreat) so the safest bet is to type ISGREAT and then see what pops up in the combobox. I wish there was a way to get the linked combobox into an excel form though... It only seems to accept non-ActiveX controls? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
Hi Paul J Irwin, Solution given is based on then requirement... Yes you can have search box in forms too Check this attachment... Cheers!! On Sun, Feb 8, 2015 at 7:21 PM, Paul I paul.j.ir...@gmail.com wrote: Hi Vabs, This doesnt do the same thing as http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ The beauty of the method in the above linked is that it does not matter if the string you have started typing is part of the second, first, or any word, it will find that string. So, if i have a list with the following Apples Oranges Aardvarks Ants Leopards Pebbles And i then start typing the string LE the above linked will return: appLEs, LEopards, pebbLEs whereas your method will only return LEopards. For my own searches this is important as i am using it to look up a list of wine makers, which some people often enter different (i.e. Domaine Paul Isgreat, Dom. Paul Isgreat, Paul Isgreat, Domaine Isgreat) so the safest bet is to type ISGREAT and then see what pops up in the combobox. I wish there was a way to get the linked combobox into an excel form though... It only seems to accept non-ActiveX controls? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Dynamic Search Box.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
Happy to help :) On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Abhishek Jee, It is really a very very helpful for me. Thanks a ton! Regards Pravin Gunjal. -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Tue, May 27, 2014 at 4:13 PM Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few Automations To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com, Pravin Gunjal isk1...@gmail.com If it doesn't necessarily have to be an userform, you can try the attached. Let me know if you need anything further in this. Regards, Abhishek On Tue, May 27, 2014 at 3:56 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends, Greetings! I have an excel file in which I need to have an user form which contains the following data: *Heading* *Data Entry* *Product Name* By typing any short letter then match value should displayed there in list from sheet: Products *Code* It must come automatically from sheet: Products, based on the above selection *Quantity* Manual Entry *Batch* Manual Entry *Reference* Manual Entry The entered data as per the above method would picked up in second sheet (GRRN Entry) from column A4 to E4 and so on.. The file is attached fore reference. Please help. Regards Pravin Gunjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http
Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
Abhishek Sir, Again you proved that you are Master..! Regards, Prafull Jadhav 9920553518 On 27 May 2014 16:21, Abhishek Jain abhishek@gmail.com wrote: Happy to help :) On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Abhishek Jee, It is really a very very helpful for me. Thanks a ton! Regards Pravin Gunjal. -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Tue, May 27, 2014 at 4:13 PM Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few Automations To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com, Pravin Gunjal isk1...@gmail.com If it doesn't necessarily have to be an userform, you can try the attached. Let me know if you need anything further in this. Regards, Abhishek On Tue, May 27, 2014 at 3:56 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends, Greetings! I have an excel file in which I need to have an user form which contains the following data: *Heading* *Data Entry* *Product Name* By typing any short letter then match value should displayed there in list from sheet: Products *Code* It must come automatically from sheet: Products, based on the above selection *Quantity* Manual Entry *Batch* Manual Entry *Reference* Manual Entry The entered data as per the above method would picked up in second sheet (GRRN Entry) from column A4 to E4 and so on.. The file is attached fore reference. Please help. Regards Pravin Gunjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop
$$Excel-Macros$$ User form Find code to ignore if text box is blank
Hello, I have code that looks to modify a cell when there is a value placed in a user form. My issue is that there are multiple text boxes in the user form and I only want the user form to update the cell if there is a value, but ignore a text box if there is no value. Currently, it will update the cell with value but also update if there is no value by blanking out the cell. I would like the program to change the cell if there is a value in text box, but if text box blank then leave original value intact. Thank you in advance. Sub ALTaxType() 'Alabama Dim wbData As Workbook, ws1 As Worksheet, lngLastRow As Long, r As Long, ans As Variant Set wbData = ThisWorkbook Set ws1 = wbData.Sheets(Sheet1) With ws1 lngLastRow = .Cells.Find(what:=*, After:=.Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row For r = lngLastRow To 2 Step -1 ' Assumes row 1 contains col headers If .Cells(r, A) = Alabama Then ' Populates column G with textboxvalue .Cells(r, G) = frmTx.txtboxAL.Value ' .Rows(r).Delete ' If you want to delete row End If Next r End With End Sub -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ User form Find code to ignore if text box is blank
Hello, It would be helpful if you could attach the excel sheet also... Regards, Pavithra On Mon, Apr 15, 2013 at 7:48 PM, Thomas Yantorno salestaxconsult...@gmail.com wrote: Hello, I have code that looks to modify a cell when there is a value placed in a user form. My issue is that there are multiple text boxes in the user form and I only want the user form to update the cell if there is a value, but ignore a text box if there is no value. Currently, it will update the cell with value but also update if there is no value by blanking out the cell. I would like the program to change the cell if there is a value in text box, but if text box blank then leave original value intact. Thank you in advance. Sub ALTaxType() 'Alabama Dim wbData As Workbook, ws1 As Worksheet, lngLastRow As Long, r As Long, ans As Variant Set wbData = ThisWorkbook Set ws1 = wbData.Sheets(Sheet1) With ws1 lngLastRow = .Cells.Find(what:=*, After:=.Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row For r = lngLastRow To 2 Step -1 ' Assumes row 1 contains col headers If .Cells(r, A) = Alabama Then ' Populates column G with textboxvalue .Cells(r, G) = frmTx.txtboxAL.Value ' .Rows(r).Delete ' If you want to delete row End If Next r End With End Sub -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ User form Query box
hi Ashish, Pl provide the solution, if you can. On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com wrote: Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be done by query excel forms/input box. Regards, Prabhat Shrivastava On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote: can you share the sample file On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com prabhat.sh...@gmail.com wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ User form Query box
Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be done by query excel forms/input box. Regards, Prabhat Shrivastava On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote: can you share the sample file On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com javascript: prabhat.sh...@gmail.com javascript: wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ User form Query box
This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ User form Query box
can you share the sample file On Sun, Oct 7, 2012 at 11:03 AM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ User Form
Good Job Noorain Ansari !!! Chilexcel 2012/5/24 NOORAIN ANSARI noorain.ans...@gmail.com: Dear Deba, Please see attached Userform, hope it will help you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan drdeva...@gmail.com wrote: Dear Experts, Again i have some concern in user form. Please find the attachment, i have clearly explain in it. Please... Regards Debaranjan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ User Form
Thanks Chilexcel On Thu, May 24, 2012 at 10:23 PM, ChilExcel chilexcel...@gmail.com wrote: Good Job Noorain Ansari !!! Chilexcel 2012/5/24 NOORAIN ANSARI noorain.ans...@gmail.com: Dear Deba, Please see attached Userform, hope it will help you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan drdeva...@gmail.com wrote: Dear Experts, Again i have some concern in user form. Please find the attachment, i have clearly explain in it. Please... Regards Debaranjan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ User Form - Help
Hi Team, I need your help in creating a user form. Here is what I'm looking for. I have some brands in Range(B1:B5) in Sheet1 and are in the order as below Brand1 Brand2 Brand3 Brand4 Brand5 and some brands are present in sheet2 in the order different than sheet1 like Brand5 B3 Brd2 Brand_4 Brnd1 Now I would like these two to appear in a user form side by side like Brand1 Brand5 Brand2 B3 Brand3 Brd2 Brand4 Brand_4 Brand5 Brnd1 Later I would like to use mouse for re-arranging the brands at second column i.e. like dragging and dropping, so that the output looks like Brand1Brnd1 Brand2Brd2 Brand3B3 Brand4Brand_4 Brand5Brand5 I hope this is possible, please help me with this. Thank you in advance. Best regards, Amar -- 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$$ User form
Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- 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 New Microsoft Office Excel Worksheet (2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ User form
Hi Prasad, Look attached below... If you want to create some VBA Coding in background of userforms..You have to save the file has a .XLS or XLSM because XLSX wont support Macro Language.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Auto_Open.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ User form
What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub From: Suryaprasad Sent: Tuesday, August 30, 2011 7:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.com wrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- 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
Fwd: $$Excel-Macros$$ User form
Hi Surya, Your excel sheet is empty..Please check..and resend it back...and please Elaborate more about your query. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- *Best Regards,* *Venkat * *Chennai* * * * * -- -- 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$$ User form
Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel User.xlsm Description: Binary data
Re: $$Excel-Macros$$ User form
Dear surya, Please see attached sheet.. On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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
Re: $$Excel-Macros$$ User form
Hi Surya, Try the Below... *Private Sub Workbook_Open()* *UserForm1.show* *End Sub* *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just
$$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.
Hi all, Need Help... I have a user form in which i have 6 check boxes. ok and cancel button. when ever I click 1st check box, rows 1 to 10 should to be editable, rest all rows should be non editable and hidden. For check box 2, rows 11 to 20 editable, rest up and down area should be non editable and hidden. And vice versa for other check boxes. I need a macro for this. Attached is the excel sheet with user form created in background. Thanks in advance, Rsh -- -- 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 test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.
Dim ws As Worksheet Const pass As String = rash Dim ArChkBox(1 To 6) As Object Private Sub UserForm_Activate() Set ArChkBox(1) = CheckBox1 Set ArChkBox(2) = CheckBox2 Set ArChkBox(3) = CheckBox3 Set ArChkBox(4) = CheckBox4 Set ArChkBox(5) = CheckBox5 Set ArChkBox(6) = CheckBox6 End Sub Private Sub Locked_Unlocked(Rowval As Long) Dim r As Long r = Rowval * 10 - 9 Sheet1.Unprotect pass Sheet1.Cells.Locked = True If ArChkBox(Rowval) Then Cells(r, 1).Resize(10, 1).EntireRow.Locked = False Else Cells(r, 1).Resize(10, 1).EntireRow.Locked = True End If Sheet1.Protect pass If Rowval 1 Then ActiveWindow.ScrollRow = r - 2 Else: ActiveWindow.ScrollRow = r Cells(r, 1).Resize(10, 1).EntireRow.Select End Sub Private Sub CheckBox1_Click() Call Locked_Unlocked(1) End Sub Private Sub CheckBox2_Click() Call Locked_Unlocked(2) End Sub Private Sub CheckBox3_Click() Call Locked_Unlocked(3) End Sub Private Sub CheckBox4_Click() Call Locked_Unlocked(4) End Sub Private Sub CheckBox5_Click() Call Locked_Unlocked(5) End Sub Private Sub CheckBox6_Click() Call Locked_Unlocked(6) End Sub On Wed, Jun 29, 2011 at 1:53 PM, Rash rashmiv.ni...@gmail.com wrote: Hi all, Need Help... I have a user form in which i have 6 check boxes. ok and cancel button. when ever I click 1st check box, rows 1 to 10 should to be editable, rest all rows should be non editable and hidden. For check box 2, rows 11 to 20 editable, rest up and down area should be non editable and hidden. And vice versa for other check boxes. I need a macro for this. Attached is the excel sheet with user form created in background. Thanks in advance, Rsh -- -- 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 ctv_Test_Cells_Locking_Unlocking.xlsm Description: Binary data
Re: $$Excel-Macros$$ User form value in current active row
Hi Paul, Thanks aton It's working perfect And I done it for userform2... :) Learned alot Thanks once again for your continuous help/guidance :) :) :) Regds, Manish On Feb 7, 10:16�pm, Paul Schreiner schreiner_p...@att.net wrote: Manish, I'm sorry... I've been away from my computer(s) for a few days. I'll try to take a look today. I thought I sent it, but don't see it, so I'll have to re-create it. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, February 7, 2011 10:34:59 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Any help pls. - Manish On Feb 7, 12:12 pm, Manish pansari.man...@gmail.com wrote: Dear Paul EE, I want to write the value of userform in same PRA worksheet in column T:AA in same row. For example: if user enter the value is in PRA Sheet column M8, userform will write the value in cell T8:AA8, same as if user enter the value in PRA Sheet column M11, I want to write the userform value in cell T11:AA11. Further if user change the previous entered value, I want to show the same row value in userform textboxes like if user change the value in cell M8, I want the user form open with the value already I have in cell T8:AA8 and by clicking the OK button will replace the value in cell T8:AA8. I hope my query/imagination is clear. Mr. Paul suggested me the following changes, but I don't know the way to incorporate the same in my excel file. Try this: Declare a variable: Public CellRange As Range In the Change Event, set CellRange = to the cell that was changed: Set CellRange = Target This will make it available to the userform buttons. Next.. Create a Userform Initialize macro: Private Sub UserForm_Initialize() UserForm1.TextBox1 = Cells(CellRange.Row, T).Value UserForm1.TextBox2 = Cells(CellRange.Row, U).Value UserForm1.TextBox3 = Cells(CellRange.Row, V).Value UserForm1.TextBox4 = Cells(CellRange.Row, W).Value UserForm1.TextBox5 = Cells(CellRange.Row, X).Value UserForm1.TextBox6 = Cells(CellRange.Row, Y).Value UserForm1.TextBox7 = CellRange.Value UserForm1.TextBox16 = Cells(CellRange.Row, AA).Value End Sub In the OK button: Sheets(PRA).Cells(CellRange.Row, T) = TextBox1.Value Sheets(PRA).Cells(CellRange.Row, U) = TextBox2.Value Sheets(PRA).Cells(CellRange.Row, V) = TextBox3.Value Sheets(PRA).Cells(CellRange.Row, W) = TextBox4.Value Sheets(PRA).Cells(CellRange.Row, X) = TextBox5.Value Sheets(PRA).Cells(CellRange.Row, Y) = TextBox6.Value Sheets(PRA).Cells(CellRange.Row, Z) = TextBox7.Value Sheets(PRA).Cells(CellRange.Row, AA) = TextBox16.Value Can anyone please incorporate it in my excel file. I am mailing my file on excel-macros@googlegroups.com Regds, Manish Pansari On Feb 1, 7:26 pm, Manish pansari.man...@gmail.com wrote: Thank Paul, I don't have ops to attach file on group. Can I send you my file through mail on your personal mail id? - Manish On Jan 31, 7:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow I tried the code suggested by you. It s working Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development 600,000 records into an Oracle database ? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38 pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called
Re: $$Excel-Macros$$ User form value in current active row
Any help pls. - Manish On Feb 7, 12:12 pm, Manish pansari.man...@gmail.com wrote: Dear Paul EE, I want to write the value of userform in same PRA worksheet in column T:AA in same row. For example: if user enter the value is in PRA Sheet column M8, userform will write the value in cell T8:AA8, same as if user enter the value in PRA Sheet column M11, I want to write the userform value in cell T11:AA11. Further if user change the previous entered value, I want to show the same row value in userform textboxes like if user change the value in cell M8, I want the user form open with the value already I have in cell T8:AA8 and by clicking the OK button will replace the value in cell T8:AA8. I hope my query/imagination is clear. Mr. Paul suggested me the following changes, but I don't know the way to incorporate the same in my excel file. Try this: Declare a variable: Public CellRange As Range In the Change Event, set CellRange = to the cell that was changed: Set CellRange = Target This will make it available to the userform buttons. Next.. Create a Userform Initialize macro: Private Sub UserForm_Initialize() UserForm1.TextBox1 = Cells(CellRange.Row, T).Value UserForm1.TextBox2 = Cells(CellRange.Row, U).Value UserForm1.TextBox3 = Cells(CellRange.Row, V).Value UserForm1.TextBox4 = Cells(CellRange.Row, W).Value UserForm1.TextBox5 = Cells(CellRange.Row, X).Value UserForm1.TextBox6 = Cells(CellRange.Row, Y).Value UserForm1.TextBox7 = CellRange.Value UserForm1.TextBox16 = Cells(CellRange.Row, AA).Value End Sub In the OK button: Sheets(PRA).Cells(CellRange.Row, T) = TextBox1.Value Sheets(PRA).Cells(CellRange.Row, U) = TextBox2.Value Sheets(PRA).Cells(CellRange.Row, V) = TextBox3.Value Sheets(PRA).Cells(CellRange.Row, W) = TextBox4.Value Sheets(PRA).Cells(CellRange.Row, X) = TextBox5.Value Sheets(PRA).Cells(CellRange.Row, Y) = TextBox6.Value Sheets(PRA).Cells(CellRange.Row, Z) = TextBox7.Value Sheets(PRA).Cells(CellRange.Row, AA) = TextBox16.Value Can anyone please incorporate it in my excel file. I am mailing my file on excel-macros@googlegroups.com Regds, Manish Pansari On Feb 1, 7:26 pm, Manish pansari.man...@gmail.com wrote: Thank Paul, I don't have ops to attach file on group. Can I send you my file through mail on your personal mail id? - Manish On Jan 31, 7:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow I tried the code suggested by you. It s working Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development 600,000 records into an Oracle database ? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38 pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save theRownumber by using: CurRow = Target.Row Of course, within youruserformmacros, you can use ActiveCell.Row Now, to launch youruserform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND
Re: $$Excel-Macros$$ User form value in current active row
Manish, I'm sorry... I've been away from my computer(s) for a few days. I'll try to take a look today. I thought I sent it, but don't see it, so I'll have to re-create it. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, February 7, 2011 10:34:59 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Any help pls. - Manish On Feb 7, 12:12 pm, Manish pansari.man...@gmail.com wrote: Dear Paul EE, I want to write the value of userform in same PRA worksheet in column T:AA in same row. For example: if user enter the value is in PRA Sheet column M8, userform will write the value in cell T8:AA8, same as if user enter the value in PRA Sheet column M11, I want to write the userform value in cell T11:AA11. Further if user change the previous entered value, I want to show the same row value in userform textboxes like if user change the value in cell M8, I want the user form open with the value already I have in cell T8:AA8 and by clicking the OK button will replace the value in cell T8:AA8. I hope my query/imagination is clear. Mr. Paul suggested me the following changes, but I don't know the way to incorporate the same in my excel file. Try this: Declare a variable: Public CellRange As Range In the Change Event, set CellRange = to the cell that was changed: Set CellRange = Target This will make it available to the userform buttons. Next.. Create a Userform Initialize macro: Private Sub UserForm_Initialize() UserForm1.TextBox1 = Cells(CellRange.Row, T).Value UserForm1.TextBox2 = Cells(CellRange.Row, U).Value UserForm1.TextBox3 = Cells(CellRange.Row, V).Value UserForm1.TextBox4 = Cells(CellRange.Row, W).Value UserForm1.TextBox5 = Cells(CellRange.Row, X).Value UserForm1.TextBox6 = Cells(CellRange.Row, Y).Value UserForm1.TextBox7 = CellRange.Value UserForm1.TextBox16 = Cells(CellRange.Row, AA).Value End Sub In the OK button: Sheets(PRA).Cells(CellRange.Row, T) = TextBox1.Value Sheets(PRA).Cells(CellRange.Row, U) = TextBox2.Value Sheets(PRA).Cells(CellRange.Row, V) = TextBox3.Value Sheets(PRA).Cells(CellRange.Row, W) = TextBox4.Value Sheets(PRA).Cells(CellRange.Row, X) = TextBox5.Value Sheets(PRA).Cells(CellRange.Row, Y) = TextBox6.Value Sheets(PRA).Cells(CellRange.Row, Z) = TextBox7.Value Sheets(PRA).Cells(CellRange.Row, AA) = TextBox16.Value Can anyone please incorporate it in my excel file. I am mailing my file on excel-macros@googlegroups.com Regds, Manish Pansari On Feb 1, 7:26 pm, Manish pansari.man...@gmail.com wrote: Thank Paul, I don't have ops to attach file on group. Can I send you my file through mail on your personal mail id? - Manish On Jan 31, 7:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow I tried the code suggested by you. It s working Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development 600,000 records into an Oracle database ? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38 pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save theRownumber by using: CurRow = Target.Row
Re: $$Excel-Macros$$ User form value in current active row
Dear Paul EE, I want to write the value of userform in same PRA worksheet in column T:AA in same row. For example: if user enter the value is in PRA Sheet column M8, userform will write the value in cell T8:AA8, same as if user enter the value in PRA Sheet column M11, I want to write the userform value in cell T11:AA11. Further if user change the previous entered value, I want to show the same row value in userform textboxes like if user change the value in cell M8, I want the user form open with the value already I have in cell T8:AA8 and by clicking the OK button will replace the value in cell T8:AA8. I hope my query/imagination is clear. Mr. Paul suggested me the following changes, but I don't know the way to incorporate the same in my excel file. Try this: Declare a variable: Public CellRange As Range In the Change Event, set CellRange = to the cell that was changed: Set CellRange = Target This will make it available to the userform buttons. Next.. Create a Userform Initialize macro: Private Sub UserForm_Initialize() UserForm1.TextBox1 = Cells(CellRange.Row, T).Value UserForm1.TextBox2 = Cells(CellRange.Row, U).Value UserForm1.TextBox3 = Cells(CellRange.Row, V).Value UserForm1.TextBox4 = Cells(CellRange.Row, W).Value UserForm1.TextBox5 = Cells(CellRange.Row, X).Value UserForm1.TextBox6 = Cells(CellRange.Row, Y).Value UserForm1.TextBox7 = CellRange.Value UserForm1.TextBox16 = Cells(CellRange.Row, AA).Value End Sub In the OK button: Sheets(PRA).Cells(CellRange.Row, T) = TextBox1.Value Sheets(PRA).Cells(CellRange.Row, U) = TextBox2.Value Sheets(PRA).Cells(CellRange.Row, V) = TextBox3.Value Sheets(PRA).Cells(CellRange.Row, W) = TextBox4.Value Sheets(PRA).Cells(CellRange.Row, X) = TextBox5.Value Sheets(PRA).Cells(CellRange.Row, Y) = TextBox6.Value Sheets(PRA).Cells(CellRange.Row, Z) = TextBox7.Value Sheets(PRA).Cells(CellRange.Row, AA) = TextBox16.Value Can anyone please incorporate it in my excel file. I am mailing my file on excel-macros@googlegroups.com Regds, Manish Pansari On Feb 1, 7:26 pm, Manish pansari.man...@gmail.com wrote: Thank Paul, I don't have ops to attach file on group. Can I send you my file through mail on your personal mail id? - Manish On Jan 31, 7:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow I tried the code suggested by you. It s working Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development 600,000 records into an Oracle database ? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38 pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save theRownumber by using: CurRow = Target.Row Of course, within youruserformmacros, you can use ActiveCell.Row Now, to launch youruserform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 8:10:47 AM Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow Thanks Paul. My column is selectable.
Re: $$Excel-Macros$$ User form value in current active row
Thank Paul, I don't have ops to attach file on group. Can I send you my file through mail on your personal mail id? - Manish On Jan 31, 7:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User form value in current active row I tried the code suggested by you. It s working Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development 600,000 records into an Oracle database ? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38 pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save the Row number by using: CurRow = Target.Row Of course, within your userform macros, you can use ActiveCell.Row Now, to launch your userform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 8:10:47 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner schreiner_p...@att.net wrote: Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- -- ---- - - 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
Re: $$Excel-Macros$$ User form value in current active row
I tried the code suggested by you. It�s working� Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development �600,000 records into an Oracle database�? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38�pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save the Row number by using: CurRow = Target.Row Of course, within your userform macros, you can use ActiveCell.Row Now, to launch your userform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 8:10:47 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner schreiner_p...@att.net wrote: Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- --�---- - 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 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- 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
Re: $$Excel-Macros$$ User form value in current active row
Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a fresh data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking. Now, about your issue. you're not comfortable when sheet is protected. is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User form value in current active row I tried the code suggested by you. It�s working� Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development �600,000 records into an Oracle database�? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38�pm, Paul Schreiner schreiner_p...@att.net wrote: I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save the Row number by using: CurRow = Target.Row Of course, within your userform macros, you can use ActiveCell.Row Now, to launch your userform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 8:10:47 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner schreiner_p...@att.net wrote: Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- --�---- - - 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
Re: $$Excel-Macros$$ User form value in current active row
Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form value in current active row
Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner schreiner_p...@att.net wrote: Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- ------ 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
Re: $$Excel-Macros$$ User form value in current active row
I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name tab and select View Code. In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The default event may be the Worksheet_Change event or the WorkSheetSelection_Change event. If it's the Change event, use the right-hand pull-down to select the SelectionChange event. This macro will trigger whenever you select a cell on the sheet. It passes the cell range as a variable called Target. Now, the issue here is that if you select more than one cell, the Target variable is an array instead of a single range. So, I usually test it: if (Target.count = 1) then next, test to see if the column of the cell is column B If (Target.Column = 2) then You can save the Row number by using: CurRow = Target.Row Of course, within your userform macros, you can use ActiveCell.Row Now, to launch your userform, use: UserFormName.Show Give that a try. If you need more help, let me know and I'll write it when my macro finishes. (It's loading 600,000 records into an Oracle database.. it takes a while) Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 8:10:47 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner schreiner_p...@att.net wrote: Is column B selectable? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to make changes to other cells, but to make changes to column B, you'll have to know the password and unprotect the sheet. Paul From: Manish pansari.man...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User form value in current active row Dear Excel Experts, Can you please suggest me the code for following task. My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- ------ - 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 -- -- 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$$ User Form Help
Hello, I need some help in creating an user form or input screen in excel so I can input two number manually...my code is as follows: I need to create some type of input box for specifying range numbers 1) f Range(WS_RANGE).Value 6465 And Range(WS_RANGE).Value 6469 Then and 2) If Range(WS_RANGE).Value 5943 And Range(WS_RANGE).Value 5946 Then So each input box will have 2 fields for prices and as soon as I input those prices it automatically updates those prices in my codeplease advice... Private Sub Worksheet_Calculate() Const WS_RANGE As String = B1'== change to suit CurrentValue = Range(WS_RANGE) On Error GoTo ws_exit Application.EnableEvents = False Application.Undo PriorValue = Range(WS_RANGE) Range(WS_RANGE).Offset(0, -1) = CurrentValue If PriorValue = CurrentValue Then GoTo ws_exit 'cell B1 did not change If Range(WS_RANGE).Value 6465 And Range(WS_RANGE).Value 6469 Then Call BuyBeans End If If Range(WS_RANGE).Value 5943 And Range(WS_RANGE).Value 5946 Then Call SellBeans End If ws_exit: Application.EnableEvents = True End Sub --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---
