Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform data entry
i am new to userforms. i have created a userform that has three text boxes. i
can transfer the data from the userform to a spreadsheet,but what i want to do is direct each entry to specified cells, eg 1:500, do i need another text box to enter a number in it, then code to direct the entry thankyou john |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform data entry
Dim nexrow as Long, rng as Range
With Worksheets("sheet1") nextRow = .Cells(rows.count,1).End(xlup).row if not isempty(.cells(nextRow,1)) then nextrow = nextrow + 1 end if set rng = .Cells(nextRow,1) End with Msgbox "I will enter my data in " & vbNewLine _ rng.Address & " to " & rng.offset(0,2).Address -- Regards, Tom Ogilvy "john tempest" wrote: i am new to userforms. i have created a userform that has three text boxes. i can transfer the data from the userform to a spreadsheet,but what i want to do is direct each entry to specified cells, eg 1:500, do i need another text box to enter a number in it, then code to direct the entry thankyou john |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Userform: listbox and controls' data entry validation | Excel Programming | |||
Validate data in userform data entry | Excel Programming | |||
data entry with userform questions | Excel Programming | |||
Creating a Data Entry Userform | Excel Programming |