Hi, Give a look at the attached file (note that items were entered only for « milk » and « vegetable »
Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Deepak Rawat Envoyé : vendredi 17 décembre 2010 05:58 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Is it a Challenge!!!!! Hi i have posted this problem two times but got no reply Is it a challenge!!! Dear All I am designing a user form but new to this, so i need help on prgramming. The logic i am mentioning here as under: Threre are 2 comboBoxes, one calender, and amount file. What i want 1. Which date i would select that should show in Label4 2. First i would select an Type from ComboBox1("cboType") 3. Then there should items should come in second ComboBox("cboItem") 4. Then user will fill the amount and then enter 5. Finally all the data should be entered in the excel sheet as i press Enter For Example I would select in first ComboBox("cboType) "Milk" then there should come automatically some items like "Full Cream Milk", "Poly Pack" in the in second combobox("cboItem") and finally all the data should be entered in the excel sheet as the user press Enter File is attached!! Regards, Deepak Rawat -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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/pages/discussexcelcom/160307843985936?v=wall <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > &ref=ts -- ---------------------------------------------------------------------------- ------ 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> http://exceldailytip.blogspot.com To post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Expense Entry Workbook.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
