UserForm

[WomenPC]

Hi,

I want create a form in excel 2007, but here the issue.

You know that in Excel 2003 if you have an already existing report you can go to
Data > User Form and done...appears a window with the column headers, data, rows everything, but in excel 2007 I don't know how can I pull the existing data in the excel worksheet to the user form. Somebody help me please!

 

[VoG]

Do you mean Table on the Insert menu?

 

[WomenPC]

I want pull part of the data of a report in excel 2007 in a userform 2007.

I want creat a user form but I want that form display part of existing data.

For example:

I have a columns with Name and Address and I would like that user lookup the Name and add information next to column.


Regards,

WomenPC

 

[VoG]

What were called Forms in Excel 2003 are now called Tables. See http://www.jkp-ads.com/articles/Excel2007Tables.asp

 

[xenou]

I just found this note from J-Walk (and an interesting article about his form addin):

By the way, Excel's built-in data entry form is not present in the Excel 2007 UI. To use the feature, you must customize your Quick Access Toolbar and add the Form command from the Commands Not in the Ribbon group.

http://www.dailydoseofexcel.com/archives/2007/07/27/data-entry-form-enhancements/

(to customize the QAT in XL 2007:
Office Button | Excel Options | Customize
or choose More commands from the QAT dropdown arrow)