Re: $$Excel-Macros$$ Add Control On button click on Page
Thanks Paul, for being with me. I am working on one project called Examination Tool for Doctors. Where doctor can do there consultation using this tool. in this tool have one module and userform call Prescriptions. On this userform doctor may add 2 medicines or may be 10, so I want one row of 5 textboxes added at the time form initialization, after that when doctor click on "New Drug" button every time row of 5 text boxes should be add(down to above added textboxes). add five rows text boxes at time initialization and make one row at time visible on every time button click this approch I am using right know On Tue, Jul 15, 2014 at 9:13 PM, Paul Schreiner wrote: > OK, but WHY? > > Can you not simply have the userform filled with the appropriate number of > boxes and have them turned off? > then, when you hit the button, simply change the visibility to "on" > (.Visible = true) > > ? > > I've done it both ways, but only actually create the objects if the number > i need is not known. > In which case I also change the size of the userform to accommodate the > extra objects. > > in your case, your userform could accomodate about 3 more rows of boxes. > why not put them in and hide them until you need them? > > unless you DO want to increase the size of the userform to add many more > rows. > > *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:* Tuesday, July 15, 2014 10:36 AM > > *Subject:* Re: $$Excel-Macros$$ Add Control On button click on Page > > Hello Paul, > > I am so sorry that I am not clear enough. > I want add 5 text boxes on each time button click. > > > > > On Mon, Jul 14, 2014 at 5:13 PM, Paul Schreiner > wrote: > > I'm sorry, there just doesn't seem to be enough information to figure out > what it is you want to do! > > Are you saying you wish to add information to the worksheet when you hit > the button? > or are you wanting to create another set of text boxes on the userform? > > If you're wanting to create new text boxes: how many? > Could you instead have them already created, and simply set the > .Visibility = false until you hit the button? > > *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:* Monday, July 14, 2014 6:52 AM > *Subject:* Re: $$Excel-Macros$$ Add Control On button click on Page > > Hello Expert, > > Please help > > > On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil > wrote: > > Any suggestions > Experts > On 12-Jul-2014 11:33 AM, "Rupesh Patil" > wrote: > > > Hello Expert, > > I need a help from you. I want to add textbox on page when each time > button click and add rows in excel for that textbox. > > I have attache sample file with this mail. > > There is two page on user form, On prescription page there are four text > boxes, I wanted to add textbox on "New Drugs" Button every time click one > below the other. > > > > Please help > > -- > Thanks and Regards, > Rupesh > . > -- > 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
Re: $$Excel-Macros$$ Add Control On button click on Page
OK, but WHY? Can you not simply have the userform filled with the appropriate number of boxes and have them turned off? then, when you hit the button, simply change the visibility to "on" (.Visible = true) ? I've done it both ways, but only actually create the objects if the number i need is not known. In which case I also change the size of the userform to accommodate the extra objects. in your case, your userform could accomodate about 3 more rows of boxes. why not put them in and hide them until you need them? unless you DO want to increase the size of the userform to add many more rows. 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: Tuesday, July 15, 2014 10:36 AM >Subject: Re: $$Excel-Macros$$ Add Control On button click on Page > > > >Hello Paul, > > >I am so sorry that I am not clear enough. >I want add 5 text boxes on each time button click. > > > > > > >On Mon, Jul 14, 2014 at 5:13 PM, Paul Schreiner wrote: > >I'm sorry, there just doesn't seem to be enough information to figure out what >it is you want to do! >> >>Are you saying you wish to add information to the worksheet when you hit the >>button? >>or are you wanting to create another set of text boxes on the userform? >> >>If you're wanting to create new text boxes: how many? >>Could you instead have them already created, and simply set the .Visibility = >>false until you hit the button? >> >>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: Monday, July 14, 2014 6:52 AM >>>Subject: Re: $$Excel-Macros$$ Add Control On button click on Page >>> >>> >>> >>>Hello Expert, >>> >>> >>>Please help >>> >>> >>> >>>On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil >>>wrote: >>> >>>Any suggestions >>>>Experts >>>>On 12-Jul-2014 11:33 AM, "Rupesh Patil" wrote: >>>> >>>> >>>>> >>>>>Hello Expert, >>>>> >>>>> >>>>>I need a help from you. I want to add textbox on page when each time >>>>>button click and add rows in excel for that textbox. >>>>> >>>>> >>>>>I have attache sample file with this mail. >>>>> >>>>> >>>>> >>>>>There is two page on user form, On prescription page there are four text >>>>>boxes, I wanted to add textbox on "New Drugs" Button every time click one >>>>>below the other. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>Please help >>>>>-- >>>>> >>>>>Thanks and Regards, Rupesh . -- >>>>>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.
Re: $$Excel-Macros$$ Add Control On button click on Page
Hello Paul, I am so sorry that I am not clear enough. I want add 5 text boxes on each time button click. On Mon, Jul 14, 2014 at 5:13 PM, Paul Schreiner wrote: > I'm sorry, there just doesn't seem to be enough information to figure out > what it is you want to do! > > Are you saying you wish to add information to the worksheet when you hit > the button? > or are you wanting to create another set of text boxes on the userform? > > If you're wanting to create new text boxes: how many? > Could you instead have them already created, and simply set the > .Visibility = false until you hit the button? > > *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:* Monday, July 14, 2014 6:52 AM > *Subject:* Re: $$Excel-Macros$$ Add Control On button click on Page > > Hello Expert, > > Please help > > > On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil > wrote: > > Any suggestions > Experts > On 12-Jul-2014 11:33 AM, "Rupesh Patil" > wrote: > > > Hello Expert, > > I need a help from you. I want to add textbox on page when each time > button click and add rows in excel for that textbox. > > I have attache sample file with this mail. > > There is two page on user form, On prescription page there are four text > boxes, I wanted to add textbox on "New Drugs" Button every time click one > below the other. > > > > Please help > > -- > Thanks and Regards, > Rupesh > . > -- > 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. > > > > > -- > 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/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 RUL
Re: $$Excel-Macros$$ Add Control On button click on Page
I'm sorry, there just doesn't seem to be enough information to figure out what it is you want to do! Are you saying you wish to add information to the worksheet when you hit the button? or are you wanting to create another set of text boxes on the userform? If you're wanting to create new text boxes: how many? Could you instead have them already created, and simply set the .Visibility = false until you hit the button? 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: Monday, July 14, 2014 6:52 AM >Subject: Re: $$Excel-Macros$$ Add Control On button click on Page > > > >Hello Expert, > > >Please help > > > >On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil >wrote: > >Any suggestions >>Experts >>On 12-Jul-2014 11:33 AM, "Rupesh Patil" wrote: >> >> >>> >>>Hello Expert, >>> >>> >>>I need a help from you. I want to add textbox on page when each time button >>>click and add rows in excel for that textbox. >>> >>> >>>I have attache sample file with this mail. >>> >>> >>> >>>There is two page on user form, On prescription page there are four text >>>boxes, I wanted to add textbox on "New Drugs" Button every time click one >>>below the other. >>> >>> >>> >>> >>> >>> >>>Please help >>>-- >>> >>>Thanks and Regards, Rupesh . -- >>>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. >>> > > > >-- > >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/d/optout. > > > -- Are you =EXP(E:RT) or =N
Re: $$Excel-Macros$$ Add Control On button click on Page
Hello Expert, Please help On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil wrote: > Any suggestions > Experts > On 12-Jul-2014 11:33 AM, "Rupesh Patil" > wrote: > >> >> Hello Expert, >> >> I need a help from you. I want to add textbox on page when each time >> button click and add rows in excel for that textbox. >> >> I have attache sample file with this mail. >> >> There is two page on user form, On prescription page there are four text >> boxes, I wanted to add textbox on "New Drugs" Button every time click one >> below the other. >> >> >> >> Please help >> >> -- >> Thanks and Regards, >> Rupesh >> . >> >> -- >> 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. >> > -- 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/d/optout.
Re: $$Excel-Macros$$ Add Control On button click on Page
Any suggestions Experts On 12-Jul-2014 11:33 AM, "Rupesh Patil" wrote: > > Hello Expert, > > I need a help from you. I want to add textbox on page when each time > button click and add rows in excel for that textbox. > > I have attache sample file with this mail. > > There is two page on user form, On prescription page there are four text > boxes, I wanted to add textbox on "New Drugs" Button every time click one > below the other. > > > > Please help > > -- > Thanks and Regards, > Rupesh > . > > -- > 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.
$$Excel-Macros$$ Add Control On button click on Page
Hello Expert, I need a help from you. I want to add textbox on page when each time button click and add rows in excel for that textbox. I have attache sample file with this mail. There is two page on user form, On prescription page there are four text boxes, I wanted to add textbox on "New Drugs" Button every time click one below the other. Please help -- Thanks and Regards, Rupesh . -- 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. Runtime add Control.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
