To , all the VB Lords in here .. Pl help .

I have a data sheet in Excel and a blank form in the same worksheet.

I want to select a specific Order # from the data sheet and want to fill up
a form with the details of the specific Order # selected. I just want to
click on the Order # cell and want to populate the form. Suppose, if I
select 3 diferent Order # from data sheet....I want the VB code to fill up
the form with the details of all the 3 Order # selected...all in one single
Form.

I have attached the file which has a data sheet, a blank form and a sample
filed-up form.


Thanks
jack



[Edited by jack_sparrow on 24-04-2006 at 09:20 AM GMT]

____________________________
Attached:
Data.zip 4 KB (Downloads: 6)

Hi,
  I would suggest using the double click event on your worksheet.  with something like this :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)     'If user click on column "A"     If Target.Column = 1 Then              'Sample Code Here         Feuil2.Cells(26, 2).Value = Feuil1.Cells(Target.Row, 1).Value         'etc...         'To the same wich each form         Cancel = True     End If End Sub

To use multiple selection, use the Right Click event, and and use the for ... each command to go throuch each selection, using the same principle as above.

Daniel B.

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.