Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi again (have been posted in Excel Programming also - sorry)
I would like to know how to write back the data from a form upon accept. The form is activatied from a dubble_click on sheet2 (Tasklist), but I can't figure out how to write the data back the the same row . I would also appriciate some help on how to make a "next/previus" button work. I have simplified the code below to be more illustrative: Sheet2(Tasklist): Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Row 4 Then Select Case Target.Column Case 1 'initialize Tasklist form frmTaskList.cboPriority.Value = Target.Offset(0, 7) frmTaskList.txtHeadLine.Value = Target.Offset(0, 8) 'Call Tasklist form frmTaskList.Show End Select End If End Sub Forms: frmTasklist: Private Sub cmdAccept_Click() If Me.cboPriority.Value = "" Then MsgBox "Please enter Priority 1, 2 or 3 with 1 critical priority.", vbExclamation, "Task Values" Me.cboPriority.SetFocus Exit Sub End If 'write data back to sheet tasklist in the correct row? ??? End Sub Hope fore some help again :-) /Steen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I write 3/5 in a cell and have it look like 03-May back? | Excel Discussion (Misc queries) | |||
write formula that icludes data from sheet 1 to sheet 2 of my spr | Excel Worksheet Functions | |||
File in 2007 form - need to get back to 2003 form... | Excel Discussion (Misc queries) | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions |