Hello Paul, Thanks for reply
Are you saying that when you hit "Add" you want to add another row of (5) textboxes? Yes, I want to add another row of (5) TextBoxes. And when you hit "Remove", it should remove the row of (5) boxes? Yes, I want to remove row of (5) tesxtboxex. If you remove the second row, what do you want to have happen to the rest? (third row move up to row 2 or ??) Yes, third row move up to row 2. Is there a limit to the number of rows? Yes, for now limit should be 12 rows of text boxes what happens when you exceed the size of the userform? in that case user form increasable accordingly or scroll bar will work. do you want the macro to increase the size of the userform? I want macro for add textboxes on Add button click every time and remove added textboxes on Remove button click. Thanks again for reply, Please help On Wed, Nov 19, 2014 at 6:07 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > Your userform currently has (3) rows of(5) textboxes. > > Are you saying that when you hit "Add" > you want to add another row of (5) textboxes? > > And when you hit "Remove", it should > remove the row of (5) boxes? > > If you remove the second row, what do you want to have happen to the rest? > (third row move up to row 2 or ??) > > Is there a limit to the number of rows? > what happens when you exceed the size of the userform? > do you want the macro to increase the size of the userform? > > *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 <patil.rupesh1...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, November 19, 2014 3:24 AM > *Subject:* Re: $$Excel-Macros$$ Add and remove text box on ever time > button click. > > Please Experts help me out. > > On Tue, Nov 18, 2014 at 5:07 PM, Rupesh Patil <patil.rupesh1...@gmail.com> > wrote: > > Hello Experts, > > any help? > > > On Mon, Nov 17, 2014 at 4:10 PM, Rupesh Patil <patil.rupesh1...@gmail.com> > wrote: > > Hello experts, > > I need your help,I have one userform which attached with mail for your > reference, what I need is add text boxes vertical on button every time > click "Add Button" and remove this text boxes every time on "Remove Button" > click. and Add-Remove row accordingly in sheet. > > -- > Thanks & Regards, > Rupesh Patil, > (9970196189) > . > -- > 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 & Regards, > Rupesh Patil, > (9970196189), > Ayushman Pvt. Ltd. > > > > > -- > Thanks & Regards, > Rupesh Patil, > (9970196189), > Ayushman Pvt. Ltd. > > -- > 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. > -- Thanks & Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- 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.
