Populate data in to worksheet from VBA data Entry form

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
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,841
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top