$$Excel-Macros$$ Use of ADO Connection in Excel Macro
Dear Experts,
Below mentioned code is to copy data from Sheet1 of all files at specified
location and paste in active Sheet. For regular up-dation on weekly basis,
it is needed to make this macro flexible with use of ADO Connection. It
will allow us to choose required folder, select one or more latest files
with shift/control button and get data pasted below last row of used range
of current sheet. I tried to use below ADO option but could not get
success. Please help to use it in below mentioned code. Thanks
Application.GetOpenFilename(filefilter:="Excel Files (*.xl*),
*.xl*",MultiSelect:=True)
-
Sub Data_Merge_From_All_Files()
Dim bookList As Workbook
Dim mergeObj, dirObj, filesObj, everyObj As Object
Application.ScreenUpdating = False
Set mergeObj = CreateObject("Scripting.FileSystemObject")
Set dirObj = mergeObj.Getfolder("D:\Test")
Set filesObj = dirObj.Files
For Each everyObj In filesObj
Set bookList = Workbooks.Open(everyObj)
Range("A2:Q50" & Range("A65536").End(xlUp).Row).Copy
ThisWorkbook.Worksheets(1).Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
Application.CutCopyMode = False
bookList.Close
Next
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.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Add control on button click
Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Dec 21, 2014 at 1:38 PM, Rupesh Patil wrote: > Hello Vaibhav, > > Very very thank you Vaibhav. Excellent work. Perfect solution. I am really > really appreciate your time. > My senior will be happy because of you only. Once again very very.. thank > you Vaibhav. > > On Sat, Dec 20, 2014 at 5:32 PM, Vaibhav Joshi wrote: > >> Hi >> >> Check this...macro adds textbox (text box) & commandbutton (command >> button) in run time, so i started with blank form, it loaded 3 rows in the >> beginning.. i kept at as standard you can not deleted beyond the 3 rows :P >> :/ >> >> I did changed add button position, i thought insted giving as option to >> user for selecting no. of rows to be added! >> >> Also to look design good i kept remove button for first 3 rows & also >> added remove button for each new row added.. >> >> I found it difficult to re locating button on deleting one row, so i >> changed the logic a bit, on clicking delete button macro will count number >> of rows & will load new userform with one row less.. in run time you can >> find which row is deleted through class module code & you can re-arrange >> your basic data!! >> >> it was a bit challenging but had good requirement after long time ! >> >> >> Cheers!! >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Fri, Dec 19, 2014 at 6:00 PM, Rupesh Patil > > wrote: >> >>> Hello Vaibhav, >>> >>> 2nd approach full fill my requirement. >>> >>> 1) Add text boxes vertically. >>> 2) resize form that is fine. >>> >>> Vaibhav very very thank you for looking into my requirement. >>> >>> On Fri, Dec 19, 2014 at 5:31 PM, Vaibhav Joshi wrote: Hi Rupesh, there is 2 methids thru which this can be achieved!! 1st comparatively easy, creating pre-defined no. of extra text box & hiding them, on clicking add unhide them & resize the form. 2ns Add text boxes on every click, this requires to identify place for new text box & resize of forms! Since you have not shared your comlete requirement pl let us know which method suits you... Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Dec 19, 2014 at 1:31 PM, Rupesh Patil < patil.rupesh1...@gmail.com> wrote: > > Hello Vaibhav, > > I want add text boxes on button click on userfrom(Runtime). please > find example sheet in attachment. > > On Fri, Dec 19, 2014 at 12:28 PM, Vaibhav Joshi wrote: >> >> Hi >> >> can you elaborate what exactly you want with example.. >> >> Cheers!! >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Thu, Dec 18, 2014 at 11:33 PM, Rupesh Patil < >> patil.rupesh1...@gmail.com> wrote: >>> >>> How to add controls on every time button click >>> >>> -- >>> 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 questio
$$Excel-Macros$$ VALUE TO PASTE IN OTHER PLACE - WHEN EVER U CHANGE THE PARTICULAR CELL
Hellow Friends 1] I am changing the value of -- Sheet6-C22 - everytime 2] The same value should be pasted in the box show B4 : g13 3] The 1 st change in c22 - pasted on b4 of sheet1 4] The 2 nd change in c22 - pasted on c4 of sheet1 & so onIs it possible through excel macro If possible you give me the guidelines so that if I want to change the box or cell then I can do it my own.Thank you in advance. -- 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. sample file.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro for Ageing of Inventory
Hi, The formula added does not help in case Available Qty is less than last purchase qty. Further, Ageing can be located in more than a period.Please see red marked result. Formula need to be executed for line items more than 12000. Do Not believe a formula can solve this. Thanks a lot for your support . Regards, C.G.Kumar On Mon, Dec 22, 2014 at 10:15 AM, Ashish Bhalara wrote: > Mr.C.G.Kumar > See attached file as your require function. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar > wrote: > >> Hi, >> >> I have purchase data in a spreadsheet and List of Inventory Items on >> another worksheet of excel. >> >> May someone help me with a macro or advance formula which computes Ageing >> of Inventory. >> >> Age of Inventory is calculated in Purchase Sheet but do not know how to >> compute for available qty only. >> >> Sample Sheet attached. >> >> >> -- >> 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://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Ageing Inventory_Kumar.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Cash Flow Dashboard
Hi, I would appreciate if anyone can help me with Cash Flow Dashboard. Many Thanks, C.G.Kumar -- 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$$ Macro for Ageing of Inventory
Mr.C.G.Kumar See attached file as your require function. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar wrote: > Hi, > > I have purchase data in a spreadsheet and List of Inventory Items on > another worksheet of excel. > > May someone help me with a macro or advance formula which computes Ageing > of Inventory. > > Age of Inventory is calculated in Purchase Sheet but do not know how to > compute for available qty only. > > Sample Sheet attached. > > > -- > 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. Ageing Inventory.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Macro for Ageing of Inventory
Hi, I have purchase data in a spreadsheet and List of Inventory Items on another worksheet of excel. May someone help me with a macro or advance formula which computes Ageing of Inventory. Age of Inventory is calculated in Purchase Sheet but do not know how to compute for available qty only. Sample Sheet attached. -- 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. Ageing Inventory.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Vba Query
Dear All, PFA. there have two column we want find data from current Status as like in output column. According output record already available in current status column. Please Solve it by vba. Regards Sanjai kumar -- 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. Query.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ How to remove excel macros from multiple closed files
Try to open file one by one using macro n save it as macro free workbook . Xlsx Cheers On Dec 21, 2014 1:03 PM, "Zafar Iqbal" wrote: > I have +500 Excel files (*.xls) having macros, all located in same folder. > I want to remove all macros from these files. Removing macros manually one > by one from these files will take too much time. Is it possible to create a > new macro in a separate excel file which will remove all macros from these > closed files? Thanks for your guidance in advance. > Regards, > Zafar Iqbal > > -- > 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.
Re: $$Excel-Macros$$ Add control on button click
Hello Vaibhav, Very very thank you Vaibhav. Excellent work. Perfect solution. I am really really appreciate your time. My senior will be happy because of you only. Once again very very.. thank you Vaibhav. On Sat, Dec 20, 2014 at 5:32 PM, Vaibhav Joshi wrote: > Hi > > Check this...macro adds textbox (text box) & commandbutton (command > button) in run time, so i started with blank form, it loaded 3 rows in the > beginning.. i kept at as standard you can not deleted beyond the 3 rows :P > :/ > > I did changed add button position, i thought insted giving as option to > user for selecting no. of rows to be added! > > Also to look design good i kept remove button for first 3 rows & also > added remove button for each new row added.. > > I found it difficult to re locating button on deleting one row, so i > changed the logic a bit, on clicking delete button macro will count number > of rows & will load new userform with one row less.. in run time you can > find which row is deleted through class module code & you can re-arrange > your basic data!! > > it was a bit challenging but had good requirement after long time ! > > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Dec 19, 2014 at 6:00 PM, Rupesh Patil > wrote: > >> Hello Vaibhav, >> >> 2nd approach full fill my requirement. >> >> 1) Add text boxes vertically. >> 2) resize form that is fine. >> >> Vaibhav very very thank you for looking into my requirement. >> >> On Fri, Dec 19, 2014 at 5:31 PM, Vaibhav Joshi wrote: >>> >>> Hi >>> >>> Rupesh, there is 2 methids thru which this can be achieved!! >>> >>> 1st comparatively easy, creating pre-defined no. of extra text box & >>> hiding them, on clicking add unhide them & resize the form. >>> 2ns Add text boxes on every click, this requires to identify place for >>> new text box & resize of forms! >>> >>> Since you have not shared your comlete requirement pl let us know which >>> method suits you... >>> >>> Cheers!! >>> >>> + >>> *I did not do this for you. God is here working through me for you.* >>> >>> On Fri, Dec 19, 2014 at 1:31 PM, Rupesh Patil < >>> patil.rupesh1...@gmail.com> wrote: Hello Vaibhav, I want add text boxes on button click on userfrom(Runtime). please find example sheet in attachment. On Fri, Dec 19, 2014 at 12:28 PM, Vaibhav Joshi wrote: > > Hi > > can you elaborate what exactly you want with example.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Dec 18, 2014 at 11:33 PM, Rupesh Patil < > patil.rupesh1...@gmail.com> wrote: >> >> How to add controls on every time button click >> >> -- >> 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 confidentia
