Please Help- Need simple VB code (similar to Macro)
Hi
I am new to this and do not have prior knowledge of VB. I need a VB code for a simple task. 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.
I would appreciate if anyone could help me out with this.