Re-Populate User Forms

[Sam2]

Hi,

I'm using a user form for users to select data, then once finished its populated on an excel spreadsheet, i have no problems with part, but my question is if the users need to change any part of the historical data, which is assigned a task number how do i repopulate the user form with that particular task information? Once they are happy the data is re-applied to the same row?

Any help would be appreciated..

[Toppers]

Use MATCH:

Dim res as variant

res=Application.match(<TaskiD>,<ListTaskIDs>,0)
If iserror(res) then
Msgbox <Taskid> & "not found"
else
' get data
res=<row number>
textbox1.value=worksheets("Data").cells(res,"C")
....
.....
end if

Where
<Taskid> is task id to match on
<ListTaskIds> is list of task iDs e.g. named range (starting at row 1
...A1:A200 so res returns correct row number)

HTh

"Sam2" wrote:

>
> Hi,
>
> I'm using a user form for users to select data, then once finished its
> populated on an excel spreadsheet, i have no problems with part, but my
> question is if the users need to change any part of the historical data,
> which is assigned a task number how do i repopulate the user form with
> that particular task information? Once they are happy the data is
> re-applied to the same row?
>
> Any help would be appreciated..
>
>
> --
> Sam2
> ------------------------------------------------------------------------
> Sam2's Profile: http://www.excelforum.com/member.php...o&userid=32899
> View this thread: http://www.excelforum.com/showthread...hreadid=527131
>
>