Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
Please can i have some help??
i have a list box, the data contained is: Staff no. (Column A), First Name (Column B), surname (Column C) i want to use a double click command what will display data from the row on whcihc the data is contained (the list box is filled using a search feature that will only display the specific records needed) i have tried using the list value (that would be cell.value + " " + cell.offset(0,1).value + " " + cell.offset(0,2).value, but this has not worked!!) Please provide any help necessary for this project. Many thanks, Robert Couchman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
Isn't staff no unique?
With Worksheets("Employees") set rng = .Range(.cells(2,1),.cells(rows.count,1).End(xlup)) End with res = Application.Match(clng(strStaffno),rng,0) if not iserror(res) then msgbox "Row is " & rng(res).Row End if -- Regards, Tom Ogilvy "Robert Couchman" wrote in message ... Please can i have some help?? i have a list box, the data contained is: Staff no. (Column A), First Name (Column B), surname (Column C) i want to use a double click command what will display data from the row on whcihc the data is contained (the list box is filled using a search feature that will only display the specific records needed) i have tried using the list value (that would be cell.value + " " + cell.offset(0,1).value + " " + cell.offset(0,2).value, but this has not worked!!) Please provide any help necessary for this project. Many thanks, Robert Couchman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
Yes... Staff No. is unique... but temp staff do not have a
staff number!! how will i get the data off this row now then?? as when i double click a record in my list it needs to open a form displaying all data for the individual. Thank you for your help tho Tom! Robert Couchman -----Original Message----- Isn't staff no unique? With Worksheets("Employees") set rng = .Range(.cells(2,1),.cells(rows.count,1).End (xlup)) End with res = Application.Match(clng(strStaffno),rng,0) if not iserror(res) then msgbox "Row is " & rng(res).Row End if -- Regards, Tom Ogilvy "Robert Couchman" wrote in message ... Please can i have some help?? i have a list box, the data contained is: Staff no. (Column A), First Name (Column B), surname (Column C) i want to use a double click command what will display data from the row on whcihc the data is contained (the list box is filled using a search feature that will only display the specific records needed) i have tried using the list value (that would be cell.value + " " + cell.offset(0,1).value + " " + cell.offset(0,2).value, but this has not worked!!) Please provide any help necessary for this project. Many thanks, Robert Couchman . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|