The textbox control is the closest to what you want. You will have to use
several controls to get all the functionality you want.
Here is a start:
XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514
XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749
http://j-walk.com/ss/excel/tips/tip84.htm
http://www.contextures.on.ca/xlUserForm01.html
Basically you have to write your own code to provide the functionality you
describe.
--
Regards,
Tom Ogilvy
"Keith74" wrote:
Hi All
I have a list of data with various columns, two of which the user
needs to be able to edit the displayed data. Additionally the user
need to be able to make a selection from the displayed data, so these
rows can have some further processing later on. The closest i know is
the listview control but so far i haven't been able to work out a way
to make any of the data in the column editable.
Any advice on how to do this or which control i should be using would
be greatly appreciated.
Thanks
Keith