| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from userform to a cell on an execel sheet
I'm looking to enter data from a userform to a specific cell on an Excel
spreadsheet, then print a form from this data. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data from userform to a cell on an execel sheet
Private Sub CommandButton1_Click()
With Worksheets("Sheet1") .Range("A1").Value = Userform1.TextBox1.Text .Printout End With UnLoad Userform1 End Sub -- Regards, Tom Ogilvy "David Marshall" <David wrote in message ... I'm looking to enter data from a userform to a specific cell on an Excel spreadsheet, then print a form from this data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem getting data from sheet into txt_boxes in userform | Excel Programming | |||
| Userform data to Excel sheet. | Excel Programming | |||
| Vba add data to cell from userform | Excel Programming | |||
| Populating Sheet Data From A UserForm Combo Box Enabled For Multi-Choices | Excel Programming | |||
| UserForm with Cell Data | Excel Programming | |||
Hybrid Mode
