PLEASE I NEED YOUR HELP

[Waleed Shatnawi]

Dear sir:
I would like to insert a data records as a form
- I use the form... command which is in Data menu
- But i need to create a command button to make a shourcut for this form
- I this feature avaliable in excel please tell me how is it ???????

 

[Nick Hodge]

Waleed

This line will show the dataform

ActiveSheet.ShowDataForm

You will need to check if the data on the sheet is able to display a form
(error check)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Bob Phillips]

Record a macro and assign it to your button.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[KL]

....also, for the ShowDataForm method to work you may want to make sure that
either your table's first cell is within the range [A1:B2] or your table'
range is named "database" (menu Insert>Name>Define, etc.)

Regards,
KL