Linking userforms to Excell Worksheet

  • Thread starter Thread starter shivun pilwal
  • Start date Start date
S

shivun pilwal

Hi

I have created a userform with textboxes, radio buttons, check boxes etc.

When a user opens the user form and fills it out i want the data to be
entered in to certain columns in the excell worksheet.


Any help would be highly appreciated.

Regards

shiv
 
Hi

SOmething like this in the userform module:

R = 12
With ActiveWorkbook.Sheets(1)
.cells(R, 1).Value = Me.textbox1.Text
.cells(R, 2).Value = Me.textbox2.Text
.cells(R, 3).Value = Me.Optionbutton1.Value
.cells(R, 4).Value = Me.Combobox1.Listindex
....and so on.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Userform Textbox to Worksheet Textbox 1
Userform to enter data on worksheet 2
Automatically increment a unique number when filling in a userform in excel 1
Allow text in locked cells on a worksheet from a userform 16
DataSource for ComboBox in UserForm 3
VBA userform Vlookup Excel 1
Userform to Fill Database 2

Back
Top