VBA code for userform

[Fahad Saleem]

Hello everyone,

This is Muhammad Fahad Saleem. I'm trying to develop Excel automated invoice generator with the help of vba. I made to 2 different userforms. First one is for customer information and second is for Item description etc. In second userform I want to code it like when I fill all the fields and press Add button, the data in this userform will go to the excel sheet row 15 and userform remain open and how much time I press Add button the data will go to the next row and than next. But whenever I start making Invoice the data adding will starts from Row 15.

Please help me in this regard. I will be very thankful to you.

 

[NdNoviceHlp]

Muhammad please post the add button code. HTH. Dave

 

[Fahad Saleem]

what will be the code. Kindly explain me with code example.
As there are 2 combobox in userform and 4 textbox. Namely,
cmb_Product_Name
cmb_Type
txt_Qty
txt_Value_Ex
txt_Tax
txt_Value_Inc

 

[NdNoviceHlp]

Ok so far I get that U have 2 userforms. The userform that U R currently referring to has 4 textboxes and 2 comboboxes. U would like to have a command button to add the contents of the textboxes and/or comboboxes to some sheet starting at row 15. U will need to state exactly what sheet and what columns U want to hold the data from each control (ie. txt_Qty in sheet1 column "A", Txt_Value_Ex in "B" etc) I understand that U want to start in row 15 and continue onward until some point in time when U start again in row 15.... when does this occur? The more specific U R the easier it is to help. Dave