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
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: Binary data
