View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Drag & Drop Form Elements

I have a list of items on a sheet that populate a set of text boxes on a
userform. The controls are filled based on the order of a column on the
same sheet.

I wish to provide the user the ability to drag and drop the items, from say
a list box, onto each textbox, as they are 'copied' across the order in
which they appear is stored on worksheet.. This list is then used to
re-fill the controls when the user form is re-opened.

Any thoughts as to the best way of achieving this??



--
Cheers
Nigel