View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Which form control do i need to do this?

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