surajitbose
New Member
- Joined
- Jul 7, 2012
- Messages
- 1
with almost 0 knowledge in VBA i have created a Data Form to enter daily voucher with
1 MS Date and time picker
2 TextBox1 for amount (Validate for Numeric value Only) Working fine
3 OptionButton1 for Cash
4 OptionButton2 for Cheque
5 TextBox2 for the name of Person May be I can Change it in to ComboBox
6 TextBox3 for 'Paid for' any value can be entered
7 ComboBox1 for Subcategory (list is in worksheet2 (List) Working fine
8 TextBox4 for Remarks any value can be entered
9 CommandButton1 for add the data into worksheet3(Database)
10CommandButton2 for show the 'database' worksheet
11CommandButton3 for closing the form Working fine
And a CommandButton into sheet1(Form) to open the Form Working fine
I want to enter the data into the form and Populate this data to worksheet3(Database) as
Date in B3 Paid To(C4) Paid For(D4) Sub Category ( E4) Remarks (G4) Amount (H4)
F4 is free for a VLOOKUP
I also want to have a data edit option in the form may be with a auto generate Voucher no with recall option
Can any one help me with the appropriate code for the same
Note: I am creating with office 2007 but also want to use it in Xp Professional
Thanks in advance
1 MS Date and time picker
2 TextBox1 for amount (Validate for Numeric value Only) Working fine
3 OptionButton1 for Cash
4 OptionButton2 for Cheque
5 TextBox2 for the name of Person May be I can Change it in to ComboBox
6 TextBox3 for 'Paid for' any value can be entered
7 ComboBox1 for Subcategory (list is in worksheet2 (List) Working fine
8 TextBox4 for Remarks any value can be entered
9 CommandButton1 for add the data into worksheet3(Database)
10CommandButton2 for show the 'database' worksheet
11CommandButton3 for closing the form Working fine
And a CommandButton into sheet1(Form) to open the Form Working fine
I want to enter the data into the form and Populate this data to worksheet3(Database) as
Date in B3 Paid To(C4) Paid For(D4) Sub Category ( E4) Remarks (G4) Amount (H4)
F4 is free for a VLOOKUP
I also want to have a data edit option in the form may be with a auto generate Voucher no with recall option
Can any one help me with the appropriate code for the same
Note: I am creating with office 2007 but also want to use it in Xp Professional
Thanks in advance