Re: $$Excel-Macros$$ VBA Code for Hide specific column as per criteria
Dear Experts team Any help on this issue? Regards Amar On Thu, Jan 2, 2014 at 12:38 PM, amar takale wrote: > Dear Experts > > Pls help me on this topic.All detailed give in excel attached. > > Regards > Amar T > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ help!!! creation code from data in cells
hi all i want to creat formula as defined below- - formula needed for creating Student ID Student ID looks like- CC1/ACTI/12/13/01 defination- *Code *legend (Example of data in Cell)Range of data -- CC1 - Course code - (basic computer Course) Around 50 Courses ACTI- Center Code - (Alma Computer Training Institute) Around 10 Centers 12 - month code - (December) 12 Month 13 - Year Code - (2013) 2013-2099 01 - Sr. No. - (1) numerical value 1-99 i have course codes as CC1 for Basic Computer Course , for all 50 Courses. i have Centers Codes as ACTI for Alma Computer tra..., for all centers month,year and sr. no. (serial number range given above) i want that Excel should extract code from data in the cells. Example- Sr. Center name Course Date of Enrol. Code 1ACTISuraj BAsic Computer Course 31/12/13 CC1/ACTI/12/13/01 - i want excel to generate the last cell "code" by Excel. i understand that i will need to create libraries for courses and Centers to convert into Course Code and center codes. what should do? design something via visual basic? i do not know how to use visual basic and not much knowldge of formulas in Excel or is it getting more complex? do i need to use some other software or some program is needed to programmed. microsoft Access and SQL express of any use? hope to get replies soon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails
I'm not sure what the purpose of your macro is. It LOOKS like ComboBox1 has: "CAP, CREAM, DROP". You're trying to select from one of these values in the combobox and load another list (pre_Med_Name_1) But there's a couple of things wrong with this approach. First, the Range() object only has a .Value if the range is a single cell. Otherwise, it's an array of values in .Value2 Like: for inx = 1 to ubound(Range("CAP").Value2) debug.print Range("CAP").Value2(inx,1) next inx Next, from your samples, CAP, CREAM and DROP are single-dimension arrays. >From the "help" for .List, .List can be used to load a combobox or listbox if loading multi-dimensional arrays: Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Rupesh Patil >To: excel-macros@googlegroups.com >Sent: Thursday, January 2, 2014 3:07 AM >Subject: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect >'_Globle fails > >Hi expert > > >Please look below code and tell me why I am getting this error(Mentions in >subject line) > Private Sub ComboBox1_Click() > Select Case ComboBox1 > Case "CAP" > pre_Med_Name_1.List = Range("CAP").Value > > > Case "CREAM" > pre_Med_Name_1.List = Range("CREAM").Value > > > Case "DROP" > pre_Med_Name_1.List = Range("DROP").Value > > > End Select > > With pre_Med_Name_1 > .SetFocus > Application.SendKeys ("%{DOWN}") > End With >End Sub > > >Private Sub UserForm_Initialize() > Dim sht1 As Worksheet > Set sht1 = ThisWorkbook.Sheets("Res_Do_not_Change") > > ComboBox1.List = Application.Transpose(sht1.Range("A1") _ > .CurrentRegion.Rows(1).Value) > > >End Sub > > > > > > >My Excel File structure is > > > A B C > >1 CAP CREAM DROP >2 Ibubid TR Ciplox Crocin >3 Inflapen CR Acivir Crocin Paed >4 Artincerin Okavir Pacimol >5 Diasol Cyclovir Oxalgin > > >Please help me on this. Actually I am doing this for dependent combo box > > >if I am doing it wrong way then please give me suggestion code > > >Thanks in advance -- >Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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.goo
Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails
Dear Rupesh, Kindly share the workbook with us. Warm Regards, Gawli Anil On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil wrote: > Hi expert > > Please look below code and tell me why I am getting this error(Mentions in > subject line) > Private Sub ComboBox1_Click() > Select Case ComboBox1 > Case "CAP" > pre_Med_Name_1.List = Range("CAP").Value > > Case "CREAM" > pre_Med_Name_1.List = Range("CREAM").Value > > Case "DROP" > pre_Med_Name_1.List = Range("DROP").Value > > End Select > > With pre_Med_Name_1 > .SetFocus > Application.SendKeys ("%{DOWN}") > End With > End Sub > > Private Sub UserForm_Initialize() > Dim sht1 As Worksheet > Set sht1 = ThisWorkbook.Sheets("Res_Do_not_Change") > > ComboBox1.List = Application.Transpose(sht1.Range("A1") _ >.CurrentRegion.Rows(1).Value) > > > End Sub > > > > My Excel File structure is > > A B C >1 CAP CREAM DROP 2 Ibubid TR Ciplox Crocin 3 Inflapen CR > Acivir Crocin Paed 4 Artincerin Okavir Pacimol 5 Diasol Cyclovir > Oxalgin > > Please help me on this. Actually I am doing this for dependent combo box > > if I am doing it wrong way then please give me suggestion code > > Thanks in advance > > > -- > Thanks and Regards, Rp. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails
Hi expert Please look below code and tell me why I am getting this error(Mentions in subject line) Private Sub ComboBox1_Click() Select Case ComboBox1 Case "CAP" pre_Med_Name_1.List = Range("CAP").Value Case "CREAM" pre_Med_Name_1.List = Range("CREAM").Value Case "DROP" pre_Med_Name_1.List = Range("DROP").Value End Select With pre_Med_Name_1 .SetFocus Application.SendKeys ("%{DOWN}") End With End Sub Private Sub UserForm_Initialize() Dim sht1 As Worksheet Set sht1 = ThisWorkbook.Sheets("Res_Do_not_Change") ComboBox1.List = Application.Transpose(sht1.Range("A1") _ .CurrentRegion.Rows(1).Value) End Sub My Excel File structure is A B C 1 CAP CREAM DROP 2 Ibubid TR Ciplox Crocin 3 Inflapen CR Acivir Crocin Paed 4 Artincerin Okavir Pacimol 5 Diasol Cyclovir Oxalgin Please help me on this. Actually I am doing this for dependent combo box if I am doing it wrong way then please give me suggestion code Thanks in advance -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.