Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from userform into worksheet cells
Hi everyone
I am trying to create an Excel database. I have created a userform with several text boxes and combo boxes. This runs on opening the file. My plan is to be able to click on a command button and have the boxes contents go to the next empty row on the sheet. I have managed to create code to select the first cell of the empty row and fill "A" with a sequential number. How do I fill the row with the data from the boxes??? All advice accepted! Kenny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from userform into worksheet cells
assume you have the cell with A selected
SeqNo = SeqNo + 1 Cells(rows.count,1).End(xlup).Offset(0,1).Select With Userform1 ActiveCell.Value = SeqNo ActiveCell.offset(0,1).Value = .Textbox2.Text ActiveCell.Offset(0,2).Value = .Combobox1.Value ActiveCell.Offset(0,3).Value = .Textbox3.Text End With -- Regards, Tom Ogilvy "Newbie1" wrote in message ... Hi everyone I am trying to create an Excel database. I have created a userform with several text boxes and combo boxes. This runs on opening the file. My plan is to be able to click on a command button and have the boxes contents go to the next empty row on the sheet. I have managed to create code to select the first cell of the empty row and fill "A" with a sequential number. How do I fill the row with the data from the boxes??? All advice accepted! Kenny |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data from userform into worksheet cells
Thanks guys for the code and links - just what I needed
Kenny "Newbie1" wrote in message ... Hi everyone I am trying to create an Excel database. I have created a userform with several text boxes and combo boxes. This runs on opening the file. My plan is to be able to click on a command button and have the boxes contents go to the next empty row on the sheet. I have managed to create code to select the first cell of the empty row and fill "A" with a sequential number. How do I fill the row with the data from the boxes??? All advice accepted! Kenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet form vs. Userform...which is better? | Excel Discussion (Misc queries) | |||
How can I use a worksheet while running a userform? | Excel Programming | |||
autorun userform from worksheet | Excel Programming | |||
Populate Userform text boxes in VBA with VLookup data from #2 worksheet | Excel Programming | |||
Taking Data of cell from worksheet to a userform window | Excel Programming |