Coding for Userforms
 

I've created a userform which has a lot of stuff like combo boxes, option
boxes, text boxes. Since I'm relatively new to this I was wondering if I
could get any help on as to how to code for stuff like combo boxes. Is it
possible to add stuff into combo boxes that will automatically be inserted
into the excel spreadsheet. Where can I get some sample code for reference?

Also, my each row on my spreadsheet has columns that do several calculations
using data from other columns in the same row. So if I need to add a new row
using the combo box, will it be possible for the formulas for the other
cells to be added as well in the new row?? Thanks in advance

Coding for Userforms
 

With Worksheets("Data")
i = .cells(rows.count,1).End(xlup)(2).Row
.cells(i,1).Entirerow.Insert
.cells(i,1).Value = Userform1.Combobox1.Value
.cells(i,2).Resize(1,5).FillDown
End with
--
Regards,
Tom Ogilvy

"Abhay Sanan" wrote in message
...
I've created a userform which has a lot of stuff like combo boxes, option
boxes, text boxes. Since I'm relatively new to this I was wondering if I
could get any help on as to how to code for stuff like combo boxes. Is it
possible to add stuff into combo boxes that will automatically be inserted
into the excel spreadsheet. Where can I get some sample code for
reference?

Also, my each row on my spreadsheet has columns that do several
calculations
using data from other columns in the same row. So if I need to add a new
row
using the combo box, will it be possible for the formulas for the other
cells to be added as well in the new row?? Thanks in advance

Coding for Userforms
 

Abhay

Abhay Sanan wrote:
I've created a userform which has a lot of stuff like combo boxes,
option boxes, text boxes. Since I'm relatively new to this I was
wondering if I could get any help on as to how to code for stuff like
combo boxes. Is it possible to add stuff into combo boxes that will
automatically be inserted into the excel spreadsheet. Where can I get
some sample code for reference?

You can look through the help files for some sample code. Use F2 in the VBE
to open the object browser. Browse through the MSForms library (make sure
you have a workbook with a userform open).

Also, you can browse around here
http://www.dicks-blog.com/archives/c...-and-controls/

If you have more specific questions when you've been through that, be sure
to post back.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com